All pastes #375925 Raw Edit

Unnamed

public text v1 · immutable
#375925 ·published 2007-02-28 18:40 UTC
rendered paste body
#============================================================
#          Cluster DB Server configuration file
#------------------------------------------------------------
# file: cluster.conf
#------------------------------------------------------------
# This file controls:
#       o which hosts & port are replication server
#       o which port use for replication request to replication server
#       o which command use for recovery function
#============================================================
#------------------------------------------------------------
# set Replication Server information
#		o Host_Name : hostname
#		o Port : connection for postmaster
#		o Recovery_Port : connection for recovery process
#------------------------------------------------------------
<Replicate_Server_Info>
	<Host_Name> miami7 </Host_Name>
	<Port> 8001 </Port>
	<Recovery_Port> 8101 </Recovery_Port>
</Replicate_Server_Info>
#<Replicate_Server_Info>
#	<Host_Name> replicate2.postgres.jp </Host_Name>
#	<Port> 8002 </Port>
#	<Recovery_Port> 8102 </Recovery_Port>
#</Replicate_Server_Info>
#<Replicate_Server_Info>
#	<Host_Name> replicate3.postgres.jp </Host_Name>
#	<Port> 8003 </Port>
#	<Recovery_Port> 8103 </Recovery_Port>
#</Replicate_Server_Info>
#-------------------------------------------------------------
# set Cluster DB Server information
#		o Host_Name : host name which connect with replication server
#		o Recovery_Port : connection for recovery
#		o Rsync_Path : path of rsync command 
#		o Rsync_Option : file transfer option for rsync
#		o Rsync_Compress : use compression option for rsync
#				   [yes/no]. default : yes
#		o Pg_Dump_Path : path of pg_dump
#       o When_Stand_Alone : When all replication servers fell,
#                            you can set up two kinds of permittion,
#                            "real_only" or "read_write".
#		o Replication_Timeout : timeout of each replication request
#		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>			miami6 </Host_Name>
<Recovery_Port>			7001					</Recovery_Port>
<Rsync_Path>			/usr/bin/rsync			</Rsync_Path>
<Rsync_Option>			ssh -1					</Rsync_Option>
<Rsync_Compress>		yes						</Rsync_Compress>
<Pg_Dump_Path>			/usr/bin/pg_dump	</Pg_Dump_Path>
<When_Stand_Alone>		read_only				</When_Stand_Alone>
<Replication_Timeout>	1min					</Replication_Timeout>
<LifeCheck_Timeout>		3s						</LifeCheck_Timeout>
<LifeCheck_Interval>	11s						</LifeCheck_Interval>
#-------------------------------------------------------------
# set partitional replicate control information
#     set DB name and Table name to stop reprication
#       o DB_Name : DB name
#       o Table_Name : table name
#-------------------------------------------------------------
#<Not_Replicate_Info>
#	<DB_Name>     test_db      </DB_Name>
#	<Table_Name>  log_table    </Table_Name>
#</Not_Replicate_Info>