Re: How to stop Streaming Replication in slave for backup

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi Scott,

After i run pause, i see wal receiver is running. Is that okay ?

Thanks
Suresh



From: Scott Whitney <scott@xxxxxxxxxxx>
To: Pgsql-admin <pgsql-admin@xxxxxxxxxxxxxx>; Suresh Rajagopal <sureshr7@xxxxxxxxx>
Sent: Thursday, February 2, 2017 10:23 AM
Subject: 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@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/ 



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux