Content-Type: multipart/alternative;
 boundary="------------CfMHVazTjSFscsaVjStT5CD4"
Message-ID: <147d06e3-0858-40ae-91e9-6f622f29f129@osfda.org>
Date: Sat, 30 May 2026 06:03:00 -0400
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Content-Language: en-US
To: pgsql-pkg-debian@lists.postgresql.org
From: "steve.b@osfda.org" <steve.b@osfda.org>
Subject: Collation on Trexie/Debian 13...
Archived-At: 
 <https://www.postgresql.org/message-id/147d06e3-0858-40ae-91e9-6f622f29f129%40osfda.org>
Precedence: bulk

This is a multi-part message in MIME format.
--------------CfMHVazTjSFscsaVjStT5CD4
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

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


--------------CfMHVazTjSFscsaVjStT5CD4
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE html>
<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>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.</p>
    <p>I made a <b><i>VERY</i></b> simple script that walks the
      databases of a server and updates that collation in each one. I
      published it at this gitlab repo: <a moz-do-not-send="true"
        href="https://gitlab.com/bitmodeler/pg-upgrade-collation"
        class="moz-txt-link-freetext">https://gitlab.com/bitmodeler/pg-upgrade-collation</a></p>
    <p>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.</p>
    <p>You will also find notes there for a <b>recipe</b> for a more
      "industrial strength" script, should your needs require that...</p>
    <p>Respectfully,<br>
      Steve Boriotti<br>
      Senior Developer, full stack<br>
      <a class="moz-txt-link-freetext" href="https://www.xing.com/profile/Steve_Boriotti">https://www.xing.com/profile/Steve_Boriotti</a></p>
    <p><br>
    </p>
  </body>
</html>

--------------CfMHVazTjSFscsaVjStT5CD4--