Re: Offline data checksum changes can cause incorrect checksum state on standbys

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Cc: Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com>, Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Offline data checksum changes can cause incorrect checksum state on standbys
Date: 2026-09-10 10:05:02
Message-ID: 4BCE2F21-B669-46F3-B781-010F71B0B065@yesql.se
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The attached v15 combines the v14 posted yesterday (again, no code changes
here) with the small cleanups from the other thread [1] with LLM review. I
added another one to the list after PGT-6 identified that page zeroing was
logged when ignore_checksum_failures was set, which avoids the zeroing. This
is what I have running in CI and locally, and will push today to close the open
item unless I hear any objections.

--
Daniel Gustafsson

[1] https://postgr.es/m/E15AC050-C4B5-488D-BB2D-3C7AC9F89EA8@yesql.se <mailto:E15AC050-C4B5-488D-BB2D-3C7AC9F89EA8(at)yesql(dot)se>

Attachment Content-Type Size
v15-0009-Only-log-page-zeroing-when-checksums-aren-t-igno.patch application/octet-stream 1.4 KB
v15-0008-Only-reset-launcher-state-in-exit-handler.patch application/octet-stream 1.2 KB
v15-0007-Improve-error-message-for-checksum-state-in-pg_u.patch application/octet-stream 1.6 KB
v15-0006-Fix-enum-value-visibility-for-data_checksums.patch application/octet-stream 1.6 KB
v15-0005-doc-Documentation-updates-for-online-checksums.patch application/octet-stream 22.1 KB
v15-0004-pg_combinebackup-Refuse-mixed-data-checksum-stat.patch application/octet-stream 10.0 KB
v15-0003-pg_rewind-Check-the-data-checksum-states-of-sour.patch application/octet-stream 22.5 KB
v15-0002-pg_checksums-Refuse-interrupted-transitions-note.patch application/octet-stream 7.9 KB
v15-0001-Do-not-adopt-data-checksum-state-from-another-no.patch application/octet-stream 137.0 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Osama Abdul Qader 2026-09-10 10:14:25 Re: REPACK (ANALYZE) within transaction block segfaults
Previous Message Ajin Cherian 2026-09-10 09:52:10 Re: PSQL schema "describe" \dn is not escaping quotes