Re: limit connections pgpool

> Hi, i want to know what is the pgpool parameter for close the
> connections directly in the database, because the pgpool II close fine
> the the childs with the life time, but the connection in the database
> continue open in idle state.

That's the result of connection cache functionality of pgpool-II. If
you don't need the connection cache of pgpool-II at all, you could
turn it off:

connection_cache = off

Or you could set following to non 0.

connection_life_time

After an idle connection to PostgreSQL backend lasts for
connection_life_time seconds, the connection will be turned off.

If you have further questions, you'd better to subscribe and post the
question:

http://www.pgpool.net/mailman/listinfo/pgpool-general
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> this is my pool config
>
> num_init_children = 100
> max_pool = 8
> child_life_time = 60
> child_max_connections = 0
> connection_life_time = 0
> client_idle_limit = 60
>
>
> and this is my postgresql.conf
>
> max_connections = 800
> shared_buffers =  2048MB
> temp_buffers =  64MB
> work_mem = 2048MB
> maintenance_work_mem = 2048MB
> wal_buffers = 256
> checkpoint_segments = 103
>
>
> thanks
>
>
> --
> Sent via pgsql-performance mailing list
> (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance