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

Wow. That's a huge challenge.

What do you expect the masters and slaves to do at that time?

What is your goal here?

If you're inserting that much data over time of the backup, my only answer there is actual Oracle in a distributed cluster...

PG certainly can handle it, but we're now dealing with transaction situations.

Wow. If you're inserting that much during the backup, that's certainly something which can be designed on PG for sure. Is it a single DB on a single cluster?

________________________________
From: Ghiurea, Isabella <Isabella(dot)Ghiurea(at)nrc-cnrc(dot)gc(dot)ca>
Sent: Friday, December 14, 2018 4:58:46 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: PG how to stop streaming replication( master host)

Thank you Scott, this will only pause the WAL's .

if you have a lot of activity happening in master while slave db is been backup this can fail behind a lot and eventually can fill up /wal directory. I also use the option you mentioned , but I was looking for an option to actually disable the replication at master host completely since I must insert 200GB of content in db and next I can re-enable replication using resync slave with master ( pg_restore). I am trying to have the replication disabled while I am loading that amount of data to not affect the performance of insert .

________________________________
From: Scott Whitney <scott(at)journyx(dot)com>
Sent: Friday, December 14, 2018 2:50 PM
To: pgsql-admin(at)postgresql(dot)org; Ghiurea, Isabella
Subject: Re: PG how to stop streaming replication( master host)

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.