Re: recovering windows database after crash - Mailing list pgsql-general

From Magnus Hagander
Subject Re: recovering windows database after crash
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE92E85B@algol.sollentuna.se
Whole thread Raw
In response to recovering windows database after crash  (Judicaël Dehotin <dehotin@lyon.cemagref.fr>)
Responses Re: recovering windows database after crash
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Number of items in a cursor...
Next
From: Michelle Konzack
Date:
Subject: Re: 3 x PostgreSQL in cluster/redunant