Release notes for repmgr 3.1: repmgr - Replication Manager for PostgreSQL

repmgr 3.1 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.

Upgrading from repmgr 3.0

repmgr 3.1 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:

Run the provided repmgr database upgrade script, sql/repmgr3.0_repmgr3.1.sql. This introduces one new convenience view, repl_show_nodes, but otherwise no changes have been made to repmgr's metadata schema.
If repmgrd is running, stop and restart the service to ensure it is running with the current repmgr version.

Upgrading from repmgr 2.0

repmgr 3.1 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:

If repmgrd is running, stop the service.
Run the provided repmgr database upgrade script, sql/repmgr2_repmgr3.sql, which is required to expand the repl_nodes table.

Run the provided repmgr database upgrade script, sql/repmgr3.0_repmgr3.1.sql. This introduces one new convenience view, repl_show_nodes. Restart repmgrd, if required.

Changes in release 3.1 New features repmgr 3.1 introduces the repmgr standby switchover command, which automatically promotes the current standby to master and demotes the old master to a standby, a previously complex manual procedure. This builds on the pg_rewind utility introduced with PostgreSQL 9.5. Note that for PostgreSQL 9.3 and 9.4, pg_rewind can be compiled as an external utility; see the repmgr documentation for details. Improvements Documentation has been extensively revised New or altered command line options (repmgr) repmgr --help output now shows default values where appropriate Bug fixes Various bugfixes to command line/configuration parameter handling 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.