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

Re: destroying db / closing access

From: "S(dot)A(dot)Pamungkas" <moenk_2000(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: destroying db / closing access
Date: 2000-08-31 01:54:14
Message-ID: 20000831015414.8527.qmail@web4903.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
Thank you.
Yes, you right. Now, my "lecture" database droped.

-pamungkas-


--- Ryan Williams <shrewsbury(at)louisiana(dot)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(at)yahoo(dot)com>
> To: <pgsql-novice(at)postgresql(dot)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(at)louisiana(dot)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(at)yahoo(dot)com>
> > > To: <pgsql-novice(at)postgresql(dot)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/

pgsql-novice by date

Next:From: Johannes PretoriusDate: 2000-08-31 06:00:17
Subject: Seek for cygwin1.dll to run postgreSQL on WinNT workstation
Previous:From: ghaverlaDate: 2000-08-30 23:23:14
Subject: Re: 7.0.2 regressions testing on Sparc running 2.5.1

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