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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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