pitrtools

h1. 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+

h2. Getting pitrtools

* Stable tarball (05/21/13): "pitrtools-1.3.1.tar.bz2":https://public.commandprompt.com/attachments/download/205/pitrtools-1.3.1.tar.bz2

* GIT (unstable):

<pre>

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

</pre>

h2. Documentation

The documentation is reference documentation. You will need to be at least familiar with how "PostgreSQL":http://www.postgresql.org 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":http://www.socallinuxexpo.org/ and "PostgreSQL Conference":http://www.postgresqlconference.org/ that can be found at "SlideShare":http://www.slideshare.net/linuxpoet/pitr-made-easy-1265196 .

h2. Get involved

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

h2. Bug tracker

* "Submit a new bug report":https://public.commandprompt.com/projects/pitrtools/issues/new (please, create an account first)

* "View open pitrtools bugs":https://public.commandprompt.com/projects/pitrtools/issues?utf8=%E2%9C%93&set_filter=1&f%5B%5D=status_id&op%5Bstatus_id%5D=o&f%5B%5D=tracker_id&op%5Btracker_id%5D=%3D&v%5Btracker_id%5D%5B%5D=1&f%5B%5D=&c%5B%5D=tracker&c%5B%5D=status&c%5B%5D=priority&c%5B%5D=subject&c%5B%5D=author&c%5B%5D=assigned_to&c%5B%5D=updated_on&c%5B%5D=created_on&group_by=

h2. Getting Help

* There is consulting available from "Command Prompt, Inc.":http://www.commandprompt.com

* A very low-traffic "mailing list":http://lists.commandprompt.com/mailman/listinfo/pitrtools/