Re: pg_filedump 9.3: checksums (and a few other fixes) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_filedump 9.3: checksums (and a few other fixes)
Date
Msg-id 19912.1372341067@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_filedump 9.3: checksums (and a few other fixes)  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: pg_filedump 9.3: checksums (and a few other fixes)  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
Andres Freund <andres@2ndquadrant.com> writes:
> On 2013-06-26 21:18:49 -0700, Peter Geoghegan wrote:
>> Heroku are interested in online verification of basebackups (i.e.
>> using checksums to verify the integrity of heap files as they are
>> backed up, with a view to relying less and less on logical backups).

> Why not do this from a function/background worker in the backend where
> you can go via the buffer manager to avoid torn pages et al. If you use
> a buffer strategy the cache poisoning et al should be controlleable.

That would require having a functioning postmaster environment, which
seems like it would make such a tool much less flexible.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Move unused buffers to freelist
Next
From: David Fetter
Date:
Subject: Re: FILTER for aggregates [was Re: Department of Redundancy Department: makeNode(FuncCall) division]