Problem: PostgreSQL Complains about Wrong Locale

Knowledge Base Community
, , , ,
#1

Problem

You postgreSQL complains about a missing locale:

OperationalError: FATAL:  Datenbank-Locale ist inkompatibel mit Betriebssystem

DETAIL:  Die Datenbank wurde mit LC_COLLATE »de_AT.UTF-8« initialisiert, was von setlocale() nicht erkannt wird.

Environment

The database originally was installed with “de_AT.UTF-8” which is bot available to the operating system.

Your UCR varaibles are set as shown:

root@ucs:~# ucr search --brief locale

kopano/cfg/admin/default_store_locale: de_AT.UTF-8

locale/default: de_DE.UTF-8:UTF-8

locale: de_DE.UTF-8:UTF-8 en_US.UTF-8:UTF-8

Solution

For some reason the locale package did not get installed properly. Install the package as follwos and the database should run fine from then on.

root@ucs:~# ucr set locale="en_US.UTF-8:UTF-8 de_DE.UTF-8:UTF-8 de_AT.UTF-8:UTF-8"
root@ucs:~# dpkg-reconfigure locales
#2

This topic was automatically closed after 24 hours. New replies are no longer allowed.

Mastodon