Re: Enabling Checksums - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Enabling Checksums
Date
Msg-id CA+TgmoZw25zxAmKm1tdP_AbWXoyjLBOw4Q0yH-AWLdNfOqqMRA@mail.gmail.com
Whole thread Raw
In response to Re: Enabling Checksums  (Greg Smith <greg@2ndQuadrant.com>)
Responses Re: Enabling Checksums  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
On Mon, Mar 18, 2013 at 4:31 PM, Greg Smith <greg@2ndquadrant.com> wrote:
> to get them going again.  If the install had checksums, I could have figured
> out which blocks were damaged and manually fixed them, basically go on a
> hunt for torn pages and the last known good copy via full-page write.

Wow.  How would you extract such a block image from WAL?

That would be a great tool to have, but I didn't know there was any
practical way of doing it today.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: [COMMITTERS] pgsql: Allow external recovery_config_directory
Next
From: Andres Freund
Date:
Subject: Re: Enabling Checksums