"Milen A. Radev" <milen(at)radev(dot)net> writes:
> 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>;
If that doesn't work because you've got stats collection turned off,
"ps" will help too:
http://www.postgresql.org/docs/8.1/static/monitoring.html
On Solaris, note the Tip at the bottom (not sure if it applies to recent
Solaris versions but a few years ago it was critical).
regards, tom lane