Content-Type: multipart/alternative;
 boundary="------------ycYgD41lZAqajMOw4MK05fUw"
Message-ID: <007c172a-0dc7-463b-a67e-cb2f924e0080@osfda.org>
Date: Sat, 30 May 2026 12:25:40 -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 Trixie/Debian 13...
Archived-At: 
 <https://www.postgresql.org/message-id/007c172a-0dc7-463b-a67e-cb2f924e0080%40osfda.org>
Precedence: bulk

This is a multi-part message in MIME format.
--------------ycYgD41lZAqajMOw4MK05fUw
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

/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.../


--------------ycYgD41lZAqajMOw4MK05fUw
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
        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"
        moz-do-not-send="true">https://www.xing.com/profile/Steve_Boriotti</a></p>
    <p><i>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...</i></p>
    <p><br>
    </p>
  </body>
</html>

--------------ycYgD41lZAqajMOw4MK05fUw--