In my personal experience, I have a multi GB customer database. During the PG dump, when the source (master) database is modified,
my pg_dump fails.
Pausing replication resolves that problem.
From: pgsql-admin-owner@postgresql.org <pgsql-admin-owner@postgresql.org> on behalf of Suresh Rajagopal <sureshr7@gmail.com> Sent: Thursday, February 2, 2017 12:59 PM To: John Scalia Cc: Pgsql-admin Subject: Re: [ADMIN] How to stop Streaming Replication in slave for backup
Thanks John.
From: John Scalia <jayknowsunix@gmail.com> To: Suresh Rajagopal <sureshr7@gmail.com> Cc: Pgsql-admin <pgsql-admin@postgresql.org> Sent: Thursday, February 2, 2017 10:27 AM Subject: Re: [ADMIN] How to stop Streaming Replication in slave for backup
You really shouldn't need to stop replication in order to run pg_dump on a 9.3 database,
On Thu, Feb 2, 2017 at 1:07 PM, Suresh Rajagopal <sureshr7@gmail.com> wrote:
Hi,
What is the best approach for stopping streaming replication on 9.3 slave for running pg_dump ?