Re: Changing the state of data checksums in a running cluster

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Tomas Vondra <tomas(at)vondra(dot)me>, Bernd Helmle <mailings(at)oopsware(dot)de>, Michael Paquier <michael(at)paquier(dot)xyz>, Michael Banck <mbanck(at)gmx(dot)net>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Changing the state of data checksums in a running cluster
Date: 2026-02-05 20:01:38
Message-ID: DEE0237A-D38C-477F-997C-3B0EB2D4FC57@yesql.se
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On 3 Feb 2026, at 17:58, Daniel Gustafsson <daniel(at)yesql(dot)se> wrote:

> I've implemented this in the attached patch and it seems very promising.

Turns out I was a bit quick on the send button, and having been focused on the
failing test_checksums suite I missed running the other suites. (I also
managed to off-by-one-year name it 202503..) Thanks to some quick off-list
feedback, here is an updated version which fixes the failing tests and has
quite a number of smaller touchups.

Like the previous version, I am not sure I have the CHECKPOINT_xxx logic right
and would love some eyes on it.

--
Daniel Gustafsson

Attachment Content-Type Size
v20260305-0001-Online-enabling-and-disabling-of-data-chec.patch application/octet-stream 221.7 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2026-02-05 20:23:38 Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible
Previous Message Radim Marek 2026-02-05 19:53:57 Re: Non-deterministic buffer counts reported in execution with EXPLAIN ANALYZE BUFFERS