PostgreSQL 11 Administration Cookbook

There's more…

When following a switchover from one node to another, it is common to think of performing a switchover back to the old master server, which is sometimes called failback or switchback.

Once a standby has become a master, it cannot go back to being a standby again. So, with log replication, there is no explicit switchback operation. This is a surprising situation for many people and there is a repeated question, but it is quick to work around. Once you have performed a switchover, all you need to do is the following:

• Reconfigure the old master node again, repeating the same process as before to set up a standby node
• Switchover from the current to the old master node

The important part here is that if we perform the first step ...