public inbox for [email protected]
help / color / mirror / Atom feedFrom: [email protected] <[email protected]>
To: [email protected]
Subject: Collation on Trixie/Debian 13...
Date: Sat, 30 May 2026 12:25:40 -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
/Note that this was sent to this list with a very minor typo in the
subject line ("Trexie"), which might be appreciated by Star Trek fans,
but might also confound searches. To be on the safe side, I have
corrected the subject. List manager: feel free to delete the older
message.../
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 Trixie/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