All pastes #375927 Raw Edit

Untitled

public text v1 · immutable
#375927 ·published 2007-02-28 18:42 UTC
rendered paste body
#=============================================================
#  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 .
#-------------------------------------------------------------
<Cluster_Server_Info>
    <Host_Name>   miami7 </Host_Name>
    <Port>        5432                </Port>
    <Recovery_Port>       7001        </Recovery_Port>
</Cluster_Server_Info>
<Cluster_Server_Info>
    <Host_Name>   miami6 </Host_Name>
    <Port>        5432                </Port>
    <Recovery_Port>       7001        </Recovery_Port>
</Cluster_Server_Info>
<Cluster_Server_Info>
    <Host_Name>   miami5 </Host_Name>
    <Port>        5432                </Port>
    <Recovery_Port>       7001       </Recovery_Port>
</Cluster_Server_Info>
#
#-------------------------------------------------------------
# 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 .
#-------------------------------------------------------------
#<LoadBalance_Server_Info>
#	<Host_Name>   loadbalancer.postgres.jp  </Host_Name>
#	<Recovery_Port>       6001            </Recovery_Port>
#</LoadBalance_Server_Info>
#
#------------------------------------------------------------
# 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 .
#------------------------------------------------------------
#<Replicate_Server_Info>
#	<Host_Name> upper_replicate.postgres.jp </Host_Name>
#	<Port> 8002 </Port>
#	<Recovery_Port> 8102 </Recovery_Port>
#</Replicate_Server_Info>
#
#-------------------------------------------------------------
# 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
#-------------------------------------------------------------
<Host_Name> 		miami7 </Host_Name>
<Replication_Port>		8001		</Replication_Port>
<Recovery_Port>			8101		</Recovery_Port>
<RLOG_Port>				8301		</RLOG_Port>
<Response_Mode>			normal		</Response_Mode>
<Use_Replication_Log>	no			</Use_Replication_Log>
<Replication_Timeout>	1min		</Replication_Timeout>
<LifeCheck_Timeout>		3s			</LifeCheck_Timeout>
<LifeCheck_Interval>	15s			</LifeCheck_Interval>
#-------------------------------------------------------------
# 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.
#-------------------------------------------------------------
<Log_File_Info>
	<File_Name> /var/lib/pgsql/pgreplicate.log </File_Name>
	<File_Size> 1M </File_Size>
	<Rotate> 3 </Rotate>
</Log_File_Info>