Re: recovering windows database after crash

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: Judicaël Dehotin <dehotin(at)lyon(dot)cemagref(dot)fr>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: recovering windows database after crash
Date: 2005-11-15 18:24:02
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE92E85B@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 should pick it up automatically.

//Magnus

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michelle Konzack 2005-11-15 18:38:06 Re: 3 x PostgreSQL in cluster/redunant
Previous Message Bruce Momjian 2005-11-15 18:19:23 Re: Number of items in a cursor...