Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1x091M-004TwE-2z for pgsql-hackers@arkaria.postgresql.org; Sat, 29 Aug 2026 02:42:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1x090L-00AH2P-0E for pgsql-hackers@arkaria.postgresql.org; Sat, 29 Aug 2026 02:41:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1x090K-00AH2H-2I for pgsql-hackers@lists.postgresql.org; Sat, 29 Aug 2026 02:41:12 +0000 Received: from mail-wr1-x42c.google.com ([2a00:1450:4864:20::42c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1x090G-00000001odD-2Fpv for pgsql-hackers@lists.postgresql.org; Sat, 29 Aug 2026 02:41:10 +0000 Received: by mail-wr1-x42c.google.com with SMTP id ffacd0b85a97d-48431648f33so28954f8f.0 for ; Fri, 28 Aug 2026 19:41:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1787971266; x=1788576066; darn=lists.postgresql.org; h=in-reply-to:content-disposition:content-type:mime-version :references:message-id:subject:cc:to:from:date:from:to:cc:subject :date:message-id:reply-to:content-type; bh=R0zPUm697RnLoovQT8dAH6SsZfCPGNvVILXTlNHbp1Q=; b=U2QSFcoRyn5M98TOubAtjinAIdZfh/pD3L2mxDI0SvnqdILhOjE3LB3k2JtZeCEpxb JifLMAz6c+M5+loWcXZ3Z/LM2dkyGwmBOD12bsWgLREAOEdwIr3+eflhxh7i+wwsoz4H u7rTcYfunpTjK3kazosIaLyBZA9GBnXiK4CPXJ5QW2e0PKswfFCQuhEm2jyPDfW0+USo fZYX5FSIg11GG2OvBEIbVCUdARtjybz2Q7cxDHGnDopPgS3/clvvWyShpbC41OlHIvch WSK2ZY/xUrgWwI2aeeHLRUtCLXBtOAD/7VA6sAJz1HBXAeOujjUf44N4WeErX5EEmWR0 RPYQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1787971266; x=1788576066; h=in-reply-to:content-disposition:content-type:mime-version :references:message-id:subject:cc:to:from:date:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=R0zPUm697RnLoovQT8dAH6SsZfCPGNvVILXTlNHbp1Q=; b=TxX766y+crWAj+pH7uhVqXG7VFzT9gNKcKa5n0nzb1HODS3W3Kgik1xf2I1D4ZSYet LGdkW8LulH2Ll/UbZoUXgGJhpLQIxhG7p0DjT48XWRj2GfFNsG/n0maqnhBtWoD8UcB+ GFrbKrJyP1tEkv8PxTJAqzdmAg9SIkwOTe+o+IPx5WrN2v9Rq944iK11CYB2/As4AsiP 5QUVTYIAUMDqcioWJkqOnJVWm8w1S/UN9yCqbQPpFzPsZ6TVZGdbmdi7Ybm7GbVLUsVZ Os6S0O1q21hAgz+ToeUyNIRituoV/GVVKgf7ZenD2x5zBK0SgBERatLbBYgH6t9hvXoC Mwvg== X-Gm-Message-State: AFuF++ke88hURlcj1/OjlcaX1Om1Gjzq8CkUtsmjeQayrnnly/2XcKre AUcEmhV1Mf8khFBSey9MAIZw3mPy7LZOM7Sbuc9gnYT91+xPX5oUDGnl X-Gm-Gg: AR+sD10FNc4/w1SkerZvfBMsQMfIsBWLWYegNy9DF9siD4gzQOER+47dffgQ6/Jnl10 XavPhZiFGb4YCWfhOGPL1FKPG2Cjzjq47m554AsdeWSnyMqmvMeHhIMgIAnNSLS9RxD+KpoVptm zquetL3sELoivfONzxWFOWopn+zS3PBq78K8H3iC0XkxthqHxblIabFniOqmkkrFwRtBMFlpRDL a+/g5gT+Cd7Xm1h4LV6TB647tFzyFC2SEXF4FMPq1o35f4I42907uoEW+Vvps1AnS301wCCGL2S vj3ZCAS8AxtM7ql4i6zqqS/VlemafRYFIKKdzIHnpnRFSJziBYSb+5V78bOn9v+qAmcd17RG4M6 dmxjk7y9GLFMH9RLxxrzrQJu0sOBPu3z81Tb+EnW6eHudaJ2z2v1OPEnpNAgiAPMPdlJlpALj2t 52PaxNB7m6QNk7Her4aaVdc2/rjTn/4pHh7h2C+on9ZM7nkoAqOTJVtn/ZklstxaMHZ/R5M3gFl P9SfJn/5TwSCyz/OpzNvJs0N4H//UtoARAtJTlStD7+XKso X-Received: by 2002:a05:600c:529b:b0:499:59fd:dbfc with SMTP id 5b1f17b1804b1-49cca2b77afmr56346485e9.1.1787971265738; Fri, 28 Aug 2026 19:41:05 -0700 (PDT) Received: from bdtpg (ec2-15-237-197-144.eu-west-3.compute.amazonaws.com. [15.237.197.144]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-482fbab3f16sm7539479f8f.1.2026.08.28.19.41.04 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 28 Aug 2026 19:41:05 -0700 (PDT) Date: Sat, 29 Aug 2026 02:41:03 +0000 From: Bertrand Drouvot To: Zsolt Parragi Cc: pgsql-hackers@lists.postgresql.org Subject: Re: Offline data checksum changes can cause incorrect checksum state on standbys Message-ID: References: <1C2BC974-44FA-487C-8A3B-8135A316A89B@yesql.se> <188A1307-1A92-45CA-9DBE-FB0962D3756E@yesql.se> <6370C439-408D-40F6-B956-55DF19FFE41C@yesql.se> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Fri, Aug 28, 2026 at 11:04:28AM -0500, Zsolt Parragi wrote: > > > I'll try to look into what adding the two > > > patches together looks like, but it most likely combines their size, > > > as they improve the current master code in different ways. > > > > Thanks! > > I looked into this, Thanks! > and I was right that if I add the pg_control > changes to v4 it nearly doubles the size of the actual code changes > from ~300 to ~550 lines, and fixes all the issues you reported Yeah, that's what I expected, as v1 included those changes to handle these cases. > while > also keeping the existing suite of tests passing. The diff compared to > v4 is relatively simple, so I don't think that would be an issue by > itself, Thanks! I don't see the patch attached. Would you mind sharing it? > but it's another control version change. Do you see the control version change as a concern? Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com