[pgpool-general: 1282] pgpool not load balancing

[Greg Donald]

I'm having problems getting pgpool to send any queries to anything
other than my master.

Looking at the log I'm thinking this is the problem, but I'm not sure
how to fix it:

Jan  5 17:34:41 pool pgpool: 2013-01-05 17:34:41 DEBUG: pid 3006:
new_connection: connecting 0 backend
Jan  5 17:34:41 pool pgpool: 2013-01-05 17:34:41 DEBUG: pid 3006:
new_connection: connecting 1 backend
Jan  5 17:34:41 pool pgpool: 2013-01-05 17:34:41 DEBUG: pid 3006:
new_connection: skipping slot 1 because backend_status = 1
Jan  5 17:34:41 pool pgpool: 2013-01-05 17:34:41 DEBUG: pid 3006:
new_connection: connecting 2 backend
Jan  5 17:34:41 pool pgpool: 2013-01-05 17:34:41 DEBUG: pid 3006:
new_connection: skipping slot 2 because backend_status = 3


I have 4 Ubuntu 12.04 VMs setup like this:

192.168.1.80 <- pool, pgppool2 installed and accessible
192.168.1.81 <- db1 master
192.168.1.82 <- db2 slave
192.168.1.83 <- db3 slave

I have pgpool-II version 3.1.1 and my database servers are running
PostgreSQL 9.1.


Here's my pgpool.conf

http://pastebin.com/raw.php?i=DNw8GvgF



Thanks.



-- 
Greg Donald