repmgr enhances and complements the built-in replication capabilities in PostgreSQL and is the most popular tool for PostgreSQL replication and failover management. Repmgr makes it easy to set up and manage standby servers, check replication status, and perform administrative tasks such as switchover operations. The repmgrd daemon provides automatic failover capability to maximize database uptime, and can easily be integrated with other tools such as PgBouncer for high application availability.
repmgr 5.1 introduces an important compatibility change to the repmgr standby clone: the --recovery-conf-only option has been updated to --replication-conf-only.
In addition, repmgr 5.1 removes the requirement that the repmgr user is a database superuser, as far as possible. In theory, repmgr can be operated with a standard database user for managing the repmgr database, and a separate replication user for managing replication connections (and replication slots, if these are in use).
Some operations will still require superuser permissions, e.g. for issuing a CHECKPOINT as part of a switchover operation; in this case, a valid superuser should be provided with the -S/--superuser option.
repmgr is distributed under GPL v3.
For more information, please send an email to info@2ndQuadrant.com
