Re: How to recovery data from folder data installation? - Mailing list pgsql-general

From Craig Ringer
Subject Re: How to recovery data from folder data installation?
Date
Msg-id 48055DFB.5030704@postnewspapers.com.au
Whole thread Raw
In response to How to recovery data from folder data installation?  (Orlando Solarte <registro_orsolarte@hotmail.com>)
Responses Re: How to recovery data from folder data installation?  (Magnus Hagander <magnus@hagander.net>)
List pgsql-general
Orlando Solarte wrote:
> Hi.
>
> I am trouble with my server postres on linux. It crashed!. I have folder
> postgres installation that was my server. Is possible recovery data from
> folder postgres installation? For example folder data?

Unfortunately you have provided very little information.

If you mean that the PostgreSQL database server crashed and will no
longer start up, then you would need to provide the messages PostgreSQL
prints to its log files when it tries and fails to start up.

If you mean that the server computer its self crashed, and you now have
a PostgreSQL data directory (from backups or recovered from the server's
 hard disk) then if the PostgreSQL data directory is undamaged it should
be possible to use it. You will need to use it with a version of
PostgreSQL with the same minor version as the one you were using on the
server, eg if you were using 8.1.4 you should get the latest PostgreSQL
in the 8.1 series (NOT 8.2 or 8.3) to try to read the data.

Make a copy first.

--
Craig Ringer

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: util/int8.h: missing int8_text() function
Next
From: Stefan Schwarzer
Date:
Subject: Re: Installation of contrib/tablefunc - problems