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.94.2) (envelope-from ) id 1v3X0N-0005OG-Sy for pgsql-admin@arkaria.postgresql.org; Tue, 30 Sep 2025 09:50:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1v3X0L-008MnK-Ov for pgsql-admin@arkaria.postgresql.org; Tue, 30 Sep 2025 09:50:42 +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.94.2) (envelope-from ) id 1v3X0K-008Mn8-B7 for pgsql-admin@lists.postgresql.org; Tue, 30 Sep 2025 09:50:42 +0000 Received: from mx4.stadt-zuerich.ch ([194.56.33.13]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1v3X0C-000fvP-1w for pgsql-admin@postgresql.org; Tue, 30 Sep 2025 09:50:40 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=zuerich.ch; i=@zuerich.ch; l=9741; q=dns/txt; s=zuerichch202311; t=1759225833; x=1790761833; h=from:to:subject:date:message-id:mime-version; bh=lF+WiGqXpbPqKype2ubfN6p4tBxUaaJg5UNL4B0tt1Y=; b=PiOyOB924lU580wnu34bccjxIbV0M3fT48aE8xG/58qR2rSEMfs6oVee QLFv1CDXs3zMR6S4qg5YwG8exI4n8N4kHQ+8HIy+erhO6R0ZbMBqXZHCB gD36d1F12Y0mWahgiOAUwtN1fOOW+18qjCWUDk2j+6056tz4+nw/vh0jx X2NAabhBiJ5SuPVWBvI6bSZKh3KMcQC/zyOgybP/ktckbS/xKe9sj+6OQ RUDD8MNElQO5H9sMEQnToc1b0NbK0MMWhZ1KLP4H0DIU+xKvKhnwPNfes S4zqXxUNq0gA1Rczr4nbVtTcRwQh2bf8H4TvzKuEbYfHeZIxFNvvZXElB w==; X-CSE-ConnectionGUID: cIUaW4skT8isOo9k9Ki6MA== X-CSE-MsgGUID: jVs+ssZkRSa2EJSkRGDYHQ== X-IronPort-AV: E=Sophos;i="6.18,304,1751234400"; d="scan'208,217";a="83443531" Received: from unknown (HELO szhm36076.global.szh.loc) ([10.7.49.110]) by mx4.prm.szh.zone with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 30 Sep 2025 11:50:23 +0200 Received: from szhm36076.global.szh.loc (10.7.49.110) by szhm36076.global.szh.loc (10.7.49.110) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.2562.20; Tue, 30 Sep 2025 11:50:23 +0200 Received: from ZRAP278CU002.outbound.protection.outlook.com (40.93.85.3) by szhm36076.global.szh.loc (10.7.49.110) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.2562.20 via Frontend Transport; Tue, 30 Sep 2025 11:50:23 +0200 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=hAasqtAy3WEmU/QfSG3BB7qjlFTbV99nU414BDBR1fCJbMHxzqrNHAKvMsD5DGuGj0m8o5qCnB9N96b1gjhdqqfUoUDurYWT/zGWcoCTlpI7w/IaTw81VM/X+vtsFbe1GTj7P9ykdA57/H5gL5nfQFaJ02g2iyK2ovy4MJRlIt93T0vY6sLEZc78EKOEdlE4V3l+ySlN9JygzACfY4JDpoNipVS40W2qzW87JVXfaRRWyMBGEGRRyLw+pP/rNhaucKNNVO7pnf/E5gegDGz42cctq2ldZVHBpZnjr0uiyJZXoqcu/rInn+S8xAth9YQ0dcCSUXWojuOn/nOJgG4wyA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=lF+WiGqXpbPqKype2ubfN6p4tBxUaaJg5UNL4B0tt1Y=; b=DAedo08hVcV2RS/iXZDf2lUdnGfQ/MGiX6h3XbtU5jeveOEAMTJspI6SSdQz4KYwwi8aSIxH5NoBAp+15Qz6nD/gnH+H3Sc3m5D4uLyaUh58h4kxmyJUumHFVurxmk9G8/D9MkC1c+oIJn4M2/CD/wix2NIoTtQ98GyBQLM4RHOD+5x5ifAtCt/6WoJakOXTteBtmKnlh1YTsZ3cOgxDSIkR147dZwXKee4s+Egk5ragHtrv7yG/MhzXoC3Aa5anjT1QFdHP3BxitOq83Kef7gLqa+/ca6DrDIHWp/5JUSLTEFQNBFc4sFGJfuSIfroI5r/2aPXT/pH4CF6WhKslcA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=zuerich.ch; dmarc=pass action=none header.from=zuerich.ch; dkim=pass header.d=zuerich.ch; arc=none Received: from GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM (2603:10a6:710:27::12) by GV0P278MB0877.CHEP278.PROD.OUTLOOK.COM (2603:10a6:710:50::12) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9160.17; Tue, 30 Sep 2025 09:50:22 +0000 Received: from GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM ([fe80::13f9:36d9:a222:abce]) by GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM ([fe80::13f9:36d9:a222:abce%6]) with mapi id 15.20.9160.015; Tue, 30 Sep 2025 09:50:22 +0000 From: "Zwettler Markus (OIZ)" To: "pgsql-admin@postgresql.org" Subject: Necessary actions after an OS upgrade Thread-Topic: Necessary actions after an OS upgrade Thread-Index: Adwx6/OyEcwPNmJjRD+3zcbdQelIbg== Date: Tue, 30 Sep 2025 09:50:21 +0000 Message-ID: Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=zuerich.ch; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: GV0P278MB0099:EE_|GV0P278MB0877:EE_ x-ms-office365-filtering-correlation-id: ae804a7f-f1f1-4526-c39a-08de0006c5c2 x-ms-exchange-atpmessageproperties: SA x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|366016|1800799024|376014|8096899003|13003099007|38070700021; x-microsoft-antispam-message-info: =?us-ascii?Q?7t6S/BXvzA9NmXuBO5HEO9E/8XPQFkSHxVkSz4rcAGPIk/erHX/msqyu+vDp?= =?us-ascii?Q?NZ0erVbC5XnLGNps1i4d7XdgC11fZHGlz/hteJI+tZ5yMfsl2hJ2/CTFaDiq?= =?us-ascii?Q?aHAa3CTAfufqy2G3PsuZImQ+gJ7LLhuEo04YcdxI7Cme8fTMgmbY12Js0nxT?= =?us-ascii?Q?9itlN3BMIVOvAvhfWUbLOIIl/+EAl5VOCh896gp6reyHHLxOPJfkAo20hm1i?= =?us-ascii?Q?n/CeHIQIpt1HGH3Dea1oAeVRIrvR+ovINexsISmvJouJGbp+p9/ubKHtaJas?= =?us-ascii?Q?UYLqo7mZo8cW0dGjYShV1gMLUhkcwvf2CLeEez/B2qZk4HLbVTcvhbuZ9AiJ?= =?us-ascii?Q?zl6FEmwC8y//MCA+H/u/FlmhQwJhiBRK2pLc1OY3FlVBWHzG0MMp9435KZj1?= =?us-ascii?Q?QGThCZCmDtAlWpGgyGyBnyN5MoG5+ZkFcmctZqbQ+v9AOlZzR5VJ6bmlhELa?= =?us-ascii?Q?Bd2+TMK8Ya6eZy8YAAsfwO4bcDdwWoA3wpkA0TUnYB0Sixuf/k4YwdxZXbdT?= =?us-ascii?Q?VYIHXf4S3EoR4ZwXod1qZpsaTYk7ldSMLb9t+zbut+idMDCKu73p7YKEM+T8?= =?us-ascii?Q?zSNRySY8zuoemJZroF06BPdeK+ropIPIpyLOvWoRN8ZEG+EQxJgup3Exy1KY?= =?us-ascii?Q?1CFvlrIa5SDgFAhGxwWnHihImj/SFcbi8JE2IZgCgK0j6p4T0W/o+MNlZEfO?= =?us-ascii?Q?gY0EOnj2NQRg3JskInBUM9gXmrRRnyu6rPx+jqEo78+sF90b+kC2zdwfUY1y?= =?us-ascii?Q?ISU+lDUM3DlwlRgDz2VRkDPffFdkhUxMYoHjCcZ6ekqLmyH81o34bXcObo9D?= =?us-ascii?Q?aV/Cq1cDT9YpPTTLEZLLV8EbGV866lIkY+FaBXWBGni1oANof65ml0bVXA8/?= =?us-ascii?Q?dnnXN0BhhnTF3j+4DCskMRZfZuASxbj6esXsHjH1M/JBSTsaYzgEx3fLTBaT?= =?us-ascii?Q?wIYV4MNlt1Ws4atACVJwj+WGfsTVR2vkRSqlr3juq1XDSfgelv97SuhhLJmd?= =?us-ascii?Q?65ixoGm/degfCWMuWNK3RaysFjQwcB/LW7ZnhWvwwUaksE6E4kOAy7YFZPwX?= =?us-ascii?Q?NGpo8/DmWUIWTtTxjo+eR7aHx/B1WnCQWwnoT5WiLPiq7Tc/jbf+nEc6pKHC?= =?us-ascii?Q?pNLmHspGyMSFQvRjxeTxNx0iwAt75mqxLb9CABzhvXQFQar51KYD/Fc4QzgV?= =?us-ascii?Q?mN2QQAZ9Sk/ZlWvkx7LOrVe2mdJH/ieGn1yjfTVmCO9hqNtXfIyKOUOZc18Z?= =?us-ascii?Q?i2KE6Ta0P3Ytyoms+j+03O6jsOhjsadwwuu8h0/5KgPpG+ERi7dpXTbEV+3H?= =?us-ascii?Q?1dIVI+nthDrJ/iZl/al8SY4Tlp+5PrKc/ywOT3srFbr9plRVhBnz+ozdv59j?= =?us-ascii?Q?jjYfQ5dkajcyBMUqlCB8rym7fL1ZxiIEwEDaA/Dtz7IkSxEniYM+BSs5sjnc?= =?us-ascii?Q?Jabad5jBT5qmo9Wo/cKzAlf/R4uphztQXcrZ/KMv3xkB3hxjDvaj7A=3D=3D?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230040)(366016)(1800799024)(376014)(8096899003)(13003099007)(38070700021);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?XG/1uyhhM/THP/+nOZzVrRn+r3xgIuV9a/PelgyeO+M8/4H8tTokSqxhkzoa?= =?us-ascii?Q?unMundqlxx7Mnn2q7LyvdWQhWlDNrStDOoX5Lomsu47ES0L0W+LILKZYee0v?= =?us-ascii?Q?Q1MpRkej07maqxY8pPn/+AJGKY9A8hawaVi8sCuv0X8HdtIYi1kTbQioP2hg?= =?us-ascii?Q?3NCIApxF1Nji/kYF0uqX9p+GTQuDefJgb6P0E5PszESnb0JtAAa0bC5jKCaQ?= =?us-ascii?Q?mfIVy7oacXgI+gCMLGQXYaNMUkn5SnEcL59D+uqut72riX6IzgLqL1Y+Z/mx?= =?us-ascii?Q?EbVKlitgsk5qiOnOCETCrycu5hziIJTHwR9JIH3KEQ2+Xi++POc6kqLLLF6w?= =?us-ascii?Q?gwy+VUrjWLRNihh/GKdLCB/db1B6BdJYugZ2moILkAjZyXUZvoGNo2m9JWXo?= =?us-ascii?Q?WREN118kXXxICUf6Q2jWOw/D8A/HnMEJe0OzBFbIvrpqTAjwN7vdUbDhwwPb?= =?us-ascii?Q?/0S+nypLBXtP7Vj+a99okycMtM9MJV6g6CjouMZDeoIPZClYnq5D2T23XRQu?= =?us-ascii?Q?k+tP6xyTUWBWWg1bCxaAGOzLmOv6ccJ42X7iNvrg4Lwmup3AoRuUwWBrN4fq?= =?us-ascii?Q?TRywU9RtGMMcQF1ElTlroJkzVu5nEozMcLWPbl5pKJJbEz8uS8lIyOYJ9OIg?= =?us-ascii?Q?7b1w2YR80R/wAm1MCtVNLI21tcO7wOU7wwqikxpRAFuzynz2JFVh9bn7bClm?= =?us-ascii?Q?FqA271jPwAKXeZYVXhUC2LzrU+COlNCB1Z4FZHg1HQipogTqBofbAj3lVjSk?= =?us-ascii?Q?LYJijDtDYw0ADLd6gNpHrI34d7lqQGslPrcyCEbrgn7ZTRFbwRlcY26C5rMM?= =?us-ascii?Q?+NpQYDrByZoNX/Zn03RzKAO3jEGiBi6eDBMCx4Z5yAylfGMtchJZGdj9HxrI?= =?us-ascii?Q?b2da15wrQI4TMZ47INRJG6I0NJJIHq+NAX7Rm5UvpmVfoicfEAxkHyAX4V8T?= =?us-ascii?Q?pcKSwiS6Zb2dyImURXVvxyrr+9knJQeQIHOWSuVfNB8t1QQgFhDCu4YB/NB6?= =?us-ascii?Q?+hB0+kSK14nk6ZI7EGxyHzJcu2/k4jxrEgvjKpXu/YF5qazSV3Qjjn2ryJNP?= =?us-ascii?Q?tq9KPsdu4szeeqjmSnbg/JHRlfOja5nci8vmCNNg1DKmyw6B9WWrckGugl90?= =?us-ascii?Q?ZVJd50ScVx6bC4N7esFn/3MVGNV/rTD5pnOxwPklsuBN8hI0I8CD5Bg6mqnN?= =?us-ascii?Q?UNCHGqCkUURK4CqR4ZSRfXyUvBLF0SFCsiQVTseuWKdW3RTPfmctkiFZxCS1?= =?us-ascii?Q?YqBSd4Xtko77AKSwqFIV5Ev2nGDPjpw9JAd0oB3XkeLryKgUpxgmRI5PNspe?= =?us-ascii?Q?H7VdbFclHjul2hfRzcijfYn1UcTuXzxCiDA9eb7/sVdmEzvR7l8ll6AfN9yY?= =?us-ascii?Q?SnyJndHkVNfwh6yTHhu30vGcYyhS48p421mHB/EJpsJyBYibwYR9sbPREFvT?= =?us-ascii?Q?LBfB8eF6ncBwnDguvt89UGTAuF8AsOZVdLlnucv5nwAFI3lA/UIQHWBwpPSA?= =?us-ascii?Q?G8ocqI5hPKk3lArOen2p3GQFlTp8vehwiQvDDJgit0BMcPSUKkNAJBCOmfB+?= =?us-ascii?Q?VO8mVTMElqNpQL3/fS4Lyd9Ikx9F0WDPXawooFdA?= Content-Type: multipart/alternative; boundary="_000_GV0P278MB0099C6559CE186CD3E7CF6FA8B1AAGV0P278MB0099CHEP_" MIME-Version: 1.0 X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-Network-Message-Id: ae804a7f-f1f1-4526-c39a-08de0006c5c2 X-MS-Exchange-CrossTenant-originalarrivaltime: 30 Sep 2025 09:50:22.0329 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 9f489fcc-e452-4509-8234-6f97b42d0117 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: SnXxJ+oC6U9np2N0fHdNk9FdUaodJE2TY9QXAHdq5F/LVSqyDQdgPqVPX38Lf9PgamSosfmQ2ozCa4Ohmx2SVn8+mbHT1yQ6DQa7YstbhiA= X-MS-Exchange-Transport-CrossTenantHeadersStamped: GV0P278MB0877 X-OriginatorOrg: zuerich.ch List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_GV0P278MB0099C6559CE186CD3E7CF6FA8B1AAGV0P278MB0099CHEP_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable We use Crunchy Postgres for Kubernetes (CPK). With CPK 5.8, there will be a= n OS upgrade from UBI8 to UBI9 images. As described in both the Crunchy and= Postgres documentation, conflicts due to collation version mismatches foll= owing an OS upgrade can lead to incorrect queries. https://access.crunchydata.com/documentation/postgres-operator/latest/tutor= ials/cluster-management/update-cluster#changing-base-images https://www.postgresql.org/docs/current/sql-altercollation.html#SQL-ALTERCO= LLATION-NOTES According to the documentation, we plan to perform a "reindex database" and= a "alter database refresh collation version" immediately after the upgrade= . Is there anything else to consider? I'm wondering if this is sufficient. What about materialized views, (text) function-based indexes, and extension= s? Couldn't problems arise here as well? None of the documentation addresse= s this. Am I thinking about this incorrectly? Ideally, I would like to have a precise list of everything that needs to be= considered and done afterwards. Thanks, Markus --_000_GV0P278MB0099C6559CE186CD3E7CF6FA8B1AAGV0P278MB0099CHEP_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

We use Crunchy Postgres for Kubernetes (CPK). With CPK 5.8, = there will be an OS upgrade from UBI8 to UBI9 images. As described in both = the Crunchy and Postgres documentation, conflicts due to collation version mismatches following an OS upgrade can = lead to incorrect queries.

 

https://access.crunchydata.com/documentation/postgres-operator/= latest/tutorials/cluster-management/update-cluster#changing-base-images=

https://www.postgresql.org/docs/cu= rrent/sql-altercollation.html#SQL-ALTERCOLLATION-NOTES

 

According to the documentation, we plan to perform a “= reindex database” and a “alter database refresh collation versi= on” immediately after the upgrade.

 

 

Is there anything else to consider? I'm wondering if this is= sufficient.

 

What about materialized views, (text) function-based indexes= , and extensions? Couldn't problems arise here as well? None of the documen= tation addresses this. Am I thinking about this incorrectly?

 

Ideally, I would like to have a precise list of everything t= hat needs to be considered and done afterwards.

 

 

Thanks, Markus

 

 

--_000_GV0P278MB0099C6559CE186CD3E7CF6FA8B1AAGV0P278MB0099CHEP_--