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
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
