How to recover data from cluster

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How to recover data from cluster
Date: 2012-02-16 19:18:34
Message-ID: FE768921244640309D53E9EDCA9D90F5@dell2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ?

Andrus.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jack Christensen 2012-02-16 19:19:16 Set returning functions in select column list
Previous Message John R Pierce 2012-02-16 16:55:04 Re: Unable to execute \copy from Client Application