Postgres Pro
Downloads
Home   >   mailing lists

Re: I want to find out who is using a database - Mailing list pgsql-admin

From Samuel Stearns
Subject Re: I want to find out who is using a database
Date
Msg-id 68B59BEDCD36854AADBDF17E91B2937A0783A72309@EXCHMAIL.staff.internode.com.au
Whole thread Raw
In response to I want to find out who is using a database  (Tena Sakai <tsakai@gallo.ucsf.edu>)
Responses Re: I want to find out who is using a database  (Tena Sakai <tsakai@gallo.ucsf.edu>)
List pgsql-admin
Tree view

Psql template1

 

Select * from pg_stat_activity;

 

Sam

 

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?

Thank you.

Regards,

Tena Sakai
tsakai@gallo.ucsf.edu

pgsql-admin by date:

Previous
From: Tena Sakai
Date:
Subject: I want to find out who is using a database
Next
From: Shoaib Mir
Date:
Subject: Re: I want to find out who is using a database