Re: Two novice questions - Mailing list pgsql-novice

From Mike Castle
Subject Re: Two novice questions
Date
Msg-id 20010114180733.D3604@thune.yy.com
Whole thread Raw
In response to Two novice questions  (Jonathan Chum <jchum@techdevelopers.com>)
List pgsql-novice
On Sun, Jan 14, 2001 at 03:40:56AM -0500, Jonathan Chum wrote:
> PostgreSQL said: ERROR: DROP DATABASE: Database "blazeboard" is being
> accessed by other users
>
> I'm sure no one else is accessing it because I'm the only one who knows
> that the database exists and ps doesn't show any other users connecting to it.

1)  Try using the dropdb script if you're not.
2)  Connect to the database template1 and then do the drop, not to the
database you're trying to connect to (that's what the drobdb script does).
--
       Mike Castle       Life is like a clock:  You can work constantly
  dalgoda@ix.netcom.com  and be right all the time, or not work at all
www.netcom.com/~dalgoda/ and be right at least twice a day.  -- mrc
    We are all of us living in the shadow of Manhattan.  -- Watchmen

pgsql-novice by date:

Previous
From: Louis Bertrand
Date:
Subject: Re: Storing Graphic Files
Next
From: Tom Lane
Date:
Subject: Re: Two novice questions