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