#============================================================= # 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 . #------------------------------------------------------------- miami7 5432 7001 miami6 5432 7001 miami5 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 . #------------------------------------------------------------- # # loadbalancer.postgres.jp # 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.postgres.jp # 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 for replication # o Recovery_Port : connection for recovery # o RLOG_Port : connection 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 #------------------------------------------------------------- miami7 8001 8101 8301 normal no 1min 3s 15s #------------------------------------------------------------- # A setup of a log files # # o File_Name : Log file name with full path # o File_Size : Maximun size of each log files # please specipy in a number and unit(K or M) # 10 -- 10 Byte # 10K -- 10 KByte # 10M -- 10 MByte # o Rotate : Rotation times # if specipied 0, old versions are removed. #------------------------------------------------------------- /var/lib/pgsql/pgreplicate.log 1M 3