Re: pg_rawdump - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_rawdump
Date
Msg-id 5608.1287692719@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_rawdump  ("Stephen R. van den Berg" <srb@cuci.nl>)
Responses Re: pg_rawdump  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
"Stephen R. van den Berg" <srb@cuci.nl> writes:
> Tom Lane wrote:
>> There are way too many scenarios where you'll have no hope of doing
>> any such manual recovery anyway.

> True.  It's all a matter of statistics.  Judging by the number of reports
> I find by googling net-history, I'd have to conclude that the proposed
> extra information would have helped more than half of them.

Uh, no, it would have helped whatever minuscule fraction of them had the
tools and the expertise to make use of the information.  This should not
be confused with a magic fix-it button.  If you've lost your system
catalogs you're facing a whole lot of work that will at best recover an
untrustworthy version of some of your data.  Most of the data-loss
reports I've seen appeared to come from people who wouldn't be capable
of doing such recovery work even if better tools were available.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: max_wal_senders must die
Next
From: Tom Lane
Date:
Subject: Re: Per-column collation, work in progress