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

From Alan Hodgson
Subject Re: How to recover data from cluster
Date
Msg-id 17274925.tATkA7xNlO@skynet.simkin.ca
Whole thread Raw
In response to How to recover data from cluster  ("Andrus" <kobruleht2@hot.ee>)
Responses Re: How to recover data from cluster
List pgsql-general
On Thursday, February 16, 2012 09:18:34 PM 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.
>
> 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.
>
> How to fix this so old data is accessible ?
>

It sounds like your new installation is not in fact using the old data
directory, but a new empty one.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to recover data from cluster
Next
From: Adrian Klaver
Date:
Subject: Re: How to recover data from cluster