repmgr 3.1.4 released

What is repmgr?

repmgr is an open source package which greatly simplifies the process of setting up and managing replication using streaming replication within a cluster of PostgreSQL servers. Taking advantage of features introduced since PostgreSQL 9.3, repmgr builds on PostgreSQL's core functionality to provide a smooth, user-friendly way of working with the complexities of replication and failover management in high-availability environments.

repmgr consists of two core tools - the repmgr command line interface, which provides functionality for adminstering replication such as cloning standby servers, and repmgrd, a background daemon which monitors nodes in a replication cluster and provides automatic failover support.

The latest repmgr major version, 3.1, leverages improvements included with PostgreSQL 9.5 to provide support for switchover, a common administrative task where the roles of primary and standby server are swapped in a controlled manner to facilitate software and hardware maintenance.

Note that repmgr 3.1 supports PostgreSQL 9.3 and later only.

2ndQuadrant provides professional support services for repmgr - see our website for details.

Changes in release 3.1.4

repmgr can now accept conninfo-style connection strings, similar to other PostgreSQL utilities such as psql and pg_basebackup, and also recognises all PostgreSQL environment variables. This makes it possible to provide the full range of connection options when cloning a standby, which is important particularly for users of PostgreSQL SSL connections.

A new repmgr.conf option restore_command is available which enables the restore_command parameter in recovery.conf to be set using repmgr.

repmgr cluster show has been expanded with a --csv option, which outputs cluster node ids and their status in a simple CSV format, suitable for use by scripts.

Several improvements and bugfixes have been implemented, particularly better path handling and node shutdown detection during switchover operations.

Upgrading from older repmgr versions

Upgrading from repmgr 3.1.2 or 3.1.3

repmgr 3.1.4 can simply be installed in placed of the existing repmgr 3.1.2 or repmgr 3.1.3version.

If repmgrd is running, stop and restart the service to ensure it is running with the current repmgr version.

Upgrading from repmgr 3.1.1 or 3.1

To upgrade from repmgr 3.1.1 or repmgr 3.1 version, install repmgr 3.1.3 from your operating system's packaging system or from source, then perform following tasks:

Upgrading from repmgr 3.0

repmgr 3.1.4 is a drop-in replacement for an existing repmgr 3.0 installation. It should be installed first, either from your operating system's packaging system or from source, then following tasks performed:

Upgrading from repmgr 2.0

repmgr 3.1.3 can replace an existing repmgr 2.0 installation. It should be installed first, either from your operating system's packaging system or from source, then following tasks performed:

Community and development

repmgr is free and open source software and is licensed under the GPLv3.

Contributions to repmgr are welcome. See CONTRIBUTING.md for information about how to contribute.

2ndQuadrant Logo