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 15:58:48
Message-ID: 003501d19e42$304910e0$90db32a0$@stehlik.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello Karsten,

Thank you.

> I believe Adrian wanted to know whether you attempted a
> schema or complete dump *after* the fact, like what he
> suggested a mail ago or so.
>
> In case the FS corruption "only" affects raw files related to
> user data (as opposed to also affecting data in pg_* tables)
> a schema-only dump does have a slight chance of success.
>
> That chance might potentially be increased by judicious use
> of zero_damaged_pages and related low-level techniques the
> prerequisite conditions of which people seem to have been
> trying to inquire about upthread.
>
> > The question potentially targets someone who could tell
> > whether something like this is possible.
>
> "possible" depends no the exact circumstances, the details of
> which people have been trying to tease out.

All this relevant information has already been supplied previously.

Kind regards,

Tomas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2016-04-24 16:01:49 Re: Is it possible to recover the schema from the raw files?
Previous Message Adrian Klaver 2016-04-24 15:58:01 Re: Is it possible to recover the schema from the raw files?