PostgreSQL 12 High Availability Cookbook - Third Edition

Useful shortcuts

Since the introduction of repmgr 4.2, repmgr standby switchover will automatically pause the service to prevent it from interfering in the procedure. While we still recommend pausing the service explicitly to prevent accidents in case other commands are involved, it's permissible to omit this in this circumstance.

However, repmgr will not automatically unpause the daemons at the end of a switchover. After all, the repmgr service may have been paused before we invoked the switchover process. Therefore, if we want to both automatically pause and unpause the repmgr service during a switchover, we can use this command instead:

repmgr standby switchover --siblings-follow --repmgrd-force-unpause