From: | Scott Whitney <scott(at)journyx(dot)com> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, "Ghiurea, Isabella" <isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca> |
Subject: | Re: PG how to stop streaming replication( master host) |
Date: | 2018-12-14 22:50:30 |
Message-ID: | SN6PR11MB2976E78D06B066CCAC7C5F7DA7A10@SN6PR11MB2976.namprd11.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(dot)Ghiurea(at)nrc-cnrc(dot)gc(dot)ca>
Sent: Friday, December 14, 2018 4:46:55 PM
To: pgsql-admin(at)postgresql(dot)org
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
[http://journyx.com/emailImages/ScottWhitney.png]
[http://journyx.com/emailImages/linkedin.png]<https://www.linkedin.com/company/journyx-inc/> [http://journyx.com/emailImages/twitter.png] <https://www.twitter.com/journyxinc>
[http://journyx.com/emailImages/bluebar.jpg]
Scott Whitney
Director of IT
[http://journyx.com/emailImages/journyx.jpg]
scott(at)journyx(dot)com<mailto:scott(at)journyx(dot)com> | +1 (800) 755-9878
7600 Burnet Road, Ste. 300
Austin, TX 78757
Visit us at www.journyx.com<https://www.journyx.com/>
To unsubscribe from Journyx promotional emails, click here <http://journyx.com/communication-preferences> or visit http://journyx.com/communication-preferences.
From | Date | Subject | |
---|---|---|---|
Next Message | Ghiurea, Isabella | 2018-12-14 22:58:46 | Re: PG how to stop streaming replication( master host) |
Previous Message | Ghiurea, Isabella | 2018-12-14 22:46:55 | PG how to stop streaming replication( master host) |