On Thu, 30 Nov 2000, Nathan Myers wrote:
> 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.
would love to hear them ... I'm always opening to having my
misunderstandings corrected ...