Re: I want to find out who is using a database

From: Shoaib Mir <shoaibmir(at)gmail(dot)com>
To: Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: I want to find out who is using a database
Date: 2010-11-10 02:26:21
Message-ID: AANLkTim9YFOX0Q7hT1yE=+hdz3LhNdmjt9pYaTpYi2mY@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Nov 10, 2010 at 1:17 PM, Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu> wrote:

>
> Can somebody please tell me how I find who it is using the
> xxxxx database?
>
>
select * from pg_stat_activity where datname = '<yourdbname>';

--
Shoaib Mir
http://shoaibmir.wordpress.com/

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tena Sakai 2010-11-10 02:31:48 Re: I want to find out who is using a database
Previous Message Samuel Stearns 2010-11-10 02:25:42 Re: I want to find out who is using a database