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: [email protected] > 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 > ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
