Re: Is it possible to recover the schema from the raw files?

From: "Tomas J Stehlik" <tomas(at)stehlik(dot)co(dot)uk>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Is it possible to recover the schema from the raw files?
Date: 2016-04-24 16:12:19
Message-ID: 003901d19e44$142419d0$3c6c4d70$@stehlik.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2016-04-24 16:13:34 Re: Is it possible to recover the schema from the raw files?
Previous Message David G. Johnston 2016-04-24 16:10:42 Is it possible to recover the schema from the raw files?