Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 64470650E8A
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu,  3 Jul 2008 18:34:43 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 41667-08 for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu,  3 Jul 2008 18:34:33 -0300 (ADT)
X-Greylist: delayed 00:12:27.591064 by SQLgrey-1.7.6
Received: from presinet.com (mail.presinet.com [209.53.156.1])
	by postgresql.org (Postfix) with ESMTP id F334664FD64
	for <pgsql-admin@postgresql.org>; Thu,  3 Jul 2008 18:34:35 -0300 (ADT)
Received: from [10.10.1.151] ([10.10.1.151]) by presinet.com with Microsoft
	SMTPSVC(6.0.3790.1830); Thu, 3 Jul 2008 14:23:13 -0700
Message-ID: <486D41EA.1010606@presinet.com>
Date: Thu, 03 Jul 2008 14:17:30 -0700
From: Bricklen Anderson <banderson@presinet.com>
User-Agent: Thunderbird 2.0.0.14 (X11/20080502)
MIME-Version: 1.0
To: Carol Walter <walterc@indiana.edu>
CC: pgsql-admin@postgresql.org
Subject: Re: Who's attached to the database?
References: <9CB3C6A7-9E59-4A40-94BB-C2EE4150EC21@indiana.edu>
	<486CE819.EE98.0025.0@wicourts.gov>
	<DCE58E12-256E-4707-A8E8-3B33FB286D09@indiana.edu>
In-Reply-To: <DCE58E12-256E-4707-A8E8-3B33FB286D09@indiana.edu>
Content-Type: text/plain; charset=US-ASCII; format=flowed
Content-Transfer-Encoding: 7bit
X-OriginalArrivalTime: 03 Jul 2008 21:23:13.0328 (UTC)
	FILETIME=[00124300:01C8DD53]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200807/56
X-Sequence-Number: 29666

Carol Walter wrote:
> Thanks, guys,
> 
> This told me that the user that has it open is the interface user called 
> db_user.  Is there a command to disconnect this user?
> 
> Carol

select pg_cancel_backend(<procpid of connection>);