Thread: Terminating Idle Connections

Is there a way inside of Postgresql to automatically terminate idle connections?  I would like to terminate any connection to my database that has not has any activity for a specified period of time.  I would like to be able to do this despite the state of the connection (the majority of my truly idle connections show "idle in transaction" in the process table).  I would love for the db engine to do this, but if it can't, is there an easy way to do this outside the database with some sort of script?

If this is not possible, would there be a possibility of it being added to a future version?

thanks,

Chris

RH 4.0 AS
PostgreSQL 8.1.3

Tue, May 09, 2006 at 07:29:24PM -0400, Chris Hoover napsal(a):
> Is there a way inside of Postgresql to automatically terminate idle
> connections?  I would like to terminate any connection to my database that

Your question isn't ODBC related. Please try another mailing list like
pgsql-admin.

Regards,

Luf