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

From Karsten Hilbert
Subject Re: Is it possible to recover the schema from the raw files?
Date
Msg-id 20160424155021.GI22543@hermes.hilbert.loc
Whole thread Raw
In response to Re: Is it possible to recover the schema from the raw files?  ("Tomas J Stehlik" <tomas@stehlik.co.uk>)
Responses Re: Is it possible to recover the schema from the raw files?
List pgsql-general
On Sun, Apr 24, 2016 at 04:35:56PM +0100, Tomas J Stehlik wrote:

> > So did you do a schema only dump or a complete dump?
>
> There is no dump. There are just raw files.

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.

Regards,
Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346


pgsql-general by date:

Previous
From: "Tomas J Stehlik"
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?