[Pgcluster-general] Load Ballancer problems

[mitani at sraw.co.jp]

Hi,

Could you show the setting of each cluster DB (i.e pg_hba.conf, postgresql.conf and cluster.conf).

Regards,

-- original message --
From: Sean Brown<sbrown at eaglepress.com>
To: <pgcluster-general at pgfoundry.org>
Sent: Fri, 14 Mar 2008 16:25:24 -0400
Subject: [Pgcluster-general] Load Ballancer problems

>I have a 2 node cluster DB up and running and replicating between each other. I am now trying to get the Load Ballancer set up. Nothing gets logged. I can log on to each of the postgres databases with psql from the load ballancer system.
>
>It doesn't seem to ever mark the back end as usable:
>/usr/local/bin/pglb -D /etc/pg_cluster/ -nv
>2008-03-14 16:14:04 [26988] DEBUG:PGRset_status_on_cluster_tbl():host:node1.domain.local port:5432 max:200 use:0 status1
>2008-03-14 16:14:04 [26988] DEBUG:PGRset_status_on_cluster_tbl():host:node2.domain.local port:5432 max:200 use:0 status1
>2008-03-14 16:14:04 [26988] DEBUG:init_pglb():Child_Tbl size is[482400]
>
>It just sits there after this.
>
>pglb.conf:
><Cluster_Server_Info>
>        <Host_Name> node1.domain.local </Host_Name>
>        <Port> 5432 </Port>
>        <Max_Connect> 200 </Max_Connect>
></Cluster_Server_Info>
>
><Cluster_Server_Info>
>        <Host_Name> node2.domain.local </Host_Name>
>        <Port> 5432 </Port>
>        <Max_Connect> 200 </Max_Connect>
></Cluster_Server_Info>
>
>
><Host_Name> lb.domain.local </Host_Name>
><Recieve_Port> 5432 </Recieve_Port>
><Recovery_Port> 6101 </Recovery_Port>
><Use_Connection_Pooling> no </Use_Connection_Pooling>
><Max_Cluster_Num> 200 </Max_Cluster_Num>
><Life_Check_Timeout> 3s <Life_Check_Timeout>
><Life_Check_Interval> 20s <Life_Check_Interval>
><Log_File_Info>
>        <File_Name> /var/log/postgres/pglb.log </File_Name>
>        <File_Size> 10M </File_Size>
>        <Rotate> 3 </Rotate>
></Log_File_Info>
>
>pglb.sts
>Fri Mar 14 16:21:30 2008  port(5432) host:node1.domain.local initialize
>Fri Mar 14 16:21:30 2008  port(5432) host:node2.domain.local initialize
>
>/etc/hosts
>127.0.0.1       localhost.localdomain   localhost
>
>10.10.0.45      node1.domain.local node1
>10.10.0.46      node2.domain.local node2
>
>10.10.0.47      lb.domain.local lb
>
>_______________________________________________
>Pgcluster-general mailing list
>Pgcluster-general at pgfoundry.org
>http://pgfoundry.org/mailman/listinfo/pgcluster-general
>