try this select pg_cancel_backend(<processid_db>); if the command not work kill the process in os kill -9 proccessid_os --- On Thu, 7/3/08, Carol Walter <walterc@xxxxxxxxxxx> wrote: > From: Carol Walter <walterc@xxxxxxxxxxx> > Subject: Re: [ADMIN] Who's attached to the database? > To: "Kevin Grittner" <Kevin.Grittner@xxxxxxxxxxxx> > Cc: pgsql-admin@xxxxxxxxxxxxxx > Date: Thursday, July 3, 2008, 8:07 PM > Thanks, guys, > > This told me that the user that has it open is the > interface user > called db_user. Is there a command to disconnect this > user? > > Carol > > On Jul 3, 2008, at 3:53 PM, Kevin Grittner wrote: > > >>>> Carol Walter <walterc@xxxxxxxxxxx> > wrote: > >> 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? > > > > select * from pg_stat_activity where datname = > 'yourdb'; > > > > -Kevin > > > -- > Sent via pgsql-admin mailing list > (pgsql-admin@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin
