Re: [HACKERS] Checksums by default? - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: [HACKERS] Checksums by default?
Date
Msg-id CAB7nPqQYGnr_d-QJgCBr_7cxediv8zk29pBC5az=PSz1h+=7kQ@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Checksums by default?  (Peter Geoghegan <pg@heroku.com>)
Responses Re: [HACKERS] Checksums by default?  (Andres Freund <andres@anarazel.de>)
Re: [HACKERS] Checksums by default?  (Robert Haas <robertmhaas@gmail.com>)
Re: [HACKERS] Checksums by default?  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
On Thu, Jan 26, 2017 at 9:14 AM, Peter Geoghegan <pg@heroku.com> wrote:
> On Wed, Jan 25, 2017 at 3:30 PM, Stephen Frost <sfrost@snowman.net> wrote:
>> As it is, there are backup solutions which *do* check the checksum when
>> backing up PG.  This is no longer, thankfully, some hypothetical thing,
>> but something which really exists and will hopefully keep users from
>> losing data.
>
> Wouldn't that have issues with torn pages?

Why? What do you foresee here? I would think such backup solutions are
careful enough to ensure correctly the durability of pages so as they
are not partially written.
-- 
Michael



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: [HACKERS] safer node casting
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] safer node casting