Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1ex9H9-0000m9-JO
	for pgsql-admin@arkaria.postgresql.org; Sat, 17 Mar 2018 10:41:23 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1ex9H6-00033r-L0
	for pgsql-admin@arkaria.postgresql.org; Sat, 17 Mar 2018 10:41:20 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <michal-ok@o2.pl>)
	id 1ex9H6-00033b-A9
	for pgsql-admin@lists.postgresql.org; Sat, 17 Mar 2018 10:41:20 +0000
Received: from mx-out.tlen.pl ([193.222.135.145])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <michal-ok@o2.pl>)
	id 1ex9H0-0007QJ-1r
	for pgsql-admin@postgresql.org; Sat, 17 Mar 2018 10:41:19 +0000
Received: (wp-smtpd smtp.tlen.pl 19882 invoked from network);
 17 Mar 2018 11:40:29 +0100
Received: from user-94-254-149-126.play-internet.pl (HELO [192.168.1.2])
 (michal-ok@o2.pl@[94.254.149.126])
          (envelope-sender <michal-ok@o2.pl>)
          by smtp.tlen.pl (WP-SMTPD) with SMTP
          for <pgsql-admin@postgresql.org>; 17 Mar 2018 11:40:29 +0100
To: pgsql-admin <pgsql-admin@postgresql.org>
From: Michal <michal-ok@o2.pl>
Subject: How to change language to English for pg_dump and pg_restore on
 Windows
Message-ID: <3c62adb1-f1dd-b692-afa1-e77d0679f867@o2.pl>
Date: Sat, 17 Mar 2018 11:40:26 +0100
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101
 Firefox/52.0 SeaMonkey/2.49.2
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Content-Transfer-Encoding: 7bit
X-WP-MailID: 30bc37640ff702a0743ecfe828e31f3b
X-WP-AV: skaner antywirusowy Poczty o2
X-WP-SPAM: NO 000000A [AQPk]                               
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk

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.