Re: [GENERAL] pg_dump pg_restore hanging in CentOS for large data

2017-03-20 Thread Sridevi B
Hi Tom, Please find my answers below. ->ulimit : Verified in file /etc/security/limits.conf - it has been configured as 2. Should I increase the limit and try again? please let me know. root - nofile 2 postgres - nofile 2 ->ssl_renegotiation_limit : Its been set as

Re: [GENERAL] pg_dump pg_restore hanging in CentOS for large data

2017-03-17 Thread Adrian Klaver
On 03/17/2017 12:27 AM, Sridevi B wrote: Ccing list. Please reply to list also, it puts more eyes on the problem. Hi Adrian, Sorry for delay. Please find my answers inline. Thanks, Sridevi On Thu, Mar 16, 2017 at 2:28 AM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 03

Re: [GENERAL] pg_dump pg_restore hanging in CentOS for large data

2017-03-15 Thread Tom Lane
Sridevi B writes: >I am facing an issue with backup/Restore for data size more than *2GB*. I'm suspicious that you're running into some limit external to postgres itself. A couple of likely possibilities: * maybe you've got a ulimit active on the server or the pg_dump or pg_restore proces.

Re: [GENERAL] pg_dump pg_restore hanging in CentOS for large data

2017-03-15 Thread Adrian Klaver
On 03/14/2017 09:48 AM, Sridevi B wrote: Hi , I am facing an issue with backup/Restore for data size more than *2GB*. Its working fine for *1GB*. Below are the details for issue: Description: The command pg_dump is hanging at saving large objects and process gets terminated after som