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.0 introduces support for the recently released PostgreSQL 12, which integrates the previously separate replication configuration (via the special “recovery.conf” file) into the main PostgreSQL configuration system. repmgr has been adapted to be compatible with this change and take advantage of other PostgreSQL 12 improvements such as the ability to promote a standby via an SQL command.
In addition, repmgr 5.0’s configuration file parsing has been revised to work in exactly the same way as that of PostgreSQL. This removes the risk of some common configuration issues related to string quoting. Existing “repmgr.conf” files may need slight modification, mainly by ensuring all strings are surrounded by single quotes.
repmgr is distributed under GPL v3.
For more information, please send an email to info@2ndQuadrant.com