Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id D9211633F70 for ; Mon, 12 Apr 2010 10:27:01 -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 13773-05 for ; Mon, 12 Apr 2010 13:26:42 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-pw0-f46.google.com (mail-pw0-f46.google.com [209.85.160.46]) by mail.postgresql.org (Postfix) with ESMTP id E0216632757 for ; Mon, 12 Apr 2010 10:26:50 -0300 (ADT) Received: by pwj9 with SMTP id 9so4287471pwj.19 for ; Mon, 12 Apr 2010 06:26:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:subject:mime-version :content-type:from:x-priority:in-reply-to:date:cc:message-id :references:to:x-mailer; bh=fZGVbFISY8F4fsncJBBkOMCYEBQi5AlL4v4MkqWoGJs=; b=tIznqDt+RGH+IpWddDuws+XEejjHy1kjRNyldmWbLY+8UbX2qHU4WHwtpvTbB2i3qU f7WlfqvmDZ2T2l5vqlZu1uWn5fSeDkJpxNI/8ARYXwTevC1j5c8R/YxXomtGasczIUE2 P1R2dmk4t1HZiPhCm+YJALAHMoZWrfJxAvWls= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=subject:mime-version:content-type:from:x-priority:in-reply-to:date :cc:message-id:references:to:x-mailer; b=eKFToE3uCQHla/6kZgy7IFLAGux+8b/isVTOCm6SPUvQD3PL/jEf0bPocb7kf1wsAe h+kyo+FLQNo3cH3gh76eAou6KTSOYt5rJsSnsylwpc+90rinQramLHWa4yXTJsi/BeJ7 fgbOjrgf8EQKLq5mdJTGoRBoipgSgHL82V2tM= Received: by 10.115.39.39 with SMTP id r39mr3179178waj.157.1271078809075; Mon, 12 Apr 2010 06:26:49 -0700 (PDT) Received: from [192.168.23.131] ([121.241.184.130]) by mx.google.com with ESMTPS id 21sm4070937pzk.0.2010.04.12.06.26.46 (version=TLSv1/SSLv3 cipher=RC4-MD5); Mon, 12 Apr 2010 06:26:48 -0700 (PDT) Subject: Re: how to disconnect users Mime-Version: 1.0 (Apple Message framework v1078) Content-Type: multipart/alternative; boundary=Apple-Mail-6-713827209 From: Vibhor Kumar X-Priority: 3 In-Reply-To: Date: Mon, 12 Apr 2010 18:56:43 +0530 Cc: Message-Id: <0E59D630-3944-4245-89C6-DAD23A149479@gmail.com> References: <1A57E5A7-AEB8-412B-B3A7-D52768F2FCF7@geysirit.dk> <4BBDA7AC0200002500030589@gw.wicourts.gov> To: =?iso-8859-1?Q?Eduardo_S=E1_dos_Reis?= X-Mailer: Apple Mail (2.1078) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.298 tagged_above=-10 required=5 tests=AWL=-1.299, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201004/139 X-Sequence-Number: 34233 --Apple-Mail-6-713827209 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=iso-8859-1 On 12-Apr-2010, at 6:00 PM, Eduardo S=E1 dos Reis wrote: > I need to disconnect user in my database without creating = inconsistencies. What command should I use. >=20 > Grateful > =20 > Eduardo Which Version of PostgreSQL are you using? In PostgreSQL 8.4, you can use pg_terminate_backend() function. Thanks & Regards, Vibhor Kumar (PCP & OCP) ITIL V3 Cerftified. Mob: +91-9011042623 Web:www.EnterpriseDB.com --Apple-Mail-6-713827209 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=iso-8859-1

On 12-Apr-2010, at 6:00 PM, = Eduardo S=E1 dos Reis wrote:

I need to = disconnect user in my database without creating inconsistencies. What command = should I use.

 
Eduardo

Which Version of PostgreSQL are you = using?

In PostgreSQL 8.4, you can use = pg_terminate_backend() function.

Thanks & = Regards,
Vibhor Kumar (PCP & OCP)
ITIL V3 = Cerftified.
Mob: = +91-9011042623
Web:www.EnterpriseDB.com

= --Apple-Mail-6-713827209--