| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | "Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar(dot)Pyatalo(at)honeywell(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: dropdb command not working. |
| Date: | 2005-01-19 06:02:18 |
| Message-ID: | 20050119060218.GA56927@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | sudheer raghav | 2005-01-19 06:34:32 | hoe to connect postgres database thru perl |
| Previous Message | K Anderson | 2005-01-19 06:01:05 | Re: generating dynamic queries using pl/pgsql |