Re: Who's attached to the database? - Mailing list pgsql-admin

From Tom Lane
Subject Re: Who's attached to the database?
Date
Msg-id 6657.1215114865@sss.pgh.pa.us
Whole thread Raw
In response to Who's attached to the database?  (Carol Walter <walterc@indiana.edu>)
List pgsql-admin
Carol Walter <walterc@indiana.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

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Who's attached to the database?
Next
From: Jeff Frost
Date:
Subject: Re: Who's attached to the database?