Hola,
Tengo montado PgCluster, he configurado dos nodos Cluster DB, un replicador y
un balanceador de carga. He probado la réplica y lo hace muy bien al igual que
la recuperación. Cuando intento conectarme al balanceador de carga con PgAdmin
III, me devuelve el siguiente error:
"Error connecting to the server: server closed the connection unexpectedly.
This probably means the server terminated abnormally before or while processing
the request."
La configuración que tengo es como sigue:
cluster.conf en Cluster DB 1:
#---------------------------------------------------
# Replicator 1
#---------------------------------------------------
<Replicate_Server_Info>
<Host_Name> eipad2.uci.cu </Host_Name>
<Port> 8001 </Port>
<Recovery_Port> 8101 </Recovery_Port>
</Replicate_Server_Info>
#---------------------------------------------------
# Cluster DB 1
#---------------------------------------------------
<Host_Name> eipad1.uci.cu </Host_Name>
<Recovery_Port> 7001 </Recovery_Port>
<Rsync_Path> /usr/bin/rsync </Rsync_Path>
<Rsync_Option> ssh -2 </Rsync_Option>
<Rsync_Compress> yes </Rsync_Compress>
<Rsync_Timeout> 10min </Rsync_Timeout>
<Rsync_Bwlimit> 0KB </Rsync_Bwlimit>
<Pg_Dump_Path> /usr/local/pgsql/bin/pg_dump </Pg_Dump_Path>
<Ping_Path> /bin/ping </Ping_Path>
<When_Stand_Alone> read_only </When_Stand_Alone>
<Replication_Timeout> 1min </Replication_Timeout>
<LifeCheck_Timeout> 3s </LifeCheck_Timeout>
<LifeCheck_Interval> 11s </LifeCheck_Interval>
cluster.conf en Cluster DB 2:
#---------------------------------------------------
# Replicator 1
#---------------------------------------------------
<Replicate_Server_Info>
<Host_Name> eipad2.uci.cu </Host_Name>
<Port> 8001 </Port>
<Recovery_Port> 8101 </Recovery_Port>
</Replicate_Server_Info>
#---------------------------------------------------
# Cluster DB 1
#---------------------------------------------------
<Host_Name> eipad5.uci.cu </Host_Name>
<Recovery_Port> 7001 </Recovery_Port>
<Rsync_Path> /usr/bin/rsync </Rsync_Path>
<Rsync_Option> ssh -2 </Rsync_Option>
<Rsync_Compress> yes </Rsync_Compress>
<Rsync_Timeout> 10min </Rsync_Timeout>
<Rsync_Bwlimit> 0KB </Rsync_Bwlimit>
<Pg_Dump_Path> /usr/local/pgsql/bin/pg_dump </Pg_Dump_Path>
<Ping_Path> /bin/ping </Ping_Path>
<When_Stand_Alone> read_only </When_Stand_Alone>
<Replication_Timeout> 1min </Replication_Timeout>
<LifeCheck_Timeout> 3s </LifeCheck_Timeout>
<LifeCheck_Interval> 11s </LifeCheck_Interval>
Replicador:
#---------------------------------------------------
# Cluster DB 1
#---------------------------------------------------
<Cluster_Server_Info>
<Host_Name> eipad1.uci.cu </Host_Name>
<Port> 5001 </Port>
<Recovery_Port> 7001 </Recovery_Port>
</Cluster_Server_Info>
#---------------------------------------------------
# Cluster DB 5
#---------------------------------------------------
<Cluster_Server_Info>
<Host_Name> eipad5.uci.cu </Host_Name>
<Port> 5005 </Port>
<Recovery_Port> 7005 </Recovery_Port>
</Cluster_Server_Info>
#---------------------------------------------------
# Load Balance Server 1
#---------------------------------------------------
<LoadBalance_Server_Info>
<Host_Name> eipad3.uci.cu </Host_Name>
<Recovery_Port> 6001 </Recovery_Port>
</LoadBalance_Server_Info>
#---------------------------------------------------
# Replicator 1
#---------------------------------------------------
<Host_Name> eipad2.uci.cu </Host_Name>
<Replication_Port> 8001 </Replication_Port>
<Recovery_Port> 8101 </Recovery_Port>
<RLOG_Port> 8301 </RLOG_Port>
<Use_Replication_Log> no </Use_Replication_Log>
<Replication_Timeout> 1min </Replication_Timeout>
<LifeCheck_Timeout> 3s </LifeCheck_Timeout>
<LifeCheck_Interval> 15s </LifeCheck_Interval>
<Log_File_Name> /tmp/pgreplicate.log </Log_File_Name>
<Log_File_Size> 1M </Log_File_Size>
<Log_Rotate> 3 </Log_Rotate>
Agradecería cualquier ayuda, Gracias.
--
TIP 10: no uses HTML en tu pregunta, seguro que quien responda no podr� leerlo
