Re: [EXTERNAL]Re: pg_dump -Fd -j2 on standby in 9.6.6

2018-03-28 Thread David G. Johnston
On Wed, Mar 28, 2018 at 10:13 AM, Ron wrote: > On 03/28/2018 03:05 AM, Andreas Kretschmer wrote: > [snip] > >> > This e-mail message, including any attachments, >> >> this is a public mailing list ... >> > > The intended recipient is the public mailing list, no? ​A mailing list doesn't really "

Re: [EXTERNAL]Re: pg_dump -Fd -j2 on standby in 9.6.6

2018-03-28 Thread Ron
On 03/28/2018 03:05 AM, Andreas Kretschmer wrote: [snip] > This e-mail message, including any attachments, this is a public mailing list ... The intended recipient is the public mailing list, no? -- Angular momentum makes the world go 'round.

Re: [EXTERNAL]Re: pg_dump -Fd -j2 on standby in 9.6.6

2018-03-28 Thread Andreas Kretschmer
Am 28.03.2018 um 09:46 schrieb Stefan Petrea: Hi Andreas, Thank you for your suggestion about pausing/resuming the standby! I've tried running on the standby SELECT pg_xlog_replay_pause() Then running the dump, and it threw the same error I had seen before. run pg_dump with --no-synchronize

RE: [EXTERNAL]Re: pg_dump -Fd -j2 on standby in 9.6.6

2018-03-28 Thread Stefan Petrea
or virus free. -Original Message- From: Andreas Kretschmer [mailto:andr...@a-kretschmer.de] Sent: Wednesday, March 28, 2018 8:26 AM To: pgsql-general@lists.postgresql.org; Stefan Petrea ; pgsql-gene...@postgresql.org Subject: [EXTERNAL]Re: pg_dump -Fd -j2 on standby in 9.6.6 WARNING: The

Re: pg_dump -Fd -j2 on standby in 9.6.6

2018-03-27 Thread Andreas Kretschmer
On 28 March 2018 07:02:30 CEST, Stefan Petrea wrote: >Hi, > > >I wonder why synchronized snapshots are not supported on standby >servers. > > > If you want to take backups using -Fd on a standby you should pause the reply-process. In this case you don' t need synchronized snapshots. Regards, An

RE: [EXTERNAL]pg_dump -Fd -j2 on standby in 9.6.6

2018-03-27 Thread Stefan Petrea
ssage- From: Stefan Petrea [mailto:stefan.pet...@tangoe.com] Sent: Wednesday, March 28, 2018 8:03 AM To: pgsql-gene...@postgresql.org Subject: [EXTERNAL]pg_dump -Fd -j2 on standby in 9.6.6 Hi, I downloaded the code from this github tag https://na01.safelinks.protection.outlook.com/?url=https%

pg_dump -Fd -j2 on standby in 9.6.6

2018-03-27 Thread Stefan Petrea
Hi, I downloaded the code from this github tag https://github.com/postgres/postgres/archive/REL9_6_8.tar.gz I unpacked the code on disk where gdb was looking for it /build/postgresql-9.6-9VrjLn/postgresql-9.6-9.6.8 Then I ran this oneliner which is a summary of my debug process. So, apparently