pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
To: Daniel Gustafsson <daniel@yesql.se>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Cc: Zsolt Parragi <zsolt.parragi@percona.com>
Subject: Re: Offline data checksum changes can cause incorrect checksum state on standbys
Date: Fri, 14 Aug 2026 15:27:44 +0000
Message-ID: <an8z8CJMa46FIxxn@bdtpg> (raw)
In-Reply-To: <1C2BC974-44FA-487C-8A3B-8135A316A89B@yesql.se>
References: <anwm6UPxoVS41QA2@bdtpg>
	<1C2BC974-44FA-487C-8A3B-8135A316A89B@yesql.se>

Hi,

On Fri, Aug 14, 2026 at 03:59:06PM +0200, Daniel Gustafsson wrote:
> running a cluster with mismatched data_checksums
> settings across the nodes is not a supported mode of operation, and is already
> documented to not work

Thanks for feedback!

The pre f19c0eccae96 pg_checksums documentation said:

"
When using a replication setup with tools which perform direct copies
of relation file blocks (for example pg_rewind), enabling or disabling
checksums can lead to page corruptions in the shape of incorrect
checksums if the operation is not done consistently across all nodes.
"

I read that as a recommendation to stop and switch all nodes consistently, and
as a warning about direct block-copy tools. That interpretation, together with
the pre f19c0eccae96 behavior, is why v1 proposed keeping offline pg_checksums
changes local. The intention was to preserve the previous behavior, not to
introduce a new supported mode.

I just realized that f19c0eccae96 explicitly changed the "Off-line Enabling of
Checksums" documentation:

"
Data checksums are enabled or disabled at the full cluster level, and cannot
be specified individually for databases or tables.
"

by:

"
Data checksums are enabled or disabled at the full cluster level, and cannot
be specified individually for databases, tables or replicated cluster members.
"

while leaving the pg_checksums documentation quoted above unchanged.

Depending on how the issue will be addressed, it might be worth changing this 
pg_checksums wording too?

Looking forward to seeing your and Zsolt's proposals.

Regards,

-- 
Bertrand Drouvot
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com






view thread (43+ messages)  latest in thread

Message-ID: <an8z8CJMa46FIxxn@bdtpg>
Permalink:  ../an8z8CJMa46FIxxn@bdtpg/
Also on:    postgresql.org/message-id/an8z8CJMa46FIxxn@bdtpg

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: bertranddrouvot.pg@gmail.com, daniel@yesql.se, pgsql-hackers@lists.postgresql.org, zsolt.parragi@percona.com
  Subject: Re: Offline data checksum changes can cause incorrect checksum state on standbys
  In-Reply-To: <an8z8CJMa46FIxxn@bdtpg>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox