Re: How to recover data from cluster - Mailing list pgsql-general

From Adrian Klaver
Subject Re: How to recover data from cluster
Date
Msg-id 4F3D5807.6080401@gmail.com
Whole thread Raw
In response to How to recover data from cluster  ("Andrus" <kobruleht2@hot.ee>)
List pgsql-general
On 02/16/2012 11:18 AM, Andrus wrote:
> PostgreSql 8.4 in windows crashes. After that Windows disk repairing was
> used to repair hard drive.
> After that Data/base directory from crashed server contains lot of
> files, all files are readable.

There is readable and there is not-corrupt :(

> PostgreSql 8.4 was reinstalled in new server and data directory was set
> to directory from crashed server.
> pgAdmin shows that there is only public schema without any tables.
> Actually there was two schemas with lot of tables.

What does the Postgres log show when you start the database and try to
access the tables?

> How to fix this so old data is accessible ?
> Andrus.


--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: How to recover data from cluster
Next
From: Alan Hodgson
Date:
Subject: Re: How to recover data from cluster