destroying db / closing connection

From: "S(dot)A(dot)Pamungkas" <moenk_2000(at)yahoo(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: destroying db / closing connection
Date: 2000-08-29 02:59:57
Message-ID: 20000829025957.26454.qmail@web4903.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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/

Browse pgsql-interfaces by date

  From Date Subject
Next Message Thomas Lockhart 2000-08-29 04:26:46 Re: JDBC support
Previous Message Tom Lane 2000-08-29 00:59:05 Re: Problem with ODBC in current CVS?