How to change language to English for pg_dump and pg_restore onWindows - Mailing list pgsql-admin

From Michal
Subject How to change language to English for pg_dump and pg_restore onWindows
Date
Msg-id 3c62adb1-f1dd-b692-afa1-e77d0679f867@o2.pl
Whole thread Raw
List pgsql-admin
Hi,

I have my local installation of postgresql 9.6 on Windows 10. My system 
language English (all Windows UI is in English) but my locale is set to 
Polish (Polish keyboard, Polish number formats, etc.). This makes 
pg_dump and pg_restore tools use Polish language for all command line 
output messages. But how can I force them to English? Probably changing 
my Windows locale to English would do the trick but I would like switch 
the postgres tools to English independently. Is there a way to do this? 
I've spent a lot of time searching for an answer but I haven't found 
anything.

In my postgresql.conf file I have this line:

lc_messages = 'English_United States.1252'

and it makes messages coming from the database in English (like when 
there is an error in sql query) but this doesn't set the command line 
tools language. I want everything to be in English in the command line, 
how can I do this?

Michal.



pgsql-admin by date:

Previous
From: karan sharma
Date:
Subject: CVE-2018-1058
Next
From: Tyler Collier
Date:
Subject: persist connection info from docker container