Обсуждение: 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.

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

On Fri, Oct 11, 2013 at 12:00 AM, Jeison Bedoya Delgado
<jeisonb@audifarma.com.co> wrote:
> 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.
You should ask that directly to the pgpool mailing lists:
http://www.pgpool.net/mediawiki/index.php/Mailing_lists

Regards,
--
Michael

> 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