Binary Replication Tools

From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
(repmgr)
Line 1: Line 1:
= WAL-E =
 
  
[https://github.com/heroku/WAL-E WAL-E]
+
= 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)
 
= 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]
 
  
 
= 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

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

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

WAL-E

WAL-E

Barman

pgbarman

Skytools / walmgr

Skytools

pg-rman

pg-rman

Personal tools