Setting error messages to English not working

Question

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.

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

What else can I try?

Answer 1

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'