repmgr 3.0 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 release, version 3.0, introduces a number of new features which further simplify replication administration:

Additionally many usability improvements have been made based on user feedback, including better error reporting, removing the requirement to set pg_bindir if PostgreSQL binaries are in the default path, and a command line option to examine a server's configuration and report any changes required for setting up replication.

Note that repmgr 3.0 supports PostgreSQL 9.3 and later only.

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

New features

New or altered configuration options

New or altered command line options (repmgr)

Compatibility with repmgr 2.x

The configuration file format and options in repmgr 3 are backwards compatible with repmgr 2.x, so existing configuration files can be used largely as-is. However please be aware that the priority setting now defaults to 100 and that a setting of 0 (or less) indicates that the node should not be promoted to master, so any priority in existing repmgr.conf files should be adjusted accordingly.

Note that the metadata stored by repmgr 3 has changed and the existing metadata table (repl_nodes) will need to be upgraded; a script has been provided for this (repmgr2_repmgr3.sql).

The following minor compatibility changes have been made:

Community and development

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

Contributions to repmgr are welcome. See the README.md file for information about how to contribute.

2ndQuadrant Logo