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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Is it possible to recover the schema from the raw files?
Date: 2016-04-24 16:10:42
Message-ID: CAKFQuwYBm3ta6M0Efp=Z6rTbx6Ye+G62gvAtVrYFeRaaGSYYnw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sunday, April 24, 2016, Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net
<javascript:_e(%7B%7D,'cvml','Karsten(dot)Hilbert(at)gmx(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tomas J Stehlik 2016-04-24 16:12:19 Re: Is it possible to recover the schema from the raw files?
Previous Message Karsten Hilbert 2016-04-24 16:08:00 Re: Is it possible to recover the schema from the raw files?