Re: Table Export & Import

2019-03-31 Thread Andreas Kretschmer
On 1 April 2019 08:09:37 CEST, Sathish Kumar wrote: >Hi Team, > >We have a requirement to copy a table from one database server to >another >database server. We are looking for a solution to achieve this with >lesser >downtime on Prod. Can you help us with this? > >Table Size: 160GB >Postgresql Se

Table Export & Import

2019-03-31 Thread Sathish Kumar
Hi Team, We have a requirement to copy a table from one database server to another database server. We are looking for a solution to achieve this with lesser downtime on Prod. Can you help us with this? Table Size: 160GB Postgresql Server Version: 9.5

Re: Gigantic load average spikes

2019-03-31 Thread David Rowley
On Mon, 1 Apr 2019 at 18:08, rihad wrote: > > > What exactly do you mean by "running processes"? I don't think I've ever > > seen a Unix with only 1 to 3 running processes in total, so you are > > probably referring to processes in a certain state. Runnable (R)? > > Uninterruptible sleep (D)? Both

Re: Gigantic load average spikes

2019-03-31 Thread rihad
What exactly do you mean by "running processes"? I don't think I've ever seen a Unix with only 1 to 3 running processes in total, so you are probably referring to processes in a certain state. Runnable (R)? Uninterruptible sleep (D)? Both? Something else? Just that, 250-300 running processes in

Re: Gigantic load average spikes

2019-03-31 Thread Peter J. Holzer
On 2019-03-31 19:23:11 +0400, rihad wrote: > Postgres 10.3 On freebsd 10.3 is almost idle, disk i/o about 5-10%, number > running processes about 1-3, cpu about 90% idle, then we run a i/o heavy job > like "refresh materialized view", cpu & disk i/o still not maxed out, all of > a sudden the number

Re: Regarding pgaudit log_directory

2019-03-31 Thread David Steele
On 3/31/19 8:01 PM, Durgamahesh Manne wrote: On Saturday, March 30, 2019, David Steele > wrote: On 3/29/19 3:32 PM, Durgamahesh Manne wrote:    I could not find parameter related to pgaudit log_directory  . pgAudit does not support logging outside

Regarding pgaudit

2019-03-31 Thread Durgamahesh Manne
Hi Respected postgres team Please let me know open source application interface to monitor the pgaudit log files only as I have installed pgaudit tool Regards Durgamahesh Manne

Regarding pgaudit log_directory

2019-03-31 Thread Durgamahesh Manne
On Saturday, March 30, 2019, David Steele wrote: > On 3/29/19 3:32 PM, Durgamahesh Manne wrote: > >> >>I could not find parameter related to pgaudit log_directory . >> > > pgAudit does not support logging outside the standard PostgreSQL logging > facility and there are no plans for such a fe

Re: Regarding pgaudit log_directory

2019-03-31 Thread Durgamahesh Manne
On Saturday, March 30, 2019, David Steele wrote: > On 3/29/19 3:32 PM, Durgamahesh Manne wrote: > >> >>I could not find parameter related to pgaudit log_directory . >> > > pgAudit does not support logging outside the standard PostgreSQL logging > facility and there are no plans for such a fe

Re: Gigantic load average spikes

2019-03-31 Thread Adrian Klaver
On 3/31/19 8:23 AM, rihad wrote: Postgres 10.3 On freebsd 10.3 is almost idle, disk i/o about 5-10%, number running processes about 1-3, cpu about 90% idle, then we run a i/o heavy job like "refresh materialized view", cpu & disk i/o still not maxed out, all of a sudden the number of running pr

Gigantic load average spikes

2019-03-31 Thread rihad
Postgres 10.3 On freebsd 10.3 is almost idle, disk i/o about 5-10%, number running processes about 1-3, cpu about 90% idle, then we run a i/o heavy job like "refresh materialized view", cpu & disk i/o still not maxed out, all of a sudden the number of running processes increases to about 250-30

Re: Required postgreSQL 10.4 version for Suse enterprise

2019-03-31 Thread Adrian Klaver
On 3/30/19 10:45 PM, Ankit Trivedi wrote: Dear Adrian, Thanks for your prompt reply. But i specifically need 10.4 version. plz provide me steps or rpm for 10.4 https://zypp.postgresql.org/10/suse/sles-12-x86_64/repoview/postgresql10-server.html -- Adrian Klaver adrian.kla...@aklaver.com

Re: Required postgreSQL 10.4 version for Suse enterprise

2019-03-31 Thread Ankit Trivedi
Dear Adrian, Thanks for your prompt reply. But i specifically need 10.4 version. plz provide me steps or rpm for 10.4 On Sat, Mar 30, 2019, 19:23 Adrian Klaver wrote: > On 3/30/19 4:09 AM, Ankit Trivedi wrote: > > > > Dear Team, > > > > I want to install postgreSQL 10.4 version in my suse lin