pitrtools¶

pitrtools is a Python + PostgreSQL application that assists in the provisioning of Hot Standby, Warm Standby, Cold Standby, Streaming Replication clusters and multiple standbys (slaves). It supports all PostgreSQL versions from 8.2+ including 9.2.

Requirements:

• Rsync
• Python >= 2.6
• SSH
• PostgreSQL 8.2+

Getting pitrtools¶

• Stable tarball (05/21/13): pitrtools-1.3.tar.bz2

• GIT (unstable):
  

  $ git clone git://github.com/commandprompt/PITRTools.git
  

Documentation¶

The documentation is reference documentation. You will need to be at least familiar with how PostgreSQL and log-shipping works.

• Standby documentation: https://github.com/commandprompt/PITRTools/blob/master/doc/cmd_standby.README
• Archiver documentation: https://github.com/commandprompt/PITRTools/blob/master/doc/cmd_archiver.README
• pitrtools how-to: How To Configure Warm Standby with pitrtools (provides example for SR/HS too)
• There is a talk that was given at SCALE and PostgreSQL Conference that can be found at SlideShare .

Get involved¶

• Our code is available on github: https://github.com/commandprompt/PITRTools

Bug tracker¶

• Submit a new bug report (please, create an account first)
• View open pitrtools bugs

Getting Help¶

• There is consulting available from Command Prompt, Inc.
• A very low-traffic mailing list