pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Alexey Shishkin <alexey.shishkin@enterprisedb.com>
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: OS system version upgrade (glibc / libicu version change)
Date: Mon, 16 Nov 2026 16:21:01 +0100
Message-ID: <33876ecbca9932f1758b048ae9af9107bbeef55e.camel@cybertec.at> (raw)
In-Reply-To: <CALVdoE6nCtfp0Omde=oLM2VJoVNxCnZbkNXLN-kMw06ZjTuDXQ@mail.gmail.com>
References: <177002326159.803.1983703962002247846@wrigleys.postgresql.org>
	<CALVdoE78O7Ksm+1ySLCv=Bs_-O5hHyQfXHEMaNC3dPP1t2WSQw@mail.gmail.com>
	<CALVdoE6syAWYPKCWJ7o4Vfaapw5Q316qjSx32QLmuyA+yrXEMw@mail.gmail.com>
	<225d52b51ed9a911ced2f8e6c00e089a1ce50f19.camel@cybertec.at>
	<CALVdoE5ne1EEvU29Y9_=rbiYb+M5xRbVuQ=PEZs33b6ze1+m8A@mail.gmail.com>
	<b12f6d6c2c6ff9bb6a7f75a53a5d0f3adb68de67.camel@cybertec.at>
	<CALVdoE6nCtfp0Omde=oLM2VJoVNxCnZbkNXLN-kMw06ZjTuDXQ@mail.gmail.com>

On Mon, 2026-11-16 at 13:00 +0100, Alexey Shishkin wrote:
> We can grab the text for problem description from https://wiki.postgresql.org/wiki/Locale_data_changes
> 
> Regarding finding the affected indexes, ready SQL queries for various PG versions are
> listed in the EDB KBA written by Peter Eisentraut.
> Or/and we can use amcheck as you suggested.
> 
> Also we should mention that not only indexes can be affected by locale changes, but other objects
> like range-partitioned tables.
> 
> One more thing to stress is that locale changes can happen during the lifecycle of the same major
> OS version, so any OS updates need to be verified for glibc changes.
> 
> Pls. let me know how you would like to proceed.

Sure.  You write a documentation patch, submit it to this list, and I am happy to
review it.

I suggest that the patch should not be too big.  Code samples and instructions for repair
would be too much in my opinion.  I'd say that the objective is to alert the reader to
the problem and tell him or her to rebuild affected indexes with REINDEX, and to use
amcheck to check if indexes are ok.

Yours,
Laurenz Albe






view thread (8+ messages)

Message-ID: <33876ecbca9932f1758b048ae9af9107bbeef55e.camel@cybertec.at>
Permalink:  ../33876ecbca9932f1758b048ae9af9107bbeef55e.camel@cybertec.at/
Also on:    postgresql.org/message-id/33876ecbca9932f1758b048ae9af9107bbeef55e.camel@cybertec.at

 · 

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-docs@postgresql.org
  Cc: laurenz.albe@cybertec.at, alexey.shishkin@enterprisedb.com, pgsql-docs@lists.postgresql.org
  Subject: Re: OS system version upgrade (glibc / libicu version change)
  In-Reply-To: <33876ecbca9932f1758b048ae9af9107bbeef55e.camel@cybertec.at>

* 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