On 10/26/07, Naomi Walker <nwalker@xxxxxxxxxxxxxxx> wrote: > 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; ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend