Skip site navigation (1) Skip section navigation (2)

Terminating Idle Connections

From: "Chris Hoover" <revoohc(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Terminating Idle Connections
Date: 2006-05-09 23:29:24
Message-ID: 1d219a6f0605091629o22f8bd34i477390d1ea8b73bd@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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

Responses

pgsql-odbc by date

Next:From: AndreasDate: 2006-05-10 01:42:18
Subject: Re: Pocket PC
Previous:From: noreplyDate: 2006-05-09 14:18:39
Subject: [ psqlodbc-Bugs-1000639 ] Connect PostgreSQL to Oracle 10g through ODBC: can't read all_tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group