Binary Replication Tools
From PostgreSQL wiki
(Difference between revisions)
(→OmniPITR) |
(→repmgr) |
||
| Line 43: | Line 43: | ||
Install notes: | Install notes: | ||
| + | * Written in C | ||
* Installs like a typical UNIX utility out of postgresql/contrib source tree (make USE_PGXS=1; make USE_PGXS=1 install) | * Installs like a typical UNIX utility out of postgresql/contrib source tree (make USE_PGXS=1; make USE_PGXS=1 install) | ||
* Developed on Debian systems, so support for package is present. Did not find an Ubuntu package for repmgr, however. | * Developed on Debian systems, so support for package is present. Did not find an Ubuntu package for repmgr, however. | ||
* Detailed docs are in the README for installing on many Linux platforms | * Detailed docs are in the README for installing on many Linux platforms | ||
* Doesn't appear to be supported on Mac OS X | * Doesn't appear to be supported on Mac OS X | ||
Revision as of 23:11, 28 December 2012
Contents |
WAL-E
OmniPITR
- Creating replicas
- Monitoring of replicas
- Creating PITR backups
- Restoring a PITR backup for DR
- BSD license
Install notes:
- No packaging, perl
- No documented support for streaming replication
- Uses an odd format for omnipitr logfile naming
- No configuration file option (instead of using long command-line options)
Barman
Skytools / walmgr
pg-rman
repmgr
Supported features:
- Setting up new replicas
- Failover (automated, or not, including redirecting replicas to connect to a new master after failover)
- Lag monitoring (repmgrd)
- A "witness" DB server for monitoring (typically on a replica)
- License: GPLv3
Install notes:
- Written in C
- Installs like a typical UNIX utility out of postgresql/contrib source tree (make USE_PGXS=1; make USE_PGXS=1 install)
- Developed on Debian systems, so support for package is present. Did not find an Ubuntu package for repmgr, however.
- Detailed docs are in the README for installing on many Linux platforms
- Doesn't appear to be supported on Mac OS X
