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