From PostgreSQL wiki

Revision as of 23:06, 28 December 2012 (view source) Selena (Talk | contribs) (→OmniPITR) ← Older edit		Revision as of 23:10, 28 December 2012 (view source) Selena (Talk | contribs) (→OmniPITR) Newer edit →
Line 6:		Line 6:
	[https://github.com/omniti-labs/omnipitr OmniPITR]		[https://github.com/omniti-labs/omnipitr OmniPITR]
		+
		+	* Creating replicas
		+	* Monitoring of replicas
		+	* Creating PITR backups
		+	* Restoring a PITR backup for DR
		+	* BSD license
	Install notes:		Install notes:

---

Revision as of 23:10, 28 December 2012

Contents 1 WAL-E 2 OmniPITR 3 Barman 4 Skytools / walmgr 5 pg-rman 6 repmgr

WAL-E

WAL-E

OmniPITR

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

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