Re: S.O.S., replication sever failover (solved)

This is a multi-part message in MIME format.

Thanks, it all works now. I've discovered that it all was a problem a one of the nodes missing some entry in pg_hba.conf.
The weird thing is that, for the failover to work properly, I had to add the IP of the node in the pg_hba.conf at that node.

I mean:

The IPs are:
ldapserver: 10.11.22.22
ldapserver2: 10.11.80.80

pg_hba.conf at ldapserver2 was:
...
# IPv4 local connections:
host    all         all         127.0.0.1/32            trust # <-- not enough for local pgreplicate to connect.
host    all         all         10.11.22.22/32          trust # ldapserver
...

And I had to add the entry:
host    all         all         10.11.80.80/32          trust # ldapserver2 (and now local pgreplicate can connect to local postmaster).

...which I thought wasn't necessary since 127.0.0.1/32 was present in the ACL. Who knows :)

Thanks for your help,
regards,
--
Tom;

a.mitani@xxxxxxxxxxxxxx escribió:

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@xxxxxxxxxxxxx
http://pgfoundry.org/mailman/listinfo/pgcluster-general

    

_______________________________________________
Pgcluster-general mailing list
Pgcluster-general@xxxxxxxxxxxxx
http://pgfoundry.org/mailman/listinfo/pgcluster-general