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 1vpM4F-006KGE-0H for pgsql-hackers@arkaria.postgresql.org; Mon, 09 Feb 2026 07:52:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vpM4E-009h7i-0Q for pgsql-hackers@arkaria.postgresql.org; Mon, 09 Feb 2026 07:52:21 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vpM4D-009h7a-2D for pgsql-hackers@lists.postgresql.org; Mon, 09 Feb 2026 07:52:21 +0000 Received: from mout.gmx.net ([212.227.15.15]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vpM4A-00000001F5a-44JD for pgsql-hackers@lists.postgresql.org; Mon, 09 Feb 2026 07:52:20 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1770623531; x=1771228331; i=mbanck@gmx.net; bh=7H1BvfflkAAvb7REb6JcyO9WbbQ22TVGBoGsz0ANwkA=; h=X-UI-Sender-Class:Date:From:To:Cc:Subject:Message-ID:References: MIME-Version:Content-Type:In-Reply-To:cc: content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=QikyidQE1zJSFVoC/sRolyOE6yTQbTG3VXRsLM8mg33yd/n1lOeupRnKpYTx/SpG bTrCXrHe9+hPT7LOu+iNjIt0rUx89sg0g7BbUyGAa31aNqZcpEsNPXw6jjyJBzzVE 50Mb13rJYtB88b0+7S8ibiWdQil5J8nxXTtT+5kUL3xcIH78gmHvCxh2eLX7cSZdl E9o84hH9hOcaKu1fJxwS1Lv6tfbq02uKI6uFNYbFITa998dhDPcUpwedXb6xWutpT VkOFQLvgIVodsAL+5B9cVQr5PWhi157T2HecQWLlYq9ig4fHFY0DEiT9xfpdKSjtv 6FbJccb/wiBPt5vCQA== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from lightning.p46.dedyn.io ([188.174.173.229]) by mail.gmx.net (mrgmx004 [212.227.17.190]) with ESMTPSA (Nemesis) id 1MUGi9-1wG88u2pyV-00JpeQ; Mon, 09 Feb 2026 08:52:11 +0100 Received: from mbanck by lightning.p46.dedyn.io with local (Exim 4.92) (envelope-from ) id 1vpM42-0006pC-Ro; Mon, 09 Feb 2026 08:52:10 +0100 Date: Mon, 9 Feb 2026 08:52:10 +0100 From: Michael Banck To: Tomas Vondra Cc: Daniel Gustafsson , Andres Freund , Bernd Helmle , Michael Paquier , PostgreSQL Hackers Subject: Re: Changing the state of data checksums in a running cluster Message-ID: <20260209075210.GB23161@p46.dedyn.io;lightning.p46.dedyn.io> References: <3e67160c-3676-4419-b635-1fdb80dc128e@vondra.me> <67726BDA-2F21-4D93-B01F-FA68212ED6F0@yesql.se> <9CA2495B-2D6C-4308-97EF-A12CCCAA753E@yesql.se> <477897AE-1314-4724-9694-0BABC4F4ABDA@yesql.se> <5mv5vtbqj2xm2wmevsi22smyn32jtznva3ya3daih3ixh3onex@s5fyab63xt3c> <2535E72D-5979-4F58-A2D3-2AA4AA335C20@yesql.se> <775fddbc-4dec-413d-89bb-1a8186858ee6@vondra.me> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <775fddbc-4dec-413d-89bb-1a8186858ee6@vondra.me> User-Agent: Mutt/1.10.1 (2018-07-13) X-Provags-ID: V03:K1:hAHf3k+R4LK5LxXEBBafEkcJq0L6EL8xL45cKpe4jIhfTLyKuhl oqMUSL6eXOwzBvsp4e4hvy2CmGEi4iPHzx9wIHNBmwPFJT5CRQ20lqM8fC0kn5h7PqQUFpi 4yFD4H1botY9ksqd7xXcbJsPnqmUMTPW/ZoBqpDB7Er81w/JqsqPehq/PRr27OVhHkPadlp K6MgOXEgEHSv35qfkG5NA== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:lCR4e0+wujs=;uzSm3tohkF3JTKhKaziPsuewM8q PzNKhK8bYy8ohHne3nE9smbFtOQfk1JgUWtduiW8tSDrRw0PKeaNUQt/adZ9NNbaF/lTdja0H eCb6CJUMDEZ3mtvJjkX/2ghna5STNcErXDE4bMooFuaZBV4C7DL+McmurP5YEZCrpfnvLtTu0 Or2H6cz0j8M9Qy4MLY0cmiQ7Vrq2HYlb21L5poxY9kro7z9VTcgjwlctAhC+xzQd2XRBpgDo7 nvVSd/N0l+Jloj275+pDP2xB76oSwrYckBnO1SrBe6rxFRkLrGcFM/3U4SY9Gzck5m5Kc6bE0 aqeZxXWI9cLSEBtJbTBEKfg4irnz7+QHA1WQzLts3hCHd98kY8r5izV2M8tNw00jHwtc8oTlL C94To8DLXucWRMLAWMDl1RpsX2gDSDIOH3MRHZzEwEzL0m22+6Nh/EZk97umZ4OX41vUYbJma ZshloUWVgJRbNws+8P4XPnGfJdODaW7artfcgj3gAqAC1JTB7ZkErfWMQRoXL7xxMlAIIzsG+ MKx2wgQxTIrXjgBW6Y+iepDC/0G5OywXDZUVlsIxlu0VDeFYSGA2zpnBFEu2GuHoVZqEddJ1z TM57R1r5bc3zDveEBQwznQJJk4uvFBvUN4VhOHyNS9rCF5Ok5JWHWLjZXyo9YWJtsX1JwgJMu s65wm9Pm3DzoVtjGiRIQbx59HGLBFzyhrSbReN3XSTJHsi3nPBkQUntRxCgn9Tild2HAq+qLH ZnD9XaGVDeGgXFvsc6//HaZ3PmxWudZTrYOuB5S84JMVCzsSmPyqErk/0o1o73qwchQsOOUC8 r9AwrhdZRPBZXDDIU560Zo1i79JTybIbquQJQGYUy9DpKihKuMcgSpmFfYw+B/egL9t/WLyD4 ngB6sLRwNUfkQxJ+qL7Nz7FQ+Sfe3V+HBvTsWaGQZpO4L/mA6v5FxqIBvE4/bi7gV9ft7YKxI THoJ/pY4JcAAr9qzij1hWXy4LSJgNiH4J6lHFI0FLp7Qw1uY7nVLa002Rsx6rD2dnHfHagH7E XnEAXMeLfpAAoVxrO89KdZaGpDJhPjOJHoActOlnixs8T7kFTSX1dQpx20rpAYAtL6Ny3++xe HXZqKlfvqffOyo44w0LF/yog2+FaSMjVBQ3Fi9If7ZpjeIyUMKnYrTE6AF0OS5h9Zl5ceaePX kJYNBm4YEiDBQ7lad8wnjvSB8md2s70RM5EtQgzPmLTCbLPSf7inDHABLnr4hCRBMKbpvryUf oEbUR3OIbCt0kf+WY4H99++z/zgnO8dOh9TNDyevD3RPF65GdnBFPepPXiqlS9xufIJtS8sdk OyNd1yDNyQ0FMYLSjuJ/8C2SpAlTyWYf18Yl5U8Lrt1J4bkfQAyrDhZ3IQBgC97t7ZGcLpUdy m3vBW2rUqJ2HNxOu3Pkc1XvAsKbZ+PN7gG5vApbcBbZsXVHMSinDbcK0O/7lJe2iT7lQFN8Ly VgmrFe6Un7lW3wM+TxuBRO21PNg9dGC30qIuE7jctw4Bfcqfk3OmSjESPudfa9UiiovmvNq/a SA9KWLYlFrNa3wZI8MRAdgYyE+mxYsM+Ugo2ZmKuR9K6lZpTEbQ7LXfn2/6WW8dEKKdwMRkJW O+Q6pDWYiPKSo7i3hKwVzDDAFJpzDU0CevhZBFcVBAJ7EW9WFb/FZIy48ApsBacBS3AEuLjBO OMfZn7l/vsO7VacC3lLPxhMbFr7Dwrx6EyNKwjXy6uAbUlOt5+hkxP3sj/cXSUbW+UXJwssyV 8g2pZsm6KdBSFL1v2dmc/SMPUV5jvVbyetilnqVHRPffJJeBiwNwDbG2fstQXCcdxQww4opsP KFL/lHuwTIL0nCMV6K+vaCqXD1hPs+iUEqiAP4NLEK0lHTPswGYzic8h8gVAQGSFJa7wKoTex jB+Ie5gwg5l75NNBFiyZUntsc//o8EP643/xB9IoO3OJ+mN/assUvRvCHRvGz18IAuDbnHcWa 3Lfbl+UNgL55BxL/Q1dJVCAQ2cJpjYnNOxmirJ0FxgRnWb/YRvAZhzh3mk0GeNs3jxfVUmbFM e92/T5LD6eOPHMSDJDhTjEPP0NTiDxDLbLDDdxrvW0lS6K2JFy4sxvf3R0/bIq62nVgH3dXSX Q+o4k1NYOSDMEkhWfyPK2YCqcF+pj8gwv2IwlU7OsqeSbnowu4xUiwQEaEeH81oj5VTuG5WGm UDV0TI3eYx7W0F/LTS6DzEtPkv4tGn4Kdu6LdvEDdUGRGbdidIOAllMsFXGwSMZ1zMiHS4NE1 zbGAl3Xag+H1SpXpZE31xrPD/zLk4SAGhNazDavWga8W82ibxzrBXa5nTiEyNpo3jq4iIec6I a17BivKU6aca6aETiJ2zQGQgLrTYAw8OOL3u73nAwtRUwGhVhAXvXRgjFHEvudo+86zU0pc8g O7MiQEqIyPLHUR1c1I87HTVftkcy1e4/mAKnT/BDlsPcU2HKzPZEqKlRQJUKLvlaEfzoAC9O+ GXep43euBtZeOcHvGcHGB9TYKiELDU3FZKR8iPppkDqBsyy1EUwB4p933Sg8re21+7ZMGdNif 7MXhcq8+pWyFfrSBfaQAdNmgn00WvGSKO7OWyPSO1o0TjOeE2UV/qVC03ZzfVW5O7hzHNbyAz zwNGQqCFRMMqoa/1K+dfCKZNU1zHMZ1Z/R3rrjWOenp6+pO6nZWtNoKXJot2aJcsy8xl0+edl 0kvHeXsyXzDssgrS8XWSlcgSQ87zR0B5aSSB/R/gifRjxfo2uLPRQRfeTrmX5m3Gr6sMfFrPk U9V8RhhtRI82LwQRm/Yp1u1eu0aQECklMSaxWIv8zmrHFNxfVL8SDbWqYPbQZ6Nh3q30u8Xqb bMqMb3UB2ZB811ABwALKQkxMKz03G0kqcVNOV4a6FZIxQk/AWEqNwndVRrfHADQKNNUC/M7kG M50u7l9ntajsUY2MgURlQdTXG3sHCxJLNeyPTc3KljMj011HjKX5XLiY0cdjp7XkbQdMK4A2Z kueTjCSuOq9sQ3kdEoHQYAyEfxyvyeEW9JjLu4K98C4MoXMQWYPUem75pW0q6pKy889Bdi7ed KMnnIRFln6A+aI80RisIJSrUmJ4FGpl3IRyVBt3YKbZTGvsLejw14NQY2EPPf2w6zkmPDgm+w A1tI5n0IlgW7aicn7shj+z1DvdKRtk/4q8Bd0RTaqieYPP/SgBM/UO08Iy0LOqWJCkIOxvl2n 2Rg2iKxfKRxDnFbic4989Sk+zamAVQTpX0etpoOuBQdiCIAyQNZxx1dqinFXq9JydofDwbMhT 8gdkGJz6dLo5U3tchgi+tp783bMzAYmJ4qiCoV33vEvKXpsf2mL61jloczBYYZimjWDEIg6M2 Lthy5j72+p0TudqQdYekALsmhWOMCXu8g05bFp8qPuTE8rWLxxc3RDw43Ry3x/YhTmf/EGn/z qxT5XCa5kWROkeaACy7eIWSP1w4nWM6OoWVa/NpDvAdIMvOSmEucJhHbtvf95WkhpEbfsKYk8 t12I2Qu00khaBPFDhViSXv8v/OjHr+u3iCCEWAuL1GwucbEKvHZQOwAQ8xcPRUpzsvj3mdPaN 3eKsG2/a8NaKR2Ugx1+wC4St2kN8NJ7UdkARcGYh/G5Wz3OG5qPWj+yEL+kXEJ4Du8UYb5D8n 1PLc7l0kNoOucukc6/nmmqMF621jHB0wthYuwdKtP8z2HXNFJNpoJOkAljHwl+Ltq68HjnHrs Qo0LTZI/BuBYnwrgvROZjZdNK4TktpYKSD3PGzEzfePtEraN937Ext8snD67V+bN1YZjPZ814 okoHG90xiwTX8mq7tdW6Glq2Wu3Hx155Uh12N1vN8Y9+0b24SEdl2QEw3+do1mw7ziJRIHWtE CijAhOUXhfNjKkOhokmwa0RSypbQoj/fYLEz9GTiJFNMnIiuG/DGiXulx0oRYJKxGjAtwoHaa ILHLbX8vDqTzT5fZCMBPZDMePuOVxJYNIKlkdIjNu9MCCvYCM+PtBnFuzwN2vDnG2tlqem/IJ OI0QibfCIkcIZ94xYbLw+xBnel/12KbxMSvzjrvlHRzO7p7WrZOTDzufFZwUMkgiuawNtjWQ/ IqS7syuttKcDBZZFN45+/Jt9pKIqRRBFlqOl2updKj5NwRcuXwKTPLbBKhLY3F909GAcU38e1 fVzF7m1w3/GPWFtU/x1kKGiYb/6R7LdVoocb50qEHlHCny6Os/II4UlIqe2tSg7T352ioQ6lU KzHZUn4w+qIYJ+l/bBb2BpUJFR9RgpI3gQULaExcC9t8j/2hcrtjDMn55u9SxVEY3mvdOyNYY pFfGSGWv+XDT455SYyFJYZlcahbdgDmHmLLmnGaYrCUia7W+WWLaXw5TmojeNboy79A1vaBrr N/KAZTVJXD199Jj/CIdNYeE3Syi1HpozA6qU3kdYZHV7EdioT/enb6Hn532GioynjrwFjx0RE 5xKjhmkfLBbhVrkOVGH9QhIwqonjz5ZGf+OK/07iOLmKQ63R0bjygAHnRxAWIBDaXSLoeLabT f6DYTs+l/TIxOjHraOh5LgkNw5RgHP1qJwOdFSnfBa5ne36X516asQ9TlHsYqT8gDTLrEGKgl WtA2/5Z2PNDY5e5M3WVqSIK8JnbSmPpZKGfonEi/vo2YrEXjo09008fdgn0bvYh/g8WFS3S50 7gmCeeuQCFcisj5d3R05Da+D4sEMLC7yZCo6W1I+u339kQen0nak6kxOY82FdT82BhGRjdX8I KkVKWFlA6ruLoz+I0XUWIdwSDnDMjmjwyjxHCWy6bipStRQANf492BvnRH4N3wX4a1GNdLgSD nU7aAaXAJq0ALcR91m5kA1uiPyUudi7cMBAzq6aw0++RlatFzW2+64yupFtEp/DCQ8PHcqA4B rZALv3KbODS99GZ+P+u24aps1wsDrxKk3Ld7LyEt7RpmWoyc7zgMmQUCZdcIzWhXTz88fbfrH lTYoBxRj88A0eT81+7LR5X7osrd/pEEwX7YD/JZT0bu5E+hzmGvDR1tQNmn/VF9ke36ElJhvf EFoJUAuyRoe/4nwzsrCWJhlXPeXGsf0ciStl5a/DGsaGqBUOy9IPipuGUNvAyz2UI9YEYMI/V ZLLL5soraOO1/cPZRLxDMsovtfErO0SmgORy1I3kVvpLWJAnC9LT6yig2KJiM29AZkVwiEvHO o5y9ok9FC0gapAPl9Shv57+riHQDAKL8iZ9s6is8sST7qr+ZCqdBns9FEOkN3VTq34mwYxuw4 yUbuDxLl/IRhgE7vQDeM6HjTV3iiBXZj+gP8LF1EQCiPJxyneug== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Fri, Feb 06, 2026 at 12:15:27AM +0100, Tomas Vondra wrote: > It's a bit unfortunate we only detect invalid checksums if the failures > appear in the server log. I wonder if we could run pg_checksums after > the cluster gets shut down in 'fast' mode (we can't do that with > immediate shutdowns, of course). Well, maybe we could do that with immediate shutdowns if we add a --force parameter to pg_checksums that is clearly labelled/docmented as being dangerous for running instances (but the instance wouldn't run in this case). Or something undocumented like --debug-force-unclean-controlfile. Michael