|
Thank you. I made a mistake, our version is PostgreSQL 9.6.2
From: Ben Chobot <bench@xxxxxxxxxxxxxxx>
Sent: Monday, March 4, 2019 5:08 PM To: Julie Nishimura Cc: pgsql-general@xxxxxxxxxxxxxxxxxxxx Subject: Re: master-> 2 hot standbys
It depends on how you've set things up, of course, but generally you can run "pg_ctl promote" on one of your
slaves. This will make that slave start a new timeline and begin to act as a master. To restore your old master to a standby, you will need to rebuild it with something like pg_basebackup, as I do not believe pg_replay is supported with 9.2.
Terminating client connections on the old master to avoid splitbrain and then making those clients reconnect to your new master is left as an exercise to the reader - how you do it really depends on your environment - but be sure you do it right, because
splitbrain is a real danger. In a similar vein, you don't want two masters trying to save the same wals to the same wal archive.
Also, if your two slaves are using asynchronous replication, be aware that the slave you choose to become the new master has a chance to be behind the
other slave in wal replay when you promote it, unless you take precautions. This would mean your other slave won't be able to sync up with the newly promoted master.
|
