I want to find out who is using a database

From: Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: I want to find out who is using a database
Date: 2010-11-10 02:17:48
Message-ID: C8FF4024.D06A%tsakai@gallo.ucsf.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Everybody,

I want to drop a database and recreate it from a backup file.
But when I issue a dropdb command it wouldn’t let me do
so. It tells me: database xxxxx is being accessed by other
users.

Can somebody please tell me how I find who it is using the
xxxxx database?

Thank you.

Regards,

Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Samuel Stearns 2010-11-10 02:25:42 Re: I want to find out who is using a database
Previous Message Isabella Ghiurea 2010-11-09 22:12:56 PG HA solution using DBRD