On Tue, Jan 18, 2005 at 10:29:32PM -0700, Pradeepkumar, Pyatalo (IE10) wrote:
> dropdb: database removal failed: ERROR: database "eps_db" is being accessed
> by other users
> But there are no other users accessing the database.
How do you know that? What does the following query show?
SELECT * FROM pg_stat_activity;
> Is there an option to forcefully delete the database even if other
> users are accessing it.
It might be better to find out who's using the database and why
before dropping it.
In response to
pgsql-novice by date
|Next:||From: sudheer raghav||Date: 2005-01-19 06:34:32|
|Subject: hoe to connect postgres database thru perl|
|Previous:||From: K Anderson||Date: 2005-01-19 06:01:05|
|Subject: Re: generating dynamic queries using pl/pgsql|