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

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: [EXTERNAL]Re: pg_dump -Fd -j2 on standby in 9.6.6
Date: 2018-03-28 08:05:57
Message-ID: ad3fcf96-fc31-1b48-5ec3-2e95ecf60c02@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alessandro Aste 2018-03-28 08:30:14 Re: Postgresql 10.3 , query never completes if LIMIT clause is specified and paralle processing is on
Previous Message Stefan Petrea 2018-03-28 07:46:35 RE: [EXTERNAL]Re: pg_dump -Fd -j2 on standby in 9.6.6