Re: PG how to stop streaming replication( master host)

[Scott Whitney <scott@xxxxxxxxxxx>]

I use this during my backups to have a consistent state on my multiple slaves.

https://coderwall.com/p/nirwxa/pause-and-resume-hot_standby-replication-on-postgres-database

---

From: Ghiurea, Isabella <Isabella.Ghiurea@xxxxxxxxxxxxxx>
Sent: Friday, December 14, 2018 4:46:55 PM
To: pgsql-admin@xxxxxxxxxxxxxx
Subject: PG how to stop streaming replication( master host)

 

Hi List

I am running PGSLQ 10.4 with repmgr in synchronous streaming replication  2 servers: master+slave, I would like to learn if there are any  options to stop replication ( no just  pause /resume  the WAL's) master to slave without  rebooting the master server  or the only option  is to take  the  Pg db slave host down and eventually the  the /wal directory will get 100% full .

Isabella

Scott Whitney Director of IT scott@xxxxxxxxxxx | +1 (800) 755-9878 7600 Burnet Road, Ste. 300 Austin, TX 78757 Visit us at www.journyx.com

To unsubscribe from Journyx promotional emails, click here or visit http://journyx.com/communication-preferences.