repmgr 3.2.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.2, provides support for 2ndQuadrant’s Barman archive management server, additional cluster monitoring functionality and several improvements to the standby cloning process.
Note that repmgr 3.2 supports PostgreSQL 9.3 and later only.
2ndQuadrant provides professional support services for repmgr - see our website for details.
Improvements in repmgr 3.2.1
This is a maintenance release containing a small number of improvements and bugfixes.
Require a valid repmgr cluster name unless -F/--force supplied
This helps diagnose issues with configuration file handling.
Check master server is registered with repmgr before cloning
repmgr will now require that the master server is registered before any clones can be made. (This behaviour can be overriden with -F/--force).
Improvements to `repmgr barman clone` mode
Some small improvements and fixes for the repmgr barman clone command introduced in repmgr 3.2.
Ensure data directory defaults to that of the source node
A regression in the 3.2 release meant that when cloning a standby, the data directory had to be explicitly provided.
Upgrading from older repmgr versions
Upgrading from repmgr 3.1.2 or later
repmgr 3.2.1 can simply be installed in place of any version from repmgr 3.1.2 onwards.
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.5 from your operating system's packaging system or from source, then perform following tasks:
- Run the provided repmgr database upgrade script, repmgr3.1.1_repmgr3.1.2.sql. This makes a small modification to the repl_nodes table's foreign key definition.
- If repmgrd is running, stop and restart the service to ensure it is running with the current repmgr version.
Upgrading from repmgr 3.0
repmgr 3.2.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.
- Run the provided repmgr database upgrade script, repmgr3.1.1_repmgr3.1.2.sql. This makes a small modification to the repl_nodes table's foreign key definition.
- 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.2.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_nodestable. - Run the provided repmgr database upgrade script, sql/repmgr3.0_repmgr3.1.sql. This introduces one new convenience view, repl_show_nodes.
- Run the provided repmgr database upgrade script, repmgr3.1.1_repmgr3.1.2.sql. This makes a small modification to the repl_nodes table's foreign key definition.
- Restart repmgrd if previously stopped.
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.
