[pgpool-general: 1283] Re: pgpool not load balancing

[Tatsuo Ishii]

> 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.

I guess pgpool remembers old down status. To discard old down status,
you would want to start pgpool with -D option.

BTW, 3.1.1 is way too old. The latest version of 3.1-stable is 3.1.5.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp