repmgr 3.0.3 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 current repmgr major version, 3.0, introduces a number of new features which further simplify replication administration:
- Standby cloning with pg_basebackup
- Timeline following:
- a standby can be promoted to a master without requiring a restart
- other standbys can connect to the new master without being resynced
- Cascading standby support
- Standbys not directly connected to the master node are not affected during failover of the master to another standby mode
- Replication slot support (PostgreSQL 9.4 and later), simplifying WAL retention management
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.3 supports PostgreSQL 9.3 and later only.
2ndQuadrant provides professional support services for repmgr - see our website for details.
Changes in release 3.0.3
See the repmgr 3.0 release notes for information about the main changes in the repmgr 3.0 series.
repmgr 3.0.3 has been tested against PostgreSQL 9.5rc1 and we anticipate it will be fully compatible with the final PostgreSQL 9.5 release.
Improvements
- Various log messages now explicitly output as HINTS (and can be disabled with
-t/--terse
) /etc/repmgr.conf
checked as a default configuration file location- configuration parsing and error reporting more user friendly
- repmgrd no longer terminates automatically if the monitored standby node is temporarily unavailable
Bug fixes
- Prevent invalid replication_lag values being written to the monitoring table
- Replication slots now handled correctly in all cases
- Prevent repmgrd's
-v/--verbose
option expecting a parameter
New or altered command line options (repmgr)
- New command line option
-L/--log-level
to explicitly set log level on command line -v/--verbose
now provides extra troubleshooting log output (this is a change in behaviour from 3.0.2 and earlier, where-v/--verbose
was equivalent to---log-level=INFO
)
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.