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

"Tomás A. Rossi" tomas at mecon.gov.ar
Mon Jan 8 14:58:11 UTC 2007


Hello people:

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>





More information about the Pgcluster-general mailing list