Tena
On 11/9/10 6:25 PM, "Samuel Stearns" <SStearns@xxxxxxxxxxxxxxxx> wrote:
Psql template1
Select * from pg_stat_activity;
Sam
From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Tena Sakai
Sent: Wednesday, 10 November 2010 12:48 PM
To: pgsql-admin@xxxxxxxxxxxxxx
Subject: I want to find out who is using a database
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@xxxxxxxxxxxxxx
