3rd October 2019: PostgreSQL 12 Released!

Announcing the release of repmgr 4.4

Posted on 2019-06-27 by 2ndQuadrant Ltd

Oxford, United Kingdom - June 27, 2019

2ndQuadrant today announced the release of repmgr 4.4 This major release includes several important enhancements.

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 4.4 provides two key enhancements for automatic failover with repmgrd:

  • On the primary node, repmgrd is now able to monitor standby connections and, if the number of nodes connected falls below a certain (configurable) value, execute a custom script. This provides additional possibilities for fencing an isolated primary node and/or taking other action if one or more standys become disconnected.
  • In a failover situation, repmgrd nodes on the standbys of the failed primary are now able confirm among themselves that none can still see the primary before continuing with the failover.

repmgr 4.4 presents the following main client enhancements:

  • --siblings-follow option added to repmgr standby promote
  • --repmgrd-force-unpause option added to repmgr standby switchover
  • Additional output when running repmgr standby switchover and repmgr standby promote with the --dry-run option
  • repmgr cluster show and repmgr daemon status output has been made more consistent, and both now emit additional warnings about unexpected node status
  • repmgr cluster show now displays each node's timeline ID (PostgreSQL 9.6 and later only)
  • Safeguards added to prevent a standby being cloned from a witness server, and prevent a witness server being installed on the main replication cluster

Fixes for a number of issues have also been provided.

Additionally, the repmgr documentation has been converted to XML, which makes it possible to easily provide the documentation in other formats such as PDF.

For a detailed list of all changes, please read the complete release notes here.

Upgrading to this version is highly recommended for all repmgr users. Upgrade instructions are available here.

Packages and installation documentation are available via 2ndQuadrant’s public RPM and APT repositories from 2ndQuadrant here

Source files can be downloaded here and installation instructions are available here.

repmgr is distributed under GPL v3.

For more information, please send an email to info@2ndQuadrant.com

Related Open Source