From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Tena Sakai Sent: Wednesday, 10 November 2010 12:48 PM To: pgsql-admin@postgresql.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?