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 003901d19e44$142419d0$3c6c4d70$@stehlik.co.uk
Whole thread Raw
In response to Re: Is it possible to recover the schema from the raw files?  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
Hello Karsten,

Thank you.

> Like replacing (some of) the pg_* containing raw files with
 > those from an uncorrupted database (having been suggested
 > earlier this year) which may work if the corrupted blocks in
 > pg_* only affect data actually describing _that_ database
 > rather than establishing relationships not unique to this
 > database (say, encodings, default operators, ...). If those
 > can be replaced and there is still corruption in some parts
 > describing the local schema then it may work to apply
 > zero_damaged_pages, pg_resetxlog, and similar tools in order
 > to make some of the schema dumpable.

This is actually a very interesting idea.

Kind regards,

Tomas



pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Is it possible to recover the schema from the raw files?
Next
From: Adrian Klaver
Date:
Subject: Re: Is it possible to recover the schema from the raw files?