[Pgcluster-general] Strange problems...

[John Gardner]

a.mitani at sra-europe.com wrote:
> Hi,
> 
> 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