Binary Replication Tools

From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
(repmgr)
Line 23: Line 23:
 
[http://www.repmgr.org/ repmgr]
 
[http://www.repmgr.org/ repmgr]
  
 +
Supported features:
 
* Setting up new replicas
 
* Setting up new replicas
 
* Failover (automated, or not, including redirecting replicas to connect to a new master after failover)
 
* Failover (automated, or not, including redirecting replicas to connect to a new master after failover)
Line 28: Line 29:
 
* A "witness" DB server for monitoring (typically on a replica)
 
* A "witness" DB server for monitoring (typically on a replica)
 
* License: GPLv3
 
* License: GPLv3
 +
 +
Install notes:
 +
* 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

Revision as of 22:45, 28 December 2012

Contents

WAL-E

WAL-E

OmniPITR

OmniPITR

Barman

pgbarman

Skytools / walmgr

Skytools

pg-rman

pg-rman

repmgr

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:

  • 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
Personal tools