Carol Walter <walterc(at)indiana(dot)edu> writes:
> I'm trying to drop a database and I'm getting an error that says that
> the database is being accessed by other users. Is there a way I can
> find out who these users are or if there really is a user accessing it?
pg_stat_activity ... or if you turned that off, "ps auxww | grep postgres"
(or local equivalent) might help.
regards, tom lane