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

Re: beta testing version

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: Don Baccus <dhogaza(at)pacifier(dot)com>
Cc: xuyifeng <jamexu(at)telekbird(dot)com(dot)cn>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: beta testing version
Date: 2000-11-30 23:47:08
Message-ID: Pine.BSF.4.21.0011301946260.323-100000@thelab.hub.org (view raw or flat)
Thread:
Lists: 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 ...



In response to

Responses

pgsql-hackers by date

Next:From: musiconDate: 2000-12-01 00:10:00
Subject: eject
Previous:From: Stephan SzaboDate: 2000-11-30 23:39:04
Subject: Re: pg_trigger and tgargs

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