public inbox for [email protected]  

help / color / mirror / Atom feed

From: [email protected] <[email protected]>
To: [email protected]
Subject: Collation on Trexie/Debian 13...
Date: Sat, 30 May 2026 06:03:00 -0400
Message-ID: <[email protected]> (raw)

As you might have done like me, you upgraded a server to debian 13 and 
found that the _version_ of a collation you used to use in a database 
(PROBABLY "en_US.utf8", but possibly others...) no longer is supported 
on debian 13. And when you enter a database, you get an error and a hint 
suggesting you need to refresh the collation to a newer version.

I made a */VERY/* simple script that walks the databases of a server and 
updates that collation in each one. I published it at this gitlab repo: 
https://gitlab.com/bitmodeler/pg-upgrade-collation

You can shell to the postgres service account and run the script from 
there (AFTER YOU FIRST INSPECT IT!) You can either chmod +x the .sh 
file, or source it.

You will also find notes there for a *recipe* for a more "industrial 
strength" script, should your needs require that...

Respectfully,
Steve Boriotti
Senior Developer, full stack
https://www.xing.com/profile/Steve_Boriotti

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: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Collation on Trexie/Debian 13...
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox