Home > mailing lists

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

From	Andrus
Subject	How to recover data from cluster
Date	February 16, 2012 18:19:10
Msg-id	FE768921244640309D53E9EDCA9D90F5@dell2 Whole thread Raw
Responses	Re: How to recover data from cluster Re: How to recover data from cluster
List	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.

From: John R Pierce
Date: 16 February 2012, 15:55:30
Subject: Re: Unable to execute \copy from Client Application

From: Adrian Klaver
Date: 16 February 2012, 18:25:12
Subject: Re: How to recover data from cluster