[Pgcluster-general] Problem with load balancer

[Jakob Lechner]

Hello everybody,

I'm trying to setup pgcluster with two nodes. I'm using
pgcluster-1.7rc4. Replication seems to work fine but I'm having a
problem with load balancer:

If I just start postmaster on one of the two nodes I'm able to issue
just one select query with the load balancer. All subsequent queries
fail. Psql provides this error message:

psql: expected authentication request from server, but received S


I have started the load balancer with -n -v parameters to see debug
outputs:

2007-02-22 14:26:20 [3071] DEBUG:PGRscan_cluster:0 ClusterDB can be used
2007-02-22 14:26:20 [3071] DEBUG:PGRscan_cluster:sqpgvmn1cgrhel
[5432],useFlag->98 max->32 use_num->1

2007-02-22 14:26:20 [3071] DEBUG:PGRscan_cluster:0 ClusterDB can be used
2007-02-22 14:26:20 [3071] DEBUG:PGRscan_cluster:sqpgvmn1cgrhel
[5432],useFlag->98 max->32 use_num->1

2007-02-22 14:26:20 [3071] DEBUG:PGRscan_cluster:0 ClusterDB can be used
2007-02-22 14:26:20 [3071] DEBUG:PGRscan_cluster:sqpgvmn1cgrhel
[5432],useFlag->98 max->32 use_num->1

2007-02-22 14:26:20 [3071] DEBUG:PGRscan_cluster:0 ClusterDB can be used
2007-02-22 14:26:20 [3071] DEBUG:PGRscan_cluster:sqpgvmn1cgrhel
[5432],useFlag->98 max->32 use_num->1

2007-02-22 14:26:20 [3071] DEBUG:PGRscan_cluster:0 ClusterDB can be used
2007-02-22 14:26:20 [3071] DEBUG:PGRscan_cluster:sqpgvmn1cgrhel
[5432],useFlag->98 max->32 use_num->1

2007-02-22 14:26:20 [3071] ERROR:PGRload_balance():no cluster available
2007-02-22 14:26:20 [3071] ERROR:load_balance_main():load balance
process failed

"sqpgvmn1cgrhel" is the hostname of the node where the load balancer is
running. Postmaster is running on an other machine with the name
"sqpgvmn2cgrhel".

Here is the config file of the load balancer (pglb.conf):

<Cluster_Server_Info>
    <Host_Name>  sqpgvmn1cgrhel  </Host_Name>
    <Port>        5432                </Port>
    <Max_Connect> 32                   </Max_Connect>
</Cluster_Server_Info>
<Cluster_Server_Info>
    <Host_Name>   sqpgvmn2cgrhel   </Host_Name>
    <Port>        5432                </Port>
    <Max_Connect> 32                  </Max_Connect>
</Cluster_Server_Info>

<Host_Name>   sqpgvmn1cgrhel  </Host_Name>
<Receive_Port>          5433     </Receive_Port>
<Recovery_Port>         6001     </Recovery_Port>
<Max_Cluster_Num>        128     </Max_Cluster_Num>
<Use_Connection_Pooling>  no     </Use_Connection_Pooling>

Any ideas, what might be wrong?
Thanks in advance!

Best regards

-- 
Jakob Lechner
Research & Development
Fabalabs Software GmbH
Honauerstraße 4
A-4020 Linz
Tel.: [+43] (70) 60 61 62
Fax: [+43] (70) 60 61 62-609
E-Mail: jakob.lechner at fabalabs.org
Web: http://www.fabalabs.org