[Pgcluster-general] Strange problems...

[a.mitani at sra-europe.com]

Hi,

The format of configuration file seems a bit strange for me.
It seems mixed old version and new version format.
The current version doesn't have a lifecheck port parameter, and old
version didn't have a log rotation parameter.

Please use the same version of configuration file with using PGCluster.

And one more,
please set "no" to "<Use_Replication_Log>" tag in "pgreplicate.conf", when
you don't use it.

Regards,
-------------
At.Mitani

>> I'm afraid that the configuration may be incorrect.
>> Could you show us your configuration files
>> (pgreplicate.conf/cluster.conf)
>> and your network information (hostname, IP address etc.), if you can.
>>
>> And, please do not remove the template database.
>> These are required for postgresql as well.
>>
>> Regards,
>> -----------------
>> At.Mitani
>>
>
> Thanks At
>
> OK, here they are...
>
> The host names are as follows:
>
> cluster_1 = 192.168.75.14 (Cluster DB)
> cluster_2 = 192.168.75.20 (Cluster DB)
> replicate_upper = 192.168.75.20 (Replicator)
>
>
>
> The cluster.conf from cluster_1:
>
> #--------------------------------------------------------------------
> # A setup of a replication server
> #--------------------------------------------------------------------
> <Replicate_Server_Info>
>
>     <Host_Name> replicate_upper </Host_Name>
>     <Port> 8001 </Port>
>     <Recovery_Port> 8101 </Recovery_Port>
>     <LifeCheck_Port> 8201 </LifeChck_Port>
>
> </Replicate_Server_Info>
> #--------------------------------------------------------------------
> # The setup value of Cluster DB
> #--------------------------------------------------------------------
> <Recovery_Port> 7101 </Recovery_Port>
> <LifeCheck_Port> 7201 </LifeCheck_Port>
> <Rsync_Path> /usr/bin/rsync </Rsync_Path>
> <Rsync_Option> ssh -1 </Rsync_Option>
> <When_Stand_Alone> read_only </When_Stand_Alone>
> <Status_Log_File> /tmp/cluster.sts </Status_Log_File>
> <Error_Log_File> /tmp/cluster.err </Error_Log_File>
> #--------------------------------------------------------------------
> # The combination of DB+ table which does not perform a replication
> # (Partial replication function)
> #--------------------------------------------------------------------
> <Not_Replicate_Info>
>
>     <DB_Name> Local_DB </DB_Name>
>     <Table_Name> Log_Table </Table_Name>
>
> </Not_Replicate_Info>
>
>
>
>
>
> The cluster.conf from cluster_2:
>
> #--------------------------------------------------------------------
> # A setup of a replication server
> #--------------------------------------------------------------------
> <Replicate_Server_Info>
>
>     <Host_Name> replicate_upper </Host_Name>
>     <Port> 8001 </Port>
>     <Recovery_Port> 8101 </Recovery_Port>
>     <LifeCheck_Port> 8201 </LifeChck_Port>
>
> </Replicate_Server_Info>
> #--------------------------------------------------------------------
> # The setup value of Cluster DB
> #--------------------------------------------------------------------
> <Recovery_Port> 7101 </Recovery_Port>
> <LifeCheck_Port> 7201 </LifeCheck_Port>
> <Rsync_Path> /usr/bin/rsync </Rsync_Path>
> <Rsync_Option> ssh -1 </Rsync_Option>
> <When_Stand_Alone> read_only </When_Stand_Alone>
> <Status_Log_File> /tmp/cluster.sts </Status_Log_File>
> <Error_Log_File> /tmp/cluster.err </Error_Log_File>
> #--------------------------------------------------------------------
> # The combination of DB+ table which does not perform a replication
> # (Partial replication function)
> #--------------------------------------------------------------------
> <Not_Replicate_Info>
>
>     <DB_Name> Local_DB </DB_Name>
>     <Table_Name> Log_Table </Table_Name>
>
> </Not_Replicate_Info>
>
>
>
>
> The pgreplicate.conf from replicate_upper:
>
> #--------------------------------------------------------------------
> # The setup value of Cluster DB
> #--------------------------------------------------------------------
> <Cluster_Server_Info>
>
>     <Host_Name> cluster_1 </Host_Name>
>     <Port> 5432 </Port>
>     <Recovery_Port> 7101 </Recovery_Port>
>     <LifeCheck_Port> 7201 </LifeCheck_Port>
>
> </Cluster_Server_Info>
> <Cluster_Server_Info>
>
>     <Host_Name> cluster_2 </Host_Name>
>     <Port> 5432 </Port>
>     <Recovery_Port> 7101 </Recovery_Port>
>     <LifeCheck_Port> 7201 </LifeCheck_Port>
>
> </Cluster_Server_Info>
> #--------------------------------------------------------------------
> # A setup of a replication server
> #--------------------------------------------------------------------
> <Status_Log_File> /usr/local/pgsql/pgreplicate.sts </Status_Log_File>
> <Error_Log_File> /usr/local/pgsql/pgreplicate.log </Error_Log_File>
> <Replication_Port> 8001 </Replication_Port>
> <Recovery_Port> 8101 </Recovery_Port>
> <LifeCheck_Port> 8201 </LifeCheck_Port>
> <RLOG_Port> 8301 </RLOG_Port>
> <Response_Mode> normal </Response_Mode>
> <Use_Replication_Log> yes </Use_Replication_Log>
> <Reserved_Connections> 1 </Reserved_Connections>
> #--------------------------------------------------------------------
> <Log_File_Info>
>         <File_Name> /usr/local/pgsql/pgreplicate1.log </File_Name>
>         <File_Size> 1M </File_Size>
>         <Rotate> 3 </Rotate>
> </Log_File_Info>
>
>
> Is this anywhere near?
>
> Thanks
>
> John
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgcluster-general
>