[Pgcluster-general] pgcluster 1.7.0rc5, load balancer and pgreplicate

[Monde Hans]

Hi Guys I have the following setup with two servers.
My config files are as follows. I do not see any errors from the log
files but if I create a database on linux-uuv7 it does not show on
fcdatarp. and there are no errors on both servers what will I have to
change so that the changes can reflect.


#-------------------------------------------------------------
# file: pgreplicate.conf
#-------------------------------------------------------------
# A setup of Cluster DB(s)
#-------------------------------------------------------------
<Cluster_Server_Info>
    <Host_Name> linux-uuv7 </Host_Name>
    <Port> 5432 </Port>
    <Recovery_Port> 7001 </Recovery_Port>
</Cluster_Server_Info>
<Cluster_Server_Info>
    <Host_Name> fcdatarp </Host_Name>
    <Port> 5432 </Port>
    <Recovery_Port> 7001 </Recovery_Port>
</Cluster_Server_Info>
#--------------------------------------------------------------------
# A setup of loader balancer
#--------------------------------------------------------------------
<LoadBalance_Server_Info>
    <Host_Name> linux-uuv7 </Host_Name>
    <Recovery_Port> 6101 </Recovery_Port>
</LoadBalance_Server_Info>
<LoadBalance_Server_Info>
    <Host_Name> fcdatarp </Host_Name>
    <Recovery_Port> 6101 </Recovery_Port>
</LoadBalance_Server_Info>
#------------------------------------------------------------
# A setup of a replication server
#-------------------------------------------------------------
<Host_Name> linux-uuv7	</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 
#-------------------------------------------------------------
<Log_File_Info>
	<File_Name> /var/log/postgresql/pgreplicate.log </File_Name>
	<File_Size> 1M </File_Size>
	<Rotate> 3 </Rotate>
</Log_File_Info>


#-------------------------------------------------------------
# file: pglb.conf
#-------------------------------------------------------------
# set cluster DB server information
#--------------------------------------------------------------------
<Cluster_Server_Info>
    <Host_Name> linux-uuv7 </Host_Name>
    <Port> 5432 </Port>
    <Max_Connect> 30 </Max_Connect> 
</Cluster_Server_Info>
<Cluster_Server_Info>
    <Host_Name> fcdatarp </Host_Name>
    <Port> 5432 </Port>
    <Max_Connect> 30 </Max_Connect> 
</Cluster_Server_Info> 

#-------------------------------------------------------------
# set Load Balance server information
#-------------------------------------------------------------
<Host_Name>   linux-uuv7  </Host_Name>
<Backend_Socket_Dir>    /tmp     </Backend_Socket_Dir>
<Receive_Port>          5433     </Receive_Port>
<Recovery_Port>         6101     </Recovery_Port>
<Max_Cluster_Num>        128     </Max_Cluster_Num>
<Use_Connection_Pooling>  no     </Use_Connection_Pooling>
<LifeCheck_Timeout>		3s			</LifeCheck_Timeout>
<LifeCheck_Interval>	15s			</LifeCheck_Interval>
#-------------------------------------------------------------
# A setup of a log files 
#-------------------------------------------------------------
<Log_File_Info>
	<File_Name> /var/log/postgresql/pglb.log </File_Name>
	<File_Size> 1M </File_Size>
	<Rotate> 3 </Rotate>
</Log_File_Info>

#============================================================
#          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> linux-uuv7 </Host_Name>
        <Port> 8001 </Port>
        <Recovery_Port> 8101 </Recovery_Port>
</Replicate_Server_Info>
<Replicate_Server_Info>
        <Host_Name> fcdatarp </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>			linux-uuv7	</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/local/pgsql/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>

M


To read FirstRand Bank's Disclaimer for this email click on the following address or copy into your Internet browser: 
https://www.fnb.co.za/disclaimer.html 

If you are unable to access the Disclaimer, send a blank e-mail to
firstrandbankdisclaimer at fnb.co.za and we will send you a copy of the Disclaimer.