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

Re: Who's attached to the database?

From: Carol Walter <walterc(at)indiana(dot)edu>
To: Bricklen Anderson <banderson(at)presinet(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Who's attached to the database?
Date: 2008-07-03 21:23:50
Message-ID: FE60BC5A-49FB-4C50-B143-C37B89B5F090@indiana.edu (view raw or flat)
Thread:
Lists: pgsql-admin
Oh, thanks so much.  This is something I really needed.

Carol

On Jul 3, 2008, at 5:17 PM, Bricklen Anderson wrote:

> 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

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2008-07-03 22:04:11
Subject: Re: Who's attached to the database?
Previous:From: Bricklen AndersonDate: 2008-07-03 21:17:30
Subject: Re: Who's attached to the database?

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