| From: | Michal <michal-ok(at)o2(dot)pl> |
|---|---|
| To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | How to change language to English for pg_dump and pg_restore on Windows |
| Date: | 2018-03-17 10:40:26 |
| Message-ID: | 3c62adb1-f1dd-b692-afa1-e77d0679f867@o2.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tyler Collier | 2018-03-18 04:59:11 | persist connection info from docker container |
| Previous Message | karan sharma | 2018-03-16 23:34:26 | CVE-2018-1058 |