Re: How to recovery data from folder data installation?

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Cc: Orlando Solarte <registro_orsolarte(at)hotmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: How to recovery data from folder data installation?
Date: 2008-04-16 07:25:45
Message-ID: 20080416092545.42ca4ad4@mha-laptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Craig Ringer wrote:
> 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.

What you mean here is of course that you should be using the same
*major* version, but the latest available *minor* version.

Other than that, it's correct - and the version numbers in the example
is correct :-)

//Magnus

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shane Ambler 2008-04-16 09:09:23 Re: Not Geography
Previous Message Richard Huxton 2008-04-16 06:31:50 Re: I need to ecrypt one column to an output file