[Pgcluster-general] S.O.S., replication sever failover

[a.mitani at sra-europe.com]

Hi,

I checked take over of replication servers with 3 x Cluster DB and 2 x
replication server.
It works normally as expected.

Please let us know your actual operation and debug messages of each
replication server.

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


> I have the following configuration:
> 2 nodes: one is a Redhat (named ldapserver) and the other a FreeBSD
> (named ldapserver2).
> In each of them I have a replicator and a cluster (no load balancer).
> The replicator at ldapserver is the root replicator.
>
> When I shut down the root replicator and try to write to some cluster,
> the operation hangs. It never completes (it seems), like if the failover
> didn't work.
>
> What am I doing wrong :( ?
>
> Below I've attached the minimal version of my config files. Hope you can
> help me.
> Thanks in advance,
> --
> Tom;
>
> pgreplicate.conf at ldapserver:
>
> <Cluster_Server_Info>
>     <Host_Name>     ldapserver </Host_Name>
>     <Port>          5432       </Port>
>     <Recovery_Port> 7001       </Recovery_Port>
> </Cluster_Server_Info>
>
> <Cluster_Server_Info>
>     <Host_Name>     ldapserver2 </Host_Name>
>     <Port>          5432        </Port>
>     <Recovery_Port> 7001        </Recovery_Port>
> </Cluster_Server_Info>
>
> <Host_Name>           ldapserver </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> yes        </Use_Replication_Log>
> <Replication_Timeout> 10s        </Replication_Timeout>
>
> cluster.conf at ldapserver:
>
> <Replicate_Server_Info>
>         <Host_Name>     ldapserver </Host_Name>
>         <Port>          8001       </Port>
>         <Recovery_Port> 8101       </Recovery_Port>
> </Replicate_Server_Info>
>
> <Replicate_Server_Info>
>         <Host_Name>     ldapserver2 </Host_Name>
>         <Port>          8001        </Port>
>         <Recovery_Port> 8101        </Recovery_Port>
> </Replicate_Server_Info>
>
> <Host_Name>           ldapserver                   </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> 10s                          </Replication_Timeout>
>
> pgreplicate.conf at ldapserver2:
>
> <Cluster_Server_Info>
>     <Host_Name>     ldapserver </Host_Name>
>     <Port>          5432       </Port>
>     <Recovery_Port> 7001       </Recovery_Port>
> </Cluster_Server_Info>
>
> <Cluster_Server_Info>
>     <Host_Name>     ldapserver2 </Host_Name>
>     <Port>          5432        </Port>
>     <Recovery_Port> 7001        </Recovery_Port>
> </Cluster_Server_Info>
>
> <Replicate_Server_Info>
>         <Host_Name>     ldapserver </Host_Name>
>         <Port>          8001       </Port>
>         <Recovery_Port> 8101       </Recovery_Port>
> </Replicate_Server_Info>
>
> <Host_Name>           ldapserver2 </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> yes         </Use_Replication_Log>
> <Replication_Timeout> 10s         </Replication_Timeout>
>
> cluster.conf at ldapserver2:
>
> <Replicate_Server_Info>
>         <Host_Name>     ldapserver </Host_Name>
>         <Port>          8001       </Port>
>         <Recovery_Port> 8101       </Recovery_Port>
> </Replicate_Server_Info>
>
> <Replicate_Server_Info>
>         <Host_Name>     ldapserver2 </Host_Name>
>         <Port>          8001        </Port>
>         <Recovery_Port> 8101        </Recovery_Port>
> </Replicate_Server_Info>
>
> <Host_Name>           ldapserver2                  </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> 10s                          </Replication_Timeout>
>
>
>
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgcluster-general
>