Binary Replication Tools
From PostgreSQL wiki
(Difference between revisions)
(→repmgr) |
|||
| Line 1: | Line 1: | ||
| - | |||
| - | + | = Purpose = | |
| + | |||
| + | Compare binary replication tools for PostgreSQL for features and ease of use. | ||
= OmniPITR = | = OmniPITR = | ||
| Line 20: | Line 21: | ||
* Uses an odd format for omnipitr logfile naming | * Uses an odd format for omnipitr logfile naming | ||
* No configuration file option (instead of using long command-line options) | * No configuration file option (instead of using long command-line options) | ||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
= repmgr = | = repmgr = | ||
| Line 51: | Line 40: | ||
* 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 | ||
| + | |||
| + | = WAL-E = | ||
| + | |||
| + | [https://github.com/heroku/WAL-E WAL-E] | ||
| + | |||
| + | = Barman = | ||
| + | |||
| + | [http://www.pgbarman.org/ pgbarman] | ||
| + | |||
| + | = Skytools / walmgr = | ||
| + | |||
| + | [https://github.com/markokr/skytools Skytools] | ||
| + | |||
| + | = pg-rman = | ||
| + | |||
| + | [http://code.google.com/p/pg-rman/ pg-rman] | ||
Revision as of 00:50, 29 December 2012
Contents |
Purpose
Compare binary replication tools for PostgreSQL for features and ease of use.
OmniPITR
Summary of Features:
- Creating PITR backups
- Restoring a PITR backup for DR
- Creating replicas (by untarring backups)
- Monitoring of replicas
- Supports 'pause removal' of WAL during a backup (nice!)
- 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)
repmgr
Supported features:
- Setting up new replicas/hot_standby with streaming replication
- Making base backups
- 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
