Binary Replication Tools

From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
Line 22: Line 22:
  
 
[http://www.repmgr.org/ repmgr]
 
[http://www.repmgr.org/ repmgr]
 +
 +
* 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)

Revision as of 21:43, 28 December 2012

Contents

WAL-E

WAL-E

OmniPITR

OmniPITR

Barman

pgbarman

Skytools / walmgr

Skytools

pg-rman

pg-rman

repmgr

repmgr

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