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

From: Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu>
To: Shoaib Mir <shoaibmir(at)gmail(dot)com>
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:32:28
Message-ID: C8FF4392.D072%tsakai@gallo.ucsf.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Thank you, Shoaib.

Tena

On 11/9/10 6:26 PM, "Shoaib Mir" <shoaibmir(at)gmail(dot)com> wrote:

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>';

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Khangelani Gama 2010-11-10 08:06:30 PostgreSQL Select command that will list only duplicate rows
Previous Message Tena Sakai 2010-11-10 02:31:48 Re: I want to find out who is using a database