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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
