PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

For the purposes of this recipe, pgha1 will start as our primary node and pgha2 will start as a physical standby. Follow these steps to promote pgha2 to be the new cluster primary:

1. Pause the repmgr daemon on all nodes by executing this command as the postgres user on any system:

repmgr service pause

2. As the postgres user on pgha2, invoke the following command to promote it to become the new primary:

repmgr standby switchover --siblings-follow

3. Check the cluster status as the postgres user on any node:

repmgr cluster show

4. Unpause the repmgr daemon on all nodes by executing this command as the postgres user on any system:

repmgr service unpause