Re: How to recovery data from folder data installation?

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Orlando Solarte <registro_orsolarte(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to recovery data from folder data installation?
Date: 2008-04-16 02:01:31
Message-ID: 48055DFB.5030704@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message CG 2008-04-16 04:16:38 Need help to clean up after failed CLUSTER
Previous Message Craig Ringer 2008-04-16 01:57:11 Re: util/int8.h: missing int8_text() function