Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 871ED650E9E
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu,  3 Jul 2008 19:04:22 -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 64199-06 for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu,  3 Jul 2008 19:04:12 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99])
	by postgresql.org (Postfix) with ESMTP id 13C80650E99
	for <pgsql-admin@postgresql.org>; Thu,  3 Jul 2008 19:04:15 -0300 (ADT)
Received: from Courts-MTA by gwmta.wicourts.gov
	with Novell_GroupWise; Thu, 03 Jul 2008 17:04:14 -0500
Message-Id: <486D069F.EE98.0025.0@wicourts.gov>
X-Mailer: Novell GroupWise Internet Agent 7.0.3 
Date: Thu, 03 Jul 2008 17:04:11 -0500
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Carol Walter" <walterc@indiana.edu>,
	"Bricklen Anderson" <banderson@presinet.com>
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>
	<486D41EA.1010606@presinet.com>
In-Reply-To: <486D41EA.1010606@presinet.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200807/57
X-Sequence-Number: 29667

>>> Bricklen Anderson <banderson@presinet.com> wrote:
 
>> Is there a command to disconnect this user?
> 
> select pg_cancel_backend(<procpid of connection>);
 
I thought that just canceled the currently active statement (if any). 
Don't you need to use pg_ctl kill (or the OS kill command) to actually
close the connection?
 
http://www.postgresql.org/docs/8.3/interactive/functions-admin.html
 
http://www.postgresql.org/docs/8.3/interactive/app-pg-ctl.html
 
-Kevin