[Pgpool-general] Help with pgpool

[Tatsuo Ishii]

> Hi everyone, i wanted to test pgpool, so i setup postgresql to accept up to 2 conections, then i used pgbench to send 10 request from 10 clients and its failing, shouldn pgpool puts the 8 remaining conections in queue? Ideas???
> 
> Connection to database "test" failed:
> FATAL:  sorry, too many clients already
> Client 1 aborted in establishing connection.
> Connection to database "test" failed:
> FATAL:  sorry, too many clients already
[snip]

You need to set num_init_children of pgpool.conf to 2 in this case.
Also it's not good to use pgbench for connection queuing test. I wrote
the reason on the FAQ:

http://pgpool.projects.postgresql.org/FAQ.html

Please take a look at it.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp