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

From Tomas J Stehlik
Subject Re: Is it possible to recover the schema from the raw files?
Date
Msg-id 003701d19e43$5b836430$128a2c90$@stehlik.co.uk
Whole thread Raw
In response to Re: Is it possible to recover the schema from the raw files?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Is it possible to recover the schema from the raw files?
Re: Is it possible to recover the schema from the raw files?
List pgsql-general
Hello Andrian,

Thank you

> Have you even tried a schema only dump from the original instance?

That's an odd question. However, I understand that maybe a lot of beginners
come onto this mailing list.

To the contrary, this is a non-trivial situation.

You can safely assume that I wrote the original request because all the
other approaches failed to bring a result. Everything has already been tried
and tested.

The only question remains the one in the subject line.


> If the information is not there, it is not there. In other words if the
 > zeroed out blocks you alluded to cover the system information then I am
 > not sure how it would be possible to recover information from 0?

This is an incorrect assumption.
Most of the information is available.
Just the PostgreSQL server can't work with it [because of the missing bits].


Kind regards,

Tomas



pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: Is it possible to recover the schema from the raw files?
Next
From: Karsten Hilbert
Date:
Subject: Re: Is it possible to recover the schema from the raw files?