[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