[Pgpool-general] pgpool-II working but not balancing load?

[Rolf Dybdal]

Hi everyone!

My setup is; two postgres databases (9.0.3) replicated using streaming
replication and one frontend running pgpool-II 3.0.3.
The replication works great, and if I connect to the databases indvidually,
I get the same result from my queries for both databases.
Pgpool also seems to work, and both db-servers get the expected number of
connections set up, but when I check the traffic to the servers, I see that
only one of the servers get the queries, and that the connections to the
other server is just left idle.
If I detach (pcp_detach_node) the server that receives all the requests, the
other one takes over. And when I attach the node, all queries are directed
to that server again. In itself, a positive result, but not balanced.
Even if I set weight to 0 on node 0 and 1.0 on node 1, node 0 still gets all
traffic - and all queries are select only!

I'm not sure if this behaviour is expected, I have tried generating traffic
using JMeter, but wether I run with few threads or many, the situation is
the same.
Log files show now qlues as far as I can see. I have deleted the
pgpool_status file before restart (also tried -D param on startup).

Anyone seeing the same?

Best regard
Rolf Dybdal
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110228/51da464f/attachment.html>