Re: recovering windows database after crash

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: recovering windows database after crash
Дата
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE92E85B@algol.sollentuna.se
обсуждение исходный текст
Ответ на recovering windows database after crash  (Judicaël Dehotin <dehotin@lyon.cemagref.fr>)
Ответы Re: recovering windows database after crash  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-general
> Hello,
>
> I have postgresql 8.0 under windows, with pgadmin 3
> Unfortunaly i have met a problem with postgresql which
> obliged me to reinstall  postgresql.  The bad thing is i have
> no backup of my database before the crash (shame on me !!  ;-))  )
>
> So i wonder if it is possible, with the  folder of
> /postgreql/data/8.0/data/base  which seem contain already the
> directories of my database , to recover it ?

Assuming yo uhave all the files, sure. Just run the installer again (make sure you use the same version you had
before!!),set the data directory to the same you had before, and make sure th einstaller is set *not* to run initdb. It
shouldpick it up automatically. 

//Magnus

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Number of items in a cursor...
Следующее
От: Michelle Konzack
Дата:
Сообщение: Re: 3 x PostgreSQL in cluster/redunant