Re: How to stop Streaming Replication in slave for backup

[Suresh Rajagopal <sureshr7@xxxxxxxxx>]

Thanks John.

---

From: John Scalia <jayknowsunix@xxxxxxxxx>
To: Suresh Rajagopal <sureshr7@xxxxxxxxx>
Cc: Pgsql-admin <pgsql-admin@xxxxxxxxxxxxxx>
Sent: Thursday, February 2, 2017 10:27 AM
Subject: Re: 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@xxxxxxxxx> wrote:

Hi,

What is the best approach for stopping streaming replication on 9.3 slave for running pg_dump ?

Thanks

Suresh