Hi!

Danny Milosavljevic <dan...@scratchpost.org> skribis:

> I read the docs you pointed me to - however, previously this worked fine 
> as-is. Also, I have a database that is inaccessible because the locale 
> suddenly (sometimes) doesn't work anymore. It's not like I can change what 
> locale it was created in without a time machine :)
>
> $ psql -U postgres template1
> psql: FATAL:  database locale is incompatible with operating system
> DETAIL:  The database was initialized with LC_COLLATE "en_US.UTF-8",  which 
> is not recognized by setlocale().
> HINT:  Recreate the database with another locale or install the missing 
> locale.

What does this return:

  ldd $(which psql) | grep glibc

?

If it says 2.22, then you need to add the 2.22 locale data to your OS,
as per
<https://www.gnu.org/software/guix/manual/html_node/Locales.html#Locale-Data-Compatibility-Considerations>.

HTH,
Ludo’.

Reply via email to