From: | Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu> |
---|---|
To: | Samuel Stearns <SStearns(at)internode(dot)com(dot)au>, "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:31:48 |
Message-ID: | C8FF436C.D070%tsakai@gallo.ucsf.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thank you, Sam.
Tena
On 11/9/10 6:25 PM, "Samuel Stearns" <SStearns(at)internode(dot)com(dot)au> wrote:
Psql template1
Select * from pg_stat_activity;
Sam
From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Tena Sakai
Sent: Wednesday, 10 November 2010 12:48 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] 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(at)gallo(dot)ucsf(dot)edu
From | Date | Subject | |
---|---|---|---|
Next Message | Tena Sakai | 2010-11-10 02:32:28 | Re: I want to find out who is using a database |
Previous Message | Shoaib Mir | 2010-11-10 02:26:21 | Re: I want to find out who is using a database |