repmgr 2.0.2 released
What is repmgr?
repmgr is a set of open source tools that helps DBAs and System administrators manage a cluster of PostgreSQL databases.
By taking advantage of the Hot Standby capability introduced in PostgreSQL 9, repmgr greatly simplifies the process of setting up and managing database with high availability and scalability requirements.
repmgr simplifies administration and daily management, enhances productivity and reduces the overall costs of a PostgreSQL cluster by:
- monitoring the replication process;
- allowing DBAs to issue high availability operations such as switch-overs and fail-overs
repmgr is production quality software and used widely across the world with PostgreSQL. Many users rely on repmgr to maintain their replication setups and as such we take new releases seriously and mark the level of maturity as a guide for users. As repmgr 2.0 moves towards production we continue to regard the autofailover feature as currently in beta; we expect that to fully mature in the 2.1 release.
2ndQuadrant provides contract support for PostgreSQL that includes both repmgr and the autofailover feature.
- repmgr 2.0.2 has been tested with PostgreSQL 9.4 and includes some minor bugfixes.
-F/--forceoption is used to synchronise an inactive standby's data directory with the master (e.g. to avoid copying the entire directory from scratch), force use of the rsync
--checksumoption to ensure all changed files are synchronised correctly.
- If no master port number is supplied, use the default port (5432).
- Fixes to witness creation and monitoring.
Features we are working on in the near future:
- timeline increase when a standby gets promoted
- A better check which standby did receive most of the data
- Respect the fact that a standby can be delayed on purpose a factor in the voting algorithm
- include support for delayed standbys
Community and development
repmgr is free and open source software and is licensed under the GPLv3.
Contributions to repmgr are welcome. See the README.rst file for information about how to contribute.