On 2008-07-03, at 21:45, Carol Walter wrote:
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
select * from pg_stat_activity where datname='<database2drop>';
--
Pawel Socha
pawel.socha@xxxxxxxxx
perl -le 's**02).4^&-%2,).^9%4^!./4(%2^3,!#+7!2%^53%2&**y%& -;^[%"`-
{ a%%s%%$_%ee'
