Re: AW: WAL does not recover gracefully from out-of-disk-sp ace - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: AW: WAL does not recover gracefully from out-of-disk-sp ace
Date
Msg-id 200102261722.MAA28781@candle.pha.pa.us
Whole thread Raw
In response to AW: WAL does not recover gracefully from out-of-disk-sp ace  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
List pgsql-hackers
[ Charset ISO-8859-1 unsupported, converting... ]
> 
> > Regardless of whether this particular behavior is fixable, this brings
> > up something that I think we *must* do before 7.1 release: create a
> > utility that blows away a corrupted logfile to allow the system to
> > restart with whatever is in the datafiles.  Otherwise, there is no
> > recovery technique for WAL restart failures, short of initdb and
> > restore from last backup.  I'd rather be able to get at data of
> > questionable up-to-dateness than not have any chance of recovery
> > at all.
> 
Update OPEN ITEMS list:

Source Code Changes
-------------------
Allow recovery from corrupted WAL file
Finalize commit_delay value

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Ian Lance Taylor
Date:
Subject: Re: Re: [PATCHES] A patch for xlog.c
Next
From: Bruce Momjian
Date:
Subject: Re: AW: Release in 2 weeks ...