Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 9AC52632B9E for ; Mon, 19 Apr 2010 12:52:43 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 30884-04 for ; Mon, 19 Apr 2010 15:52:33 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ww0-f46.google.com (mail-ww0-f46.google.com [74.125.82.46]) by mail.postgresql.org (Postfix) with ESMTP id EF906632A26 for ; Mon, 19 Apr 2010 12:52:32 -0300 (ADT) Received: by wwb24 with SMTP id 24so2638520wwb.19 for ; Mon, 19 Apr 2010 08:52:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :from:date:received:message-id:subject:to:cc:content-type; bh=rotCyo/+6GvxVkjkel0LpfxzCpO6RX9Gv+B6Oys8Eog=; b=I2Fv5QPr7Z0symQjQEzaA5W34FAuLOJYNQD77fBSknyu1gxR92Bi/dP3ugyr488Dtz lraaaLUQyeV/cjM9UPnFtx+PDjAHsbBPbP5YRcLL72Vn7+2RQTAyv24NsF2TiudFRAIg boSuVk9k0CKoyvcphkX3ioNLJrZ65jgQ3dK+o= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type; b=whEWrrTIoHmNAM2buHSlT5jun13trlzhqJM/T9h1vUt7sNt+7NtEakTKixSOZ3U2CQ yEHe4+jE7ZCl3MC2lQenV0pihdVJkWJ1idEfSKWmFT4K/dFhA6UNTq4t4sfBnBMzOIjG fy90bee1Rs2NvJewOsGJylMkox6lGY71dXrg0= MIME-Version: 1.0 Received: by 10.216.233.205 with HTTP; Mon, 19 Apr 2010 08:52:10 -0700 (PDT) In-Reply-To: <480516.98593.qm@web28311.mail.ukl.yahoo.com> References: <480516.98593.qm@web28311.mail.ukl.yahoo.com> From: Sergey Konoplev Date: Mon, 19 Apr 2010 19:52:10 +0400 Received: by 10.216.178.207 with SMTP id f57mr5658918wem.88.1271692350319; Mon, 19 Apr 2010 08:52:30 -0700 (PDT) Message-ID: Subject: Re: How to disconnect a single user in Postgresql 8.2.5 from a database To: Steph L Cc: pgsql-admin@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001 X-Spam-Level: X-Archive-Number: 201004/258 X-Sequence-Number: 34352 On 19 April 2010 15:27, Steph L wrote: > > How to disconnect a single user in Postgresql 8.2.5 from a database ? AFAIK the only way is to upgrade to 8.4 and use pg_terminate_backend(): http://www.postgresql.org/docs/8.4/interactive/functions-admin.html -- Sergey Konoplev Blog: http://gray-hemp.blogspot.com / Linkedin: http://ru.linkedin.com/in/grayhemp / JID/GTalk: gray.ru@gmail.com / Skype: gray-hemp / ICQ: 29353802