[Pgcluster-general] S.O.S., replication sever failover (solved)
"Tomás A. Rossi"
tomas at mecon.gov.ar
Mon Jan 8 20:10:00 UTC 2007
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 at sra-europe.com 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 at pgfoundry.org
>> http://pgfoundry.org/mailman/listinfo/pgcluster-general
>>
>>
>
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgcluster-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgcluster-general/attachments/20070108/1fab312c/attachment-0001.html
More information about the Pgcluster-general
mailing list