Re: Removing a corrupt database by hand

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Removing a corrupt database by hand
Дата
Msg-id 1235025315.32493.7.camel@jd-laptop.pragmaticzealot.org
обсуждение исходный текст
Ответ на Removing a corrupt database by hand  (Mike Christensen <imaudi@comcast.net>)
Ответы Re: Removing a corrupt database by hand  (Mike Christensen <imaudi@comcast.net>)
Re: Removing a corrupt database by hand  (Mike Christensen <imaudi@comcast.net>)
Список pgsql-general
On Wed, 2009-02-18 at 19:58 -0800, Mike Christensen wrote:
> I have two questions actually..
>
> First off, is there a way to remove a database if the postgres.exe
> service won't start?  It seems if I just delete the data\base\xxxxx
> directory, then postgres will crash.  Is there a way to drop a DB that
> prevents postgres.exe from starting?
>

What happens if you start postgresql in single user mode?

> Second question, if I just re-install postgres and create a fresh new
> instance, is there a way to import my old data files back into the
> database?  Thanks!
>
> Mike
>
--
PostgreSQL - XMPP: jdrake@jabber.postgresql.org
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997


В списке pgsql-general по дате отправления:

Предыдущее
От: Mike Christensen
Дата:
Сообщение: Removing a corrupt database by hand
Следующее
От: Yi Zhao
Дата:
Сообщение: how to do this select?