[Pgcluster-general] Load Ballancer problems

[Sean Brown]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgcluster-general/attachments/20080314/70237189/attachment.html