|
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@xxxxxxxxxxx>
Sent: Friday, December 14, 2018 2:50 PM To: pgsql-admin@xxxxxxxxxxxxxx; 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.
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
To unsubscribe from Journyx promotional emails, click
here or visit http://journyx.com/communication-preferences.
|
