X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 03D729FA159 for ; Tue, 9 May 2006 20:30:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 71808-07 for ; Tue, 9 May 2006 20:29:55 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0102.google.com (wx-out-0102.google.com [66.249.82.204]) by postgresql.org (Postfix) with ESMTP id B03689F9DCD for ; Tue, 9 May 2006 20:29:55 -0300 (ADT) Received: by wx-out-0102.google.com with SMTP id s13so1183995wxc for ; Tue, 09 May 2006 16:29:54 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=OKGepJ9YadnypjTwW3uxmu/4b1uQnbEJppLpFjO1YBOQhHLU5PqntN7LQO3KPeTnsZ1drsYowHZkdfDjzb29IesXFKeduDYHQX7RrbqiTBQArxcJ+RTbJmDJvt1Rm1TzHNTtucudcwop6RSCgK3X4trMkR6k1Bj8rHRaLjRNrB8= Received: by 10.70.44.20 with SMTP id r20mr4665898wxr; Tue, 09 May 2006 16:29:54 -0700 (PDT) Received: by 10.70.80.16 with HTTP; Tue, 9 May 2006 16:29:54 -0700 (PDT) Message-ID: <1d219a6f0605091629g5651582cxe7e5eeddcc75f765@mail.gmail.com> Date: Tue, 9 May 2006 19:29:54 -0400 From: "Chris Hoover" To: "pgsql-admin@postgresql.org" Subject: Terminating Idle Connections MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_56942_29307712.1147217394721" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/90 X-Sequence-Number: 21622 ------=_Part_56942_29307712.1147217394721 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_56942_29307712.1147217394721 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 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 a= dded to a future version?

thanks,

Chris

RH 4.0 AS
P= ostgreSQL 8.1.3 ------=_Part_56942_29307712.1147217394721--