Re: How to stop Streaming Replication in slave for backup

I use:

SELECT pg_xlog_replay_pause();

-- pg_dumps run here

SELECT pg_xlog_replay_resume();

________________________________
From: pgsql-admin-owner(at)postgresql(dot)org <pgsql-admin-owner(at)postgresql(dot)org> on behalf of Suresh Rajagopal <sureshr7(at)gmail(dot)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/