Skip site navigation (1) Skip section navigation (2)

Re: Who's attached to the database?

From: Bricklen Anderson <banderson(at)presinet(dot)com>
To: Carol Walter <walterc(at)indiana(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Who's attached to the database?
Date: 2008-07-03 21:17:30
Message-ID: 486D41EA.1010606@presinet.com (view raw or flat)
Thread:
Lists: pgsql-admin
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>);

In response to

Responses

pgsql-admin by date

Next:From: Carol WalterDate: 2008-07-03 21:23:50
Subject: Re: Who's attached to the database?
Previous:From: Carol WalterDate: 2008-07-03 20:07:23
Subject: Re: Who's attached to the database?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group