More on this. I saw this error today:
database locale is incompatible with operating system
I'm using an LXC container version of Ubuntu 24.04 and I imported the database by literally moving /var/lib/postgresql from the old server to the new one.
The old server was on Ubuntu 22.04 and near as I can tell the locale was en_US.UTF-8 or something like that
@gardiner_bryant If you have an sql dump, you might be able to see the expected locales.
Then you can compare with installed locales:
locale -a
If you don't see an expected list of locales, you might be able to use "locale-gen [list of locales]" and "dpkg-reconfigure locales" to get things working.
I would expect to see at least this list:
C
C.utf8
en_US.utf8
POSIX
Since peertube is based in France, perhaps there would need to be fr_FR.utf8 as well? But that seems unlikely.