Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 3528B63265F for ; Mon, 19 Apr 2010 23:10:23 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 16590-06 for ; Tue, 20 Apr 2010 02:10:03 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 66FA96324A1 for ; Mon, 19 Apr 2010 23:10:12 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o3K2A9N0015824; Mon, 19 Apr 2010 22:10:10 -0400 (EDT) To: Josh Kupershmidt cc: Sergey Konoplev , Steph L , pgsql-admin@postgresql.org Subject: Re: How to disconnect a single user in Postgresql 8.2.5 from a database In-reply-to: References: <480516.98593.qm@web28311.mail.ukl.yahoo.com> Comments: In-reply-to Josh Kupershmidt message dated "Mon, 19 Apr 2010 21:24:40 -0400" Date: Mon, 19 Apr 2010 22:10:09 -0400 Message-ID: <15823.1271729409@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.165 tagged_above=-10 required=5 tests=AWL=-1.154, BAYES_20=-0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201004/265 X-Sequence-Number: 34359 Josh Kupershmidt writes: > pg_terminate_backend() is just a SQL wrapper around: > kill -SIGTERM [backend PID] > For versions before 8.4: if you can SSH in to the server, run the > above on the PID of the backend your user is connected to, and that > should terminate their connection. The reason the function isn't there before 8.4 is that that's not promised to work before 8.4 ... most of the time it will work, but once in awhile you could get nasty side-effects. regards, tom lane