Thank you, Sam. Tena
On 11/9/10 6:25 PM, "Samuel Stearns" <[email protected]> wrote: Psql template1 Select * from pg_stat_activity; Sam From: [email protected] [mailto:[email protected]] On Behalf Of Tena Sakai Sent: Wednesday, 10 November 2010 12:48 PM To: [email protected] 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 [email protected]
