Re: [EXTERNAL]Re: pg_dump -Fd -j2 on standby in 9.6.6 - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: [EXTERNAL]Re: pg_dump -Fd -j2 on standby in 9.6.6
Date
Msg-id ad3fcf96-fc31-1b48-5ec3-2e95ecf60c02@a-kretschmer.de
Whole thread Raw
In response to RE: [EXTERNAL]Re: pg_dump -Fd -j2 on standby in 9.6.6  (Stefan Petrea <Stefan.Petrea@tangoe.com>)
Responses Re: [EXTERNAL]Re: pg_dump -Fd -j2 on standby in 9.6.6  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general

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-synchronized-snapshots, it is save in this szenario.

 > This e-mail message, including any attachments,

this is a public mailing list ...


Regards, Andreas
-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com



pgsql-general by date:

Previous
From: Stefan Petrea
Date:
Subject: RE: [EXTERNAL]Re: pg_dump -Fd -j2 on standby in 9.6.6
Next
From: Alessandro Aste
Date:
Subject: Re: Postgresql 10.3 , query never completes if LIMIT clause isspecified and paralle processing is on