After i run pause, i see wal receiver is running. Is that okay ?
Thanks
Suresh
From: Scott Whitney <scott@journyx.com> To: Pgsql-admin <pgsql-admin@postgresql.org>; Suresh Rajagopal <sureshr7@gmail.com> Sent: Thursday, February 2, 2017 10:23 AM Subject: Re: [ADMIN] How to stop Streaming Replication in slave for backup
#yiv7771702495 #yiv7771702495 -- P {margin-top:0;margin-bottom:0;}#yiv7771702495
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 ?