Project

General

Profile

WikiStart » History » Revision 29

Revision 28 (Ivan Lezhnjov, 05/21/2013 11:34 AM) → Revision 29/30 (Ivan Lezhnjov, 05/22/2013 05:59 AM)

h1. pitrtools 

 pitrtools Welcome to Pitrtools Wiki 


 PITRTools is a Python + PostgreSQL application set of wrapper scripts that assists in provide warm standby functionality to [[PostgreSQL]]. The software is essentially two scripts, cmd_archiver.py and cmd_standby.py. The project is under 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+ 

 BSD license. 

 h2. Getting pitrtools PITRTools 


 * Stable tarball (05/21/13): "pitrtools-1.3.tar.bz2":https://files.commandprompt.com/pitrtools/pitrtools-1.3.tar.bz2 

  

 * GIT (unstable): (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 [[PostgreSQL]] and log-shipping log shipping works. 

 ** Standby documentation: https://github.com/commandprompt/PITRTools/blob/master/doc/cmd_standby.README https://github.com/commandprompt/PITRTools/blob/master/cmd_standby.README 
 ** Archiver documentation: https://github.com/commandprompt/PITRTools/blob/master/doc/cmd_archiver.README https://github.com/commandprompt/PITRTools/blob/master/cmd_archiver.README 
 ** pitrtools PITRtools how-to: [[How To Configure Warm Standby with pitrtools]] (provides example for SR/HS too) PITRTools]] 
 ** 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: Git Repo: 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 Prompt":http://www.commandprompt.com 
 * A There is a very low-traffic low traffic "mailing list":http://lists.commandprompt.com/mailman/listinfo/pitrtools/