Re: How to recover data from cluster

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