Change language of the PostgreSQL server error messages to English

Question

My MS Windows system is French version. I've recently installed PostgreSQL server. Although pgAdmin is in English I get French messages in the PostgreSQL psql command line.

Answer 1

If you have permissions for access to $datadir\postgresql.conf change lc_messages parameter to English_United States.1252. You need to reload configuration (do restart of the server).

My config is:

# 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'