Re: destroying db / closing access

Thank you.
Yes, you right. Now, my "lecture" database droped.

-pamungkas-


--- Ryan Williams <shrewsbury@louisiana.com> wrote:
> I'm not sure what you're saying, but short of
> restarting the server I'm not
> sure of any way to close other users' open
> connections (but again, I'm not
> sure).
>
> If you want to drop the db from pgsql, you need to
> connect to another db
> then the one you want to drop.  For example, run
> 'pgsql template1' to
> connect to the 'template1' db, then issue your drop
> database statement.
>
> Does this help, or am I missing the point?
>
> ----- Original Message -----
> From: "S.A.Pamungkas" <moenk_2000@yahoo.com>
> To: <pgsql-novice@postgresql.org>
> Sent: Tuesday, August 29, 2000 7:13 PM
> Subject: Re: [NOVICE] destroying db / closing access
>
>
> > I'm not sure, but maybe no.
> > I connected that from program application.
> >
> > -pamungkas-
> >
> > --- Ryan Williams <shrewsbury@louisiana.com>
> wrote:
> > > 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/
> > >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Mail - Free email you can access from
> anywhere!
> > http://mail.yahoo.com/
>


__________________________________________________
Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/