Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Setting error messages to English not working

Tags:

postgresql

For some reason I cannot change the language of the error messages from PostgreSQL. I have tried to set the language inside the script for creating the schema in at the first line:

SET lc_messages TO 'en_US.UTF-8';

and I also did this, setting LC_MESSAGES to English but it didn't help. Yes, I restarted the service after changing the value.

enter image description here

Nothing seems to work. I am still getting my messages in German.

What else can I try?

like image 758
Stefan Falk Avatar asked Jan 06 '16 18:01

Stefan Falk


People also ask

Why can't I change my Windows display language?

Press Windows + I in order to open Settings and navigate to Time & language followed by Language & region. Next, click on the Add a language button. Now, search for the desired language, click on it and select Next. Check the Set as my Windows display language and select Install.

How do I change display language in Windows?

Change your display language The display language you select changes the default language used by Windows features like Settings and File Explorer. Select Start > Settings > Time & language > Language & region. Choose a language from the Windows display language menu.


1 Answers

if you have permission for access to $datadir\postgresql.conf, you change lc_messages parameter to 'English_United States.1252'.

After you must reload configuration.

My config settings is here;

#These settings are initialized by initdb, but they can be changed.

lc_messages = 'English_United States.1252' # locale for system error message strings

lc_monetary = 'English_United States.1252' # locale for monetary formatting

lc_numeric = 'English_United States.1252' # locale for number formatting

lc_time = 'English_United States.1252' # locale for time formatting

# default configuration for text search

default_text_search_config = 'pg_catalog.english'

like image 120
Hasan BINBOGA Avatar answered Sep 18 '22 15:09

Hasan BINBOGA