On Fri, May 29, 2009 at 10:18 AM, Y W <luckyas...@gmail.com> wrote: > Are you referring to connection settings ? Coz if u do, the closet thing I > can find for the tcp_keepalive_timeout u're mentioning are the > tcp_keepalives_idle, tcp_keepalives_interval, and the tcp_keepalives_count. > And apart from the fact that they're ignored for unix-socket connetions, > these are for terminating the client connection from the client side and not > from the server side.
Yes those are what I'm referring to, and they apply to the server side as well. They only terminate DEAD connections. I.e. the client dies, and x seconds later the connection is closed on the server and the backend terminated. > Otherwise I don't know what are you refering to. I > want to be able to terminate idle connections from the server side, if there > was a tcp failure with that client which resulted in an unfinished > transaction and a locked resource, how can u do that ? tcp keepalive does that. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
