[pgpool-general: 1282] pgpool not load balancing
Greg Donald
gdonald at gmail.com
Sun Jan 6 09:06:06 JST 2013
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
More information about the pgpool-general
mailing list