ps auxw | grep postgres list the user and some time the process in execution --- On Thu, 7/3/08, Carol Walter <walterc@xxxxxxxxxxx> wrote: > From: Carol Walter <walterc@xxxxxxxxxxx> > Subject: [ADMIN] Who's attached to the database? > To: pgsql-admin@xxxxxxxxxxxxxx > Date: Thursday, July 3, 2008, 7:45 PM > Hi, Guys, > > 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? > > Carol > > -- > Sent via pgsql-admin mailing list > (pgsql-admin@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin
