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

help / color / mirror / Atom feed
From: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
To: Zsolt Parragi <zsolt.parragi@percona.com>
Cc: Daniel Gustafsson <daniel@yesql.se>
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: Offline data checksum changes can cause incorrect checksum state on standbys
Date: Mon, 31 Aug 2026 11:38:40 +0000
Message-ID: <apVnwOuJBb4rHk+B@bdtpg> (raw)
In-Reply-To: <CAN4CZFNqKg9Ts76r922cKWcOgtH32ocyghQa8NLB-qeCeC1RKg@mail.gmail.com>
References: <apFTwa68Qn0S0dIX@bdtpg>
	<CAN4CZFOv4CZfj0i1oesNhZV68zMN7SQtZPLJFEQip2dG=Pf-8Q@mail.gmail.com>
	<apGltAexjCkHPatS@bdtpg>
	<CAN4CZFMaw79Yd-sV=g=016xX3kpijD0WH3fPJEAkSusZwn7Avw@mail.gmail.com>
	<apJGv8fffeUfSkCL@bdtpg>
	<CAN4CZFMoDj7mbY231r-pmPywwJpneksUiNXDwkNokkveGtobQg@mail.gmail.com>
	<apUL3N4IE934qJ08@bdtpg>
	<8DCA12FF-0199-403D-A203-666528A25DB6@yesql.se>
	<apU0vKrffQDmmv68@bdtpg>
	<CAN4CZFNqKg9Ts76r922cKWcOgtH32ocyghQa8NLB-qeCeC1RKg@mail.gmail.com>

Hi,

On Mon, Aug 31, 2026 at 11:55:01AM +0100, Zsolt Parragi wrote:
> > Yeah, I see your point that the underlying issue is the non WAL logged change.
> > My concern was not about a pg_control change in itself, but that addressing this
> > case might require further changes to the current pg_control design, which adds
> > risk this close to RC1.
> 
> I don't think we can get this completely right without both wal and
> pg_control changes (and possibly some extra connection-time
> communication between the standby and primary to provide early
> reporting instead of delayed in the most common cases)
> If we want to move toward the error direction in pg20 (which we
> should) we will have to log that an offline change happened.
> 
> I attached v6 which for now documents the current behavior as-is, and
> other than that I reorganized the test files.

Thanks! I did not look in details but it looks like that pg_upgrade --check against
a running source cluster with checksums enabled will still fail (finding === 2 in
[0], tested with the test shared in [1]).

[0]: https://postgr.es/m/apUL3N4IE934qJ08%40bdtpg
[1]: https://postgr.es/m/apU4/hmRv/4gv20W%40bdtpg

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: <apVnwOuJBb4rHk+B@bdtpg>
Permalink:  ../apVnwOuJBb4rHk+B@bdtpg/
Also on:    postgresql.org/message-id/apVnwOuJBb4rHk+B@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, zsolt.parragi@percona.com, daniel@yesql.se, pgsql-hackers@lists.postgresql.org
  Subject: Re: Offline data checksum changes can cause incorrect checksum state on standbys
  In-Reply-To: <apVnwOuJBb4rHk+B@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