PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

For the purposes of this recipe, we will rely on the standard three nodes of pgha1 as the primary node, pgha2 as the physical standby, and pgha3 as the dedicated witness. Follow these steps to carry out maintenance on the repmgr primary server:

1. Begin by pausing the repmgr service on all nodes by executing this command as the postgres user on any system:

repmgr service pause

2. Verify that all repmgr services are suspended by executing this command as the postgres user on any system:

repmgr service status

3. As the postgres user on pgha2, invoke the following command to test the switchover process:

repmgr standby switchover --siblings-follow --dry-run

4. Check the dry-run output for errors, and if all messages are successful, ...