From: Michal <michal-ok@o2.pl>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: How to change language to English for pg_dump and pg_restore on Windows
Date: Sat, 17 Mar 2018 11:40:26 +0100
Message-ID: <3c62adb1-f1dd-b692-afa1-e77d0679f867@o2.pl> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: michal-ok@o2.pl
Subject: Re: How to change language to English for pg_dump and pg_restore on Windows
In-Reply-To: <3c62adb1-f1dd-b692-afa1-e77d0679f867@o2.pl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox