Skip site navigation (1) Skip section navigation (2)

Re: dropdb command not working.

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: (view raw, whole thread or download thread mbox)
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

In response to

pgsql-novice by date

Next:From: sudheer raghavDate: 2005-01-19 06:34:32
Subject: hoe to connect postgres database thru perl
Previous:From: K AndersonDate: 2005-01-19 06:01:05
Subject: Re: generating dynamic queries using pl/pgsql

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group