Is it possible to recover the schema from the raw files? - Mailing list pgsql-general

From Tomas J Stehlik
Subject Is it possible to recover the schema from the raw files?
Date
Msg-id 000001d19d7d$7bf6f4f0$73e4ded0$@stehlik.co.uk
Whole thread Raw
Responses Re: Is it possible to recover the schema from the raw files?
List pgsql-general
Hello,

There was a corruption to the file system due to sudden shutdown of Windows
7.

The attempt to connect to one of the databases results in multiple errors,
like the following one:
ERROR:  invalid page in block 58 of relation base/161326/233745

Several raw files were completely lost (zeroed), thus utterly disabling the
functionality of this particural database.

The raw files were backed up separately outside of the original data folder
upon discovery of the issue.

I would like to ask whether it is possible to recover the database schema
from the raw files?
The data itself is less important in this case.

Thank you in advance for any insight into such a topic.

Kind regards,

Tomas



pgsql-general by date:

Previous
From: Manuel Gómez
Date:
Subject: Re: Proper relational database?
Next
From: Andrew Sullivan
Date:
Subject: Re: Proper relational database?