Postgres Pro
Downloads
Home   >   mailing lists

Re: Find the Person Connected to a Database - Mailing list pgsql-admin

From Milen A. Radev
Subject Re: Find the Person Connected to a Database
Date
Msg-id fftpbr$pi5$1@ger.gmane.org
Whole thread Raw
In response to Find the Person Connected to a Database  (Naomi Walker <nwalker@mhs.mphasis.com>)
Responses Re: Find the Person Connected to a Database  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
Naomi Walker написа:
> I'm trying to drop a database in a postgres 8.1.4 instance (x86 Solaris
> 10 OS),  but someone is connected to
> the database.  What is the best way to find out exactly who is connected?
>

select * from pg_stat_activity where datname = <the_db_about_to_be_dropped>;

More here -
http://www.postgresql.org/docs/8.1/static/monitoring-stats.html#MONITORING-STATS-VIEWS.


--
Milen A. Radev

pgsql-admin by date:

Previous
From: Naomi Walker
Date:
Subject: Find the Person Connected to a Database
Next
From: Naomi Walker
Date:
Subject: Find who is connected to a database