Are you connected to the 'lecture' database with psql when you try to drop
it?
----- Original Message -----
From: "S.A.Pamungkas" <moenk_2000@yahoo.com>
To: <pgsql-novice@postgresql.org>
Sent: Monday, August 28, 2000 8:44 PM
Subject: [NOVICE] destroying db / closing access
> Hi all
>
> I use my own GUI to connect my database ( namely
> "lecture").
> But caused by memory problem, my machine going down.
>
> Rebooting my machine, then try to connect database
> againt ( "lecture"). But I couldn't connect my
> database.
>
> When I try to destroy my database from psql, by
> "dropdb lecture", there was a message like this :
> "ERROR: DROP DATABASE: Database "lecture" is being
> accessed by other users
> dropdb: database removal failed".
>
> How to close other user's access ?
>
> Thank you.
>
> -pamungkas-
>
>
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Mail - Free email you can access from anywhere!
> http://mail.yahoo.com/
