Re: [GENERAL] Standby pg_dump Conflict with Recovery

2015-10-16 Thread Adrian Klaver
On 10/16/2015 07:50 AM, Louis Battuello wrote: Also in the standby logs before and after the ERROR? The primary log was clean. The standby contained the same error as the pg_dump output log: < 2015-10-15 01:10:50 EDT [42613] : [1-1] user=postgres,db=,remote=::1(55426) > ERROR: canceling st

Re: [GENERAL] Standby pg_dump Conflict with Recovery

2015-10-16 Thread Louis Battuello
> On Oct 16, 2015, at 9:35 AM, Adrian Klaver wrote: > > On 10/15/2015 03:30 PM, Louis Battuello wrote: >> >>> On Oct 15, 2015, at 6:16 PM, Adrian Klaver >> > wrote: >>> > >>> >>> How did you set and temporarily enable the settings >> >> I changed the settin

Re: [GENERAL] Standby pg_dump Conflict with Recovery

2015-10-16 Thread Adrian Klaver
On 10/15/2015 03:30 PM, Louis Battuello wrote: On Oct 15, 2015, at 6:16 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: How did you set and temporarily enable the settings I changed the settings in the postgresql.conf file, restarted the standby server, checked that there was

Re: [GENERAL] Standby pg_dump Conflict with Recovery

2015-10-15 Thread Louis Battuello
> On Oct 15, 2015, at 6:16 PM, Adrian Klaver wrote: > > On 10/15/2015 03:03 PM, Louis Battuello wrote: >> Hello All, >> >> I’ve got a confusing issue with dumping data from a standby PostgreSQL >> 9.4.5 database. >> >> At night, on a nearly completely idle server, I run a pg_dump of a >> datab

Re: [GENERAL] Standby pg_dump Conflict with Recovery

2015-10-15 Thread Adrian Klaver
On 10/15/2015 03:03 PM, Louis Battuello wrote: Hell All, I’ve got a confusing issue with dumping data from a standby PostgreSQL 9.4.5 database. At night, on a nearly completely idle server, I run a pg_dump of a database that contains numerous small tables and one 3GB table. The dump consistentl

[GENERAL] Standby pg_dump Conflict with Recovery

2015-10-15 Thread Louis Battuello
Hell All, I’ve got a confusing issue with dumping data from a standby PostgreSQL 9.4.5 database. At night, on a nearly completely idle server, I run a pg_dump of a database that contains numerous small tables and one 3GB table. The dump consistently fails when reaching the 3GB table with this