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 support 

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+

#rpm-qa|greprsyncrsync-3.0.6-9.el6_4.1.x86_64#python-VPython2.6.6$pg_config--versionPostgresql9.3.4

编译安装：

pg_standby

pg_archivecleanup

[root@masterdb~]#mkdir/opt/pg93/archive[root@masterdb~]#chownpostgres:postgres/opt/pg93/archive/$cd/opt/pitrtools-1.3/etc/$cpcmd_archiver.ini.samplecmd_archiver.ini$cpcmd_standby.ini.samplecmd_standby.ini

cmd_standby

Thecmd_standbyscriptisautilitythatallowseasymanagementofalltypesofstandbyPostgresqlservers,fromcoldtowarmandstreamingrepliaction.ItcurrentlyhasthefollowingcapabilitIEs:*Easilytakeabasebackup,includingtablespaces*Restorearchives*automaticallypurgeoldarchives(ifPostgresql>8.3)*Alertbasedonfailures*StopandstartPostgresqlstandby*Failovertothelatestrestorepointandpoint-in-timerecoveryUsage:cmd_standby[options]arg1arg2Options:-h,--helpshowthishelpmessageandexit-Astart|stop,--action=start|stopStartorStopPostgresql-B,--basebackupStart/Stopabasebackup-Cfile,--config=filethenameofthestandbyconfigfile-FVALUE,--failover=VALUEValueisa3digitnumber999-I,--dbinitUsebefore-B-P,--PingIsmymasteralive?-RTIMESTAMP,--recovertotime=TIMESTAMPIfyouneedtorestoretoaspecificpointintime-S,--standbyEnterstandbymode

cmd_archiver

cmd_archiverscriptisusedinconjunctionwithPostgresql'snativearchivemodefunctionalitytoshipwALsegmentstoconfiguredstandbyservertoreplaythem.*automaticallyshiplogfilestoconfiguredstandbyserver*Enable/disablearchivingwithouttheneedtorestartPostgresql*AlertbasedonfailuresUsage:cmd_archiver[options]arg1arg2Options:-h,--helpShowthishelpmessageandexit-Ffile,--file=fileArchivefile-Cfile,--config=fileThenameofthearchiverconfigfile-f,--flushFlushallremainingarchivestoslave-I,--initinitializemasterenvironment

总结

以上是内存溢出为你收集整理的PITRTools全部内容，希望文章能够帮你解决PITRTools所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。