Hello all, we have following configuration:
Node1: Node2: ClusterDB1 ClusterDB2 Pgreplicate1 Pgreplicate2 It works, if we inserting record into table at one node it appears at another, same for deletion. If we put Node1 down, insert some records into table at Node2 and when turn on Node1 again then Node1 gets synchronized with Node2. After this if we inserting record into table at Node1 it appears at Node2, but not vice versa -- if we inserting record into table at Node2 it not replicated to Node1. After restarting pgreplicate on Node2 all works again. I have found description of the similar problem in this list http://lists.pgfoundry.org/pipermail/pgcluster-general/2008-February/001852.html Just want to ask if any solution exists? Here configurations files for NSP1: ##### cluster.conf ##### <Replicate_Server_Info> <Host_Name> NSP1 </Host_Name> <Port> 5006 </Port> <Recovery_Port> 5007 </Recovery_Port> </Replicate_Server_Info> <Replicate_Server_Info> <Host_Name> NSP2 </Host_Name> <Port> 5006 </Port> <Recovery_Port> 5007 </Recovery_Port> </Replicate_Server_Info> <Host_Name>NSP1</Host_Name> <Recovery_Port> 5005 </Recovery_Port> <Rsync_Path> /usr/bin/rsync </Rsync_Path> <Rsync_Option> ssh -2 </Rsync_Option> <Rsync_Compress> yes </Rsync_Compress> <Pg_Dump_Path> /usr/bin/pg_dump </Pg_Dump_Path> <When_Stand_Alone> read_write </When_Stand_Alone> <Replication_Timeout> 1 min </Replication_Timeout> <LifeCheck_Timeout> 3s </LifeCheck_Timeout> <LifeCheck_Interval> 11s </LifeCheck_Interval> ##### pgreplicate.conf ##### <Cluster_Server_Info> <Host_Name> NSP1 </Host_Name> <Port> 5004 </Port> <Recovery_Port> 5005 </Recovery_Port> </Cluster_Server_Info> <Cluster_Server_Info> <Host_Name> NSP2 </Host_Name> <Port> 5004 </Port> <Recovery_Port> 5005 </Recovery_Port> </Cluster_Server_Info> <Host_Name> NSP1 </Host_Name> <Replication_Port> 5006 </Replication_Port> <Recovery_Port> 5007 </Recovery_Port> <RLOG_Port> 5008 </RLOG_Port> <Response_Mode> reliable </Response_Mode> <Use_Replication_Log> yes </Use_Replication_Log> <Replication_Timeout> 5s </Replication_Timeout> <LifeCheck_Timeout> 1s </LifeCheck_Timeout> <LifeCheck_Interval> 15s </LifeCheck_Interval> <Log_File_Info> <File_Name> /var/log/postgres/pgreplicate.log </File_Name> <File_Size> 1M </File_Size> <Rotate> 3 </Rotate> </Log_File_Info> NSP2 has analogous configuration -- Best regards, Pavel Shaydo _______________________________________________ Pgcluster-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgcluster-general
