[Pgcluster-general] pgcluster 1.7.0rc5, load balancer and pgreplicate
a.mitani at sra-europe.com
a.mitani at sra-europe.com
Mon Jun 18 12:24:47 UTC 2007
Hi Hans,
It seems that there is no problem in each configuration files.
Would you show us the debug messages of replication server.
You can see it when start replication server with debug option (-vn).
Regards,
--------------
At.Mitani
> 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.
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgcluster-general
>
More information about the Pgcluster-general
mailing list