I use:
SELECT pg_xlog_replay_pause(); -- pg_dumps run here SELECT pg_xlog_replay_resume(); From: pgsql-admin-owner@xxxxxxxxxxxxxx <pgsql-admin-owner@xxxxxxxxxxxxxx> on behalf of Suresh Rajagopal <sureshr7@xxxxxxxxx>
Sent: Thursday, February 2, 2017 12:07 PM To: Pgsql-admin Subject: 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/
|