Necessary actions after an OS upgrade

From: "Zwettler Markus (OIZ)" <markus(dot)zwettler(at)zuerich(dot)ch>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Necessary actions after an OS upgrade
Date: 2025-09-30 09:50:21
Message-ID: GV0P278MB0099C6559CE186CD3E7CF6FA8B1AA@GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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/current/sql-altercollation.html#SQL-ALTERCOLLATION-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 extensions? Couldn't problems arise here as well? None of the documentation addresses 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Troels Arvin 2025-09-30 12:06:24 Windows Server 2025 status?
Previous Message Laurenz Albe 2025-09-30 09:40:45 Re: canceling/terminating statement due to conflict with recovery in Replica/DR instances