Re: Enable data checksums by default - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Enable data checksums by default
Date
Msg-id CA+TgmoZjvCnFuQR5MnGkr9A7yYNArSFbUtrjhoD60U2iaMj-Vw@mail.gmail.com
Whole thread Raw
In response to Re: Enable data checksums by default  (Peter Eisentraut <peter@eisentraut.org>)
Responses Re: Enable data checksums by default
List pgsql-hackers
On Thu, Aug 8, 2024 at 6:11 AM Peter Eisentraut <peter@eisentraut.org> wrote:
> About the claim that it's already the de-facto standard.  Maybe that is
> approximately true for "serious" installations.  But AFAICT, the popular
> packagings don't enable checksums by default, so there is likely a
> significant middle tier between "just trying it out" and serious
> production use that don't have it turned on.

+1.

> I'm thinking pg_upgrade could have a mode where it adds the
> checksum during the upgrade as it copies the files (essentially a subset
> of pg_checksums).  I think that would be useful for that middle tier of
> users who just want a good default experience.

That would be very nice.

--
Robert Haas
EDB: http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Vectored IO in XLogWrite()
Next
From: Nathan Bossart
Date:
Subject: fix CRC algorithm in WAL reliability docs