Re: beta testing version - Mailing list pgsql-hackers

From ncm@zembu.com (Nathan Myers)
Subject Re: beta testing version
Date
Msg-id 20001130161024.O22345@store.zembu.com
Whole thread Raw
In response to Re: beta testing version  (The Hermit Hacker <scrappy@hub.org>)
Responses Re: beta testing version  (The Hermit Hacker <scrappy@hub.org>)
Re: beta testing version  (Vince Vielhaber <vev@michvhf.com>)
List pgsql-hackers
On Thu, Nov 30, 2000 at 07:47:08PM -0400, The Hermit Hacker wrote:
> 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 ...

False, on so many counts I can't list them all.

Nathan Myers
ncm



pgsql-hackers by date:

Previous
From: ±è°­¿í
Date:
Subject: eject
Next
From: "Mitch Vincent"
Date:
Subject: Re: beta testing version