Re: Recovery from multi trouble - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Recovery from multi trouble
Date
Msg-id 14505.1143473207@sss.pgh.pa.us
Whole thread Raw
In response to Re: Recovery from multi trouble  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> On Mon, 2006-03-27 at 12:14 +0900, OKADA Satoshi wrote:
>> Our aim is giving database recovery chances to a database administrator
>> at PostgreSQL startup time when there is possibility of data loss of
>> losing log files.

> There is no possibility of data loss because of loss of a single log
> file, if you have your hardware configured correctly.

I'm fairly concerned about whether this isn't just replacing one failure
mode with another one.  See nearby discussion with Alex Bahdushka for a
graphic reminder why PANICing on any little thing during WAL replay is
not necessarily such a great idea.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] PANIC: heap_update_redo: no block
Next
From: Tom Lane
Date:
Subject: Re: Shared memory