Thread: 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/
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/
Hi! I struggled through compiling PostgreSQL, and tried it out, only to run across an insufficient shared memory problem. Above mentioned FAQ says, no problem, just edit /etc/system and insert the following: set shmsys:shminfo_shmmax=0x7fffffff Great! Wonderful! What the heck is my system running for shmsys:shminfo_shmmax now???? I try to look in the man pages, nothing. Hmmm, maybe answerbooks has it. CRASH! My system has had ongoing problems since Y2K patches were applied Dec31 with ToolTalk, and answerbooks won't run. Four days of pulling my hair out trying to remember/figure out how patches working for this fsck'ing Solaris system, and I get answerbooks running again. It does indeed have information on this shared memory thing. It tells me the default value is decimal 1,048,576, and since my /etc/system didn't have any statements overriding this, that is what I was presently running. So, what is 0x7fffffff?? 2,147,426,318 or a little more than twice as big. Could somebody please edit the FAQ and mention what the default is, and present these values as both hexadecimal and decimal? Gord Matter Realisations http://www.materialisations.com/ Gordon Haverland, B.Sc. M.Eng. President 101 9504 182 St. NW Edmonton, AB, CA T5T 3A7 780/481-8019 ghaverla @ freenet.edmonton.ab.ca
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/
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/