Terminating Idle Connections
am 10.05.2006 01:29:24 von Chris Hoover------=_Part_56926_21810099.1147217364249
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
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 b=
e
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
------=_Part_56926_21810099.1147217364249
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Is there a way inside of Postgresql to automatically terminate idle connect=
ions? I would like to terminate any connection to my database that ha=
s not has any activity for a specified period of time. I would like t=
o be able to do this despite the state of the connection (the majority of m=
y truly idle connections show "idle in transaction" in the proces=
s 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 scr=
ipt?
If this is not possible, would there be a possibility of it being a=
dded to a future version?
thanks,
Chris
RH 4.0 AS
P=
ostgreSQL 8.1.3
------=_Part_56926_21810099.1147217364249--