[Pgpool-general] patch for pgpool 2.6.5 to limit the lifetime of a connection

[Pomarede Nicolas]

On Tue, 3 Jan 2006, Tatsuo Ishii wrote:

> Thanks, your patches seem very usefull. I have merged your patches
> into pgpool 2.7, which was released today. I have made small changes
> to your patches however:
>
> 1) I prefer "child_max_connections" instead of "child_max_requests"
>   since your patches actually limits the number of connection times
>   from frontend, rather than number of query requests.

Yes, it's true that the name could be misleading, because I counted the 
global number of connections, not taking into account on which slot of the 
child it was used.
Perhaps there could be a more precise parameter that would count
the actual database user/password used to connect, to close only a 
given connection instead of killing the complete child ?
But for now, I think it's enough to restart the child.

>
> 2) I changed the place where the connection counter is counted up,
>   since the original place might be counted up mistakenly by
>   an signal interruption while waiting the connection request from
>   frontend.

I suspected there could be some internal cases you would be more aware of 
than me :)

Thanks for merging it, this will be easier to install debian/rpm packages 
than having to patch the source on each new realease.

Regards,


----------------
Nicolas Pomarede                   e-mail:   npomarede at corp.free.fr

"In a world without walls and fences, who needs windows and gates ?"