[Pgpool-general] Disconnecting idle clients

Jim C. Nasby jim at nasby.net
Fri Jan 12 20:50:26 UTC 2007


On Fri, Jan 12, 2007 at 03:58:54PM +0100, Poul M?ller Hansen wrote:
> This is probably a FAQ question, but I haven't able to find the answer.
> 
> Using pgpool version 3.0.2-1 and PostgreSQL version 8.1.4-7 on Ubuntu 6.10
> I have tried these settings in pgpool.conf
> 
> num_init_children = 3
> max_pool = 1
> connection_life_time = 120
> 
> child_life_time = 300
> child_max_connections = 2
> 
> Now I'm making 4 client connections with psql. The 4. connection hangs 
> like expected,
> but it hangs forever.
> I would have expected the idle connections to be kicked off after 300 
> seconds giving
> access to the 4. client, or have I misunderstood the concept ?

Are any of the other clients even disconnecting from pgpool? AFAIK
pgpool will never terminate a client connection on its own.
-- 
Jim Nasby                                            jim at nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)


More information about the Pgpool-general mailing list