#collations — Public Fediverse posts

Just wanted to upgrade a #Postgres 13 database to Postgres 16 using the awesome tianon/postgres-upgrade #Docker image and spent the evening learning about Postgres #collations and glibc (#Debian-based containers) vs. musl (#Alpine-based ones) #incompatibilities.

Here’s a nice writeup from Daniel Nachtrub:
https://blog.nuvotex.de/postgres-2/

And here’s his alternative way:
https://blog.nuvotex.de/postgres/

I, however, just dumped everything as it wasn’t that much. Created a new 16 database and reimported the dump. But that was after several hours reading through various GitHub issues, forum comments and blog posts.