Re: beta testing version - Mailing list pgsql-hackers

From The Hermit Hacker
Subject Re: beta testing version
Date
Msg-id Pine.BSF.4.21.0011301946260.323-100000@thelab.hub.org
Whole thread Raw
In response to Re: beta testing version  (Don Baccus <dhogaza@pacifier.com>)
Responses Re: beta testing version
List pgsql-hackers
On Thu, 30 Nov 2000, Don Baccus wrote:

> At 07:02 PM 11/30/00 -0400, The Hermit Hacker wrote:
> >
> >v7.1 should improve crash recovery for situations like this ... you'll
> >still have to do a recovery of the data on corruption of this magnitude,
> >but at least with the WAL stuff that Vadim is producing, you'll be able to
> >recover up until the point that the power cable was pulled out of the wall
> 
> No, WAL won't help if an actual database file is corrupted, say by a
> disk drive hosing a block or portion thereof with zeros.  WAL-based
> recovery at startup works on an intact database.

No, WAL does help, cause you can then pull in your last dump and recover
up to the moment that power cable was pulled out of the wall ...




pgsql-hackers by date:

Previous
From: Don Baccus
Date:
Subject: Re: beta testing version
Next
From: Stephan Szabo
Date:
Subject: Re: pg_trigger and tgargs