Skip site navigation (1) Skip section navigation (2)

Re: AW: WAL does not recover gracefully from out-of-disk-sp ace

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
Cc: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Vadim Mikheev <vadim4o(at)email(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: AW: WAL does not recover gracefully from out-of-disk-sp ace
Date: 2001-02-26 17:22:27
Message-ID: 200102261722.MAA28781@candle.pha.pa.us (view raw or flat)
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2001-02-26 17:25:16
Subject: Re: AW: Release in 2 weeks ...
Previous:From: Jan WieckDate: 2001-02-26 17:16:19
Subject: Re: ExecOpenScanR: failed to open relation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group