#============================================================= # PGReplicate configuration file #------------------------------------------------------------- # file: pgreplicate.conf #------------------------------------------------------------- # This file controls: # o which hosts & port are cluster server # o which port use for replication request from cluster server #============================================================= # #------------------------------------------------------------- # A setup of Cluster DB(s) # # o Host_Name : The host name of Cluster DB. # Please write a host name by FQDN. # DO NOT write IP address. # o Port : The connection port with postmaster. # o Recovery_Port : The connection port at the time of # a recovery sequence. #------------------------------------------------------------- pg1 5432 7001 pg2 5432 7001 # # pg3 # 5432 # 7001 # # #------------------------------------------------------------- # A setup of Load Balance Server # # o Host_Name : The host name of a load balance server. # Please write a host name by FQDN or IP address. # o Recovery_Port : The connection port at the time of # a recovery sequence . #------------------------------------------------------------- lb1 6001 lb2 6001 lb3 6001 # #------------------------------------------------------------ # A setup of the cascade connection between replication servers. # When you do not use RLOG recovery, you can skip this setup # # o Host_Name : The host name of the upper replication server. # Please write a host name by FQDN or IP address. # o Port : The connection port with postmaster. # o Recovery_Port : The connection port at the time of # a recovery sequence . #------------------------------------------------------------ # # upper_replicate.pgcluster.org # 8002 # 8102 # # #------------------------------------------------------------- # A setup of a replication server # # o Host_Name : The host name of the this replication server. # Please write a host name by FQDN or IP address. # o Replicate_Port : Connection port for replication # o Recovery_Port : Connection port for recovery # o RLOG_Port : Connection port for replication log # o Response_mode : Timing which returns a response # normal -- return result of DB which received the query # reliable -- return result after waiting for response of # all Cluster DBs. # o Use_Replication_Log : Use replication log # [yes/no]. default : no # o Replication_Timeout : Timeout of each replication response # o Lifecheck_Timeout : Timeout of the lifecheck response # o Lifecheck_Interval : Interval time of the lifecheck # (range 1s - 1h) # 10s -- 10 seconds # 10min -- 10 minutes # 1h -- 1 hours #------------------------------------------------------------- rep1 8001 8101 8301 normal no 1min 3s 5s #------------------------------------------------------------- # A setup of a log files # # o File_Name : Log file name with full path # o File_Size : Maximum size of each log files # Please specify in a number and unit(K or M) # 10 -- 10 Byte # 10K -- 10 KByte # 10M -- 10 MByte # o Rotate : Rotation times # If specified 0, old versions are removed. #------------------------------------------------------------- /usr/local/pgsql/pgreplicate.log 1M 3