Re: Help me recovering data - Mailing list pgsql-hackers

From pgsql@mohawksoft.com
Subject Re: Help me recovering data
Date
Msg-id 16750.24.91.171.78.1108575270.squirrel@mail.mohawksoft.com
Whole thread Raw
In response to Re: Help me recovering data  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-hackers
>
> On Wed, 16 Feb 2005 pgsql@mohawksoft.com wrote:
>
>> > On Wed, 16 Feb 2005 pgsql@mohawksoft.com wrote:
>> >
>> >> >
>> >> > Once autovacuum gets to the point where it's used by default, this
>> >> > particular failure mode should be a thing of the past, but in the
>> >> > meantime I'm not going to panic about it.
>> >>
>> >> I don't know how to say this without sounding like a jerk, (I guess
>> >> that's
>> >> my role sometimes) but would you go back and re-read this sentence?
>> >>
>> >> To paraphrase: "I know this causes a catestrophic data loss, and we
>> have
>> >> plans to fix it in the future, but for now, I'm not going panic about
>> >> it."
>> >
>> > Do you have a useful suggestion about how to fix it?  "Stop working"
>> is
>> > handwaving and merely basically saying, "one of you people should do
>> > something about this" is not a solution to the problem, it's not even
>> an
>> > approach towards a solution to the problem.
>>
>> Actually, it is not a solution to the problem of losing data. It is a
>> drop
>> dead last ditch failsafe that EVERY PRODUCT should have before losing
>> data.
>
> Let's try again. Saying, "one of you people should do something about
> this" is not a solution to the problem or an approach thereto.  "Stop
> working" is handwaving since I see no approach therein that allows the
> user to actually recover the data.
>


Well, it is sort of the the Hockey strike, now that it seems like stoping
normal operation is better than losing billions of rows of data. We can
decide who to do it and how to correct it.




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Help me recovering data
Next
From: Tom Lane
Date:
Subject: Re: Design notes for BufMgrLock rewrite