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

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