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> pglb.conf en el balanceador de carga: #--------------------------------------------------- # Cluster DB 1 #--------------------------------------------------- <Cluster_Server_Info> <Host_Name> eipad1.uci.cu </Host_Name> <Port> 5001 </Port> <Max_Connect> 32 </Max_Connect> </Cluster_Server_Info> #--------------------------------------------------- # Cluster DB 5 #--------------------------------------------------- <Cluster_Server_Info> <Host_Name> eipad5.uci.cu </Host_Name> <Port> 5005 </Port> <Max_Connect> 32 </Max_Connect> </Cluster_Server_Info> #--------------------------------------------------- # Load Balancer 3 #--------------------------------------------------- <Host_Name> eipad3.uci.cu </Host_Name> <Backend_Socket_Dir> /tmp </Backend_Socket_Dir> <Receive_Port> 5432 </Receive_Port> <Recovery_Port> 6001 </Recovery_Port> <Max_Cluster_Num> 128 </Max_Cluster_Num> <Use_Connection_Pooling> no </Use_Connection_Pooling> <LifeCheck_Timeout> 3s </LifeCheck_Timeout> <LifeCheck_Interval> 15s </LifeCheck_Interval> <Connection_Life_Time> 0s </Connection_Life_Time> <Log_File_Name> /tmp/pglb.log </Log_File_Name> <Log_File_Size> 1M </Log_File_Size> <Log_Rotate> 3 </Log_Rotate> Agradecería cualquier ayuda, Gracias. -- TIP 1: para suscribirte y desuscribirte, visita http://archives.postgresql.org/pgsql-es-ayuda