Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] How to stop Streaming Replication in slave for backup - Mailing list pgsql-admin

From Scott Whitney
Subject Re: [ADMIN] How to stop Streaming Replication in slave for backup
Date
Msg-id BY1PR11MB039087CD630CD6708C334422A74C0@BY1PR11MB0390.namprd11.prod.outlook.com
Whole thread Raw
In response to [ADMIN] How to stop Streaming Replication in slave for backup  (Suresh Rajagopal <sureshr7@gmail.com>)
Responses Re: [ADMIN] How to stop Streaming Replication in slave for backup  (Suresh Rajagopal <sureshr7@gmail.com>)
List pgsql-admin
Tree view

I use:


SELECT pg_xlog_replay_pause();

-- pg_dumps run here

SELECT pg_xlog_replay_resume();



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:07 PM
To: Pgsql-admin
Subject: [ADMIN] How to stop Streaming Replication in slave for backup
 
Hi,

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

Thanks
Suresh


Journyx, Inc.
7600 Burnet Road #300
Austin, TX 78757
www.journyx.com

p 512.834.8888 
f 512-834-8858 

Do you receive our promotional emails? You can subscribe or unsubscribe to those emails at http://go.journyx.com/emailPreference/e/4932/714/ 

pgsql-admin by date:

Previous
From: Suresh Rajagopal
Date:
Subject: [ADMIN] How to stop Streaming Replication in slave for backup
Next
From: John Scalia
Date:
Subject: Re: [ADMIN] How to stop Streaming Replication in slave for backup