connect to postgresql database with different locale
I had this issue today. Except my error was for en_GB:
The database was initialized with LC_COLLATE "en_GB.UTF-8", which is not recognized by setlocale().
I solved it with
localedef -f UTF-8 -i en_GB en_GB.UTF-8
You will need to change it depending on your language setting.
Restart the postgresql service after.