What is repmgr?
repmgr is an open-source tool suite to manage replication and failover in a cluster of PostgreSQL servers. It enhances PostgreSQL's built-in hot-standby capabilities with tools to set up standby servers, monitor replication, and perform administrative tasks such as failover or manual switchover operations.
repmgr has provided advanced support for PostgreSQL's built-in replication mechanisms since they were introduced in 9.0, and repmgr 2.0 supports all PostgreSQL versions from 9.0 to 9.4. With further developments in replication functionality such as cascading replication, timeline switching and base backups via the replication protocol, the repmgr team has decided to use PostgreSQL 9.3 as the baseline version for repmgr 3.0, which is a substantial rewrite of the existing repmgr code and which will be developed to support future PostgreSQL versions.
Open Source from 2ndQuadrant
repmgr is developed by 2ndQuadrant, the global experts in PostgreSQL support, training, development, migration and consultancy.
repmgr is free and open-source software licensed under the GNU Public License (GPL) v3. This means you are free to use and modify repmgr as you see fit, however any modifications you make may only be distributed under the same terms. See here for details.
Contributions to repmgr are welcome. See the CONTRIBUTING.md file for information about how to contribute.
Online documentation which describes the installation process and the most common usage patterns is available in the project GitHub repository.
Upgrading between minor releases (e.g. 3.0.2 to 3.0.3) is straightforward and requires only an upgrade of the installed repmgr version.
For some major releases, an update of repmgr's internal database is required; this is straightforward and requires an SQL script to be applied to the database. If your version upgrade skips one or more major releases, you'll need to apply the script for each release sequentially.
Database upgrades are required between the following versions:
- repmgr 2.0 to repmgr 3.0: release notes.
- repmgr 3.0 to repmgr 3.1: release notes.
- repmgr 3.1.1 to repmgr 3.1.2: release notes.
Instructions for uninstalling repmgr can be found here.