From: | "Lee Harr" <missive(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: force drop of database others are accessing |
Date: | 2004-01-24 13:29:59 |
Message-ID: | BAY2-F158FImY7zOC2u000363f8@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>>So that means somehow I need to kick off another
>>script with elevated priveleges to take care of it ...
>>
>>I would rather not have to do that, but I do not see another way.
>
>If you are creating a database from scratch why not create a brand new
>database and drop the old one at some later point in time when no one is
>connected. This has the additional benefit of the old db being available
>while the new one is being built.
That is a great idea.
No one is around to access the old one in the middle of the night,
but at least the new db will be built and I can just rename it next
morning if the old one had any connections blocking the process.
Thank you!
_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
From | Date | Subject | |
---|---|---|---|
Next Message | Marco Lazzeri | 2004-01-24 14:07:43 | Re: If table A value IS NULL then table B |
Previous Message | Nigel J. Andrews | 2004-01-24 12:27:03 | Re: sequence in schema -- broken default |