[Pgpool-general] connection_life_time doesn't seem to work

[Richard Yen]

Hi All,

I think I might be confused as to how connection_life_time works.  It  
seems like the connections never get closed.

I have set connection_life_time to 30 (which, as I understand it, is  
30 seconds)

I have num_init_children=2 and max_pool=10

I have 4 open terminals, and when I use Terminal1 and Terminal2 to  
open psql connections through pgpool, the psql command prompt shows  
up.  When I do the same for Terminal3 and Terminal4, they just sit,  
waiting for Terminal1 or Terminal2 to close its connection.

I can wait forever, and nothing happens.  When I go to Terminal1 and  
Terminal2 and type "\q", their shells close, and Terminal3 and  
Terminal4 finish connecting, and psql cammand prompts show up.

Isn't it supposed to be the case that with connection_life_time=30,  
if Terminal1 or Terminal2 is idle for 30 seconds, they'll close, and  
then Terminal3 and Terminal4 can proceed with their connections?

Maybe I'm doing something else wrong?

Any help would be greatly appreciated!!!
--Richard