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

From David G. Johnston
Subject Is it possible to recover the schema from the raw files?
Date
Msg-id CAKFQuwYBm3ta6M0Efp=Z6rTbx6Ye+G62gvAtVrYFeRaaGSYYnw@mail.gmail.com
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
On Sunday, April 24, 2016, Karsten Hilbert <Karsten.Hilbert@gmx.net> wrote:
On Sun, Apr 24, 2016 at 04:35:56PM +0100, Tomas J Stehlik wrote:

>> Well if the corrupted raw files include the system information
>> then I think you are out of luck.
>
> Well, this topic is not about "luck".

Surely, English isn't my vernacular language - but "out of
luck" has seemed to be an euphemism for "no, it
ain't possible" to me unto now.

Adrian cautiously added "I think" (as in 'he thinks').


Not quite.  It means the outcome does rely on luck to some degree.  You got lucky if the area of corruption doesn't include the area in which the data you want resides.  You were unlucky, or out of luck, if the corruption includes the desired data.  It's still an exaggeration because the luck being noted is quite specific within this specific context the point of luck playing a factor is correctly made.

My understanding is the potential exists but the outcome is uncertain.  People are suggesting some of the simple ways to accomplish this goal before informing you like quite possibly you should consider hiring someone specializing in this sort of thing.  You should be understanding that some things may have been tried or already deemed insufficient and do it anyway - it's part of a process which itself i difficult to do over email.  You might trying hooking up with someone on IRC...

David J.

pgsql-general by date:

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