Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1jE7Y0-0004J4-JF for pgsql-bugs@arkaria.postgresql.org; Tue, 17 Mar 2020 08:26:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jE7Xz-0005br-55 for pgsql-bugs@arkaria.postgresql.org; Tue, 17 Mar 2020 08:25:59 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1jE7Xy-0005Xu-DQ for pgsql-bugs@lists.postgresql.org; Tue, 17 Mar 2020 08:25:58 +0000 Received: from adaobpv04.800onemail.com ([66.150.217.78]) by makus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_128_CBC_SHA1:128) (Exim 4.92) (envelope-from ) id 1jE7Xu-0000o2-Ek for pgsql-bugs@lists.postgresql.org; Tue, 17 Mar 2020 08:25:56 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=800onemail.com; s=efw; h=MIME-Version:Content-Type:In-Reply-To:References:Message-ID:Date:Subject:CC:To:From; bh=utB51JRcU2YjMqM8oXfD6xE0z/4dEJY0KN0UYKxjo3A=; b=bncjMVqasgooVCdWBu8Vct+lVlWQ6mVZVycrpAHw0AwYcZOOUIL2huh4344IXHcNGV+ydDli6Qxt6p86B4q3CHvDpZNXrmd8WTyMxJ/1OmSAlhGRybQQImj87aCMVXiZwgx0XnRtPX77ssSI3o/Fxo/9VPm05slJvH6ZHWGUOUo=; Received: from lb_ad_efw_obp.800onemail.com ([10.6.80.28] helo=adaobrv03.800onemail.com) by adaobpv04.800onemail.com with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.82) (envelope-from ) id 1jE7Xs-0002eC-Sf; Tue, 17 Mar 2020 08:25:52 +0000 Received: from cdbobcv01.800onemail.com ([10.6.81.185]) by adaobrv03.800onemail.com (8.14.4/8.14.4/Debian-4.1ubuntu1.1) with ESMTP id 02H8PptN011571 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES128-SHA bits=128 verify=NO); Tue, 17 Mar 2020 08:25:52 GMT DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=800onemail.com; s=efw; h=MIME-Version:Content-Type:In-Reply-To:References:Message-ID:Date:Subject:CC:To:From; bh=utB51JRcU2YjMqM8oXfD6xE0z/4dEJY0KN0UYKxjo3A=; b=bncjMVqasgooVCdWBu8Vct+lVlWQ6mVZVycrpAHw0AwYcZOOUIL2huh4344IXHcNGV+ydDli6Qxt6p86B4q3CHvDpZNXrmd8WTyMxJ/1OmSAlhGRybQQImj87aCMVXiZwgx0XnRtPX77ssSI3o/Fxo/9VPm05slJvH6ZHWGUOUo=; Received: from [10.6.81.204] (helo=CDBMBCP02.corp.zoetis.com) by cdbobcv01.800onemail.com with esmtp (Exim 4.82) (envelope-from ) id 1jE7Xr-0004Rs-IO; Tue, 17 Mar 2020 04:25:51 -0400 Received: from CDBMBCP03.corp.zoetis.com (172.24.10.12) by CDBMBCP02.corp.zoetis.com (172.24.10.11) with Microsoft SMTP Server (TLS) id 15.0.1473.3; Tue, 17 Mar 2020 03:25:50 -0500 Received: from CDBMBCP03.corp.zoetis.com ([172.24.10.12]) by CDBMBCP03.corp.zoetis.com ([172.24.10.12]) with mapi id 15.00.1473.005; Tue, 17 Mar 2020 03:25:50 -0500 From: "Wimmesberger, Simon" To: Fahar Abbas CC: Sandeep Thakkar , "pgsql-bugs@lists.postgresql.org" Subject: AW: BUG #16103: Initdb does not respect country for language Thread-Topic: BUG #16103: Initdb does not respect country for language Thread-Index: AQHVmekZEVG2FWOFxEuI0VNDacYcWKgMzqmwgECtk4CAAABkgP//uJax Date: Tue, 17 Mar 2020 08:25:50 +0000 Message-ID: <1584433547490.82121@zoetis.com> References: <16103-229450f8a1771238@postgresql.org> , In-Reply-To: Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [172.24.26.6] Content-Type: multipart/alternative; boundary="_000_158443354749082121zoetiscom_" MIME-Version: 1.0 X-CFilter-Loop: Reflected X-CRX_OSR: CRX_OSR-LOW X-Scanned-By: MIMEDefang 2.73 on 10.6.80.235 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_158443354749082121zoetiscom_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, when the system language matches with the language you want to initialize t= he database with everything works correctly (e.g. selecting system language= in the enterprisedb installer). The issue is when you want to initialize t= he database with a specific language which IS NOT the system language. So y= ou have to configure the system with a different system language than what = you later pass to initdb. Best Regards, Simon ________________________________ Von: Fahar Abbas Gesendet: Dienstag, 17. M=E4rz 2020 08:33 An: Wimmesberger, Simon Cc: Sandeep Thakkar; pgsql-bugs@lists.postgresql.org Betreff: Re: BUG #16103: Initdb does not respect country for language NOTICE: This message originates from an external source. ________________________________ C:\Program Files\PostgreSQL\10\bin>psql.exe -U postgres Passwort f=FCr Benutzer postgres: psql (10.12) Warnung: Konsolencodeseite (850) unterscheidet sich von der Windows- Codeseite (1252). 8-Bit-Zeichen funktionieren m=F6glicherweise nic= ht richtig. Einzelheiten finden Sie auf der psql-Handbuchseite unter =BBNotes for Windows users=AB. Geben Sie =BBhelp=AB f=FCr Hilfe ein. postgres=3D# show lc_messages; lc_messages --------------------- German_Austria.1252 (1 Zeile) postgres=3D# On Tue, Mar 17, 2020 at 12:31 PM Fahar Abbas > wrote: Hi, I am getting following when we do initdb with system locale is german Austr= ia: C:\Program Files\PostgreSQL\10\bin>initdb.exe -D C:\master Die Dateien, die zu diesem Datenbanksystem geh=F6ren, werden dem Benutzer =BBFahar Abbas=AB geh=F6ren. Diesem Benutzer muss auch der Serverprozess ge= h=F6ren. Der Datenbankcluster wird mit der Locale =BBGerman_Austria.1252=AB initiali= siert wer den. Die Standarddatenbankkodierung wurde entsprechend auf =BBWIN1252=AB gesetzt= . Die Standardtextsuchekonfiguration wird auf =BBgerman=AB gesetzt. Datenseitenpr=FCfsummen sind ausgeschaltet. erzeuge Verzeichnis C:/master ... ok erzeuge Unterverzeichnisse ... ok w=E4hle Vorgabewert f=FCr max_connections ... 100 w=E4hle Vorgabewert f=FCr shared_buffers ... 128MB w=E4hle Vorgabewert f=FCr timezone .. Asia/Karachi w=E4hle Implementierung von dynamischem Shared Memory ... windows erzeuge Konfigurationsdateien ... ok f=FChre Bootstrap-Skript aus ... ok f=FChre Post-Bootstrap-Initialisierung durch ... ok synchronisiere Daten auf Festplatte ... ok WARNUNG: Authentifizierung f=FCr lokale Verbindungen auf =BBtrust=AB gesetz= t Sie k=F6nnen dies =E4ndern, indem Sie pg_hba.conf bearbeiten oder beim n=E4chsten Aufruf von initdb die Option -A, oder --auth-local und --auth-host, verwenden. Erfolg. Sie k=F6nnen den Datenbankserver jetzt mit pg_ctl -D ^"C^:^\master^" -l logdatei start starten. C:\Program Files\PostgreSQL\10\bin> On Wed, Feb 5, 2020 at 1:58 PM Wimmesberger, Simon > wrote: Any updates regarding this issue? This issue unfornutatly makes our work mo= re unconfortable than it should be. ________________________________ Thanks for reporting, We will look into it. On Fri, Nov 8, 2019 at 5:45 PM PG Bug reporting form > wrote: The following bug has been logged on the website: Bug reference: 16103 Logged by: Simon Wimmesberger Email address: simon.wimmesberger@zoetis.com PostgreSQL version: 10.10 Operating system: Windows Server 2008 R2 Description: When using the enterprisedb installer on Windows and I select the language "German, Austria" it is passed to initdb with "German,Austria". When I look at the database property of the initialized database the "collation" and "character type" is set to "German_Germany.1252" instead of the expected value of "German_Austria.1252". When I call initdb directly with "German_Austria.1252" it works as expected. In our usecase we really want t= o use the enterprisedb installer therefore selecting the language should work as expected. I have also tried to select "Englisch, Ireland" in the installer it is agai= n passed to initdb as "English,Ireland" but the database is then wrongly initialized with "English_United States.1252" - so it seems like that the installer somehow passes the Language/Country wrong the initdb executable o= r initdb does not respect the country when passed in this format. -- Sandeep Thakkar -- Fahar Abbas QMG [https://drive.google.com/a/enterprisedb.com/uc?id=3D0B3A76rNrVTJVNkdxY3hCT= U1KUEk&export=3Ddownload] EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: live:fahar.abbas Website: www.enterprisedb.com -- Fahar Abbas QMG [https://drive.google.com/a/enterprisedb.com/uc?id=3D0B3A76rNrVTJVNkdxY3hCT= U1KUEk&export=3Ddownload] EnterpriseDB Corporation Phone Office: +92-51-835-8874 Phone Direct: +92-51-8466803 Mobile: +92-333-5409707 Skype ID: live:fahar.abbas Website: www.enterprisedb.com --_000_158443354749082121zoetiscom_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

when the system language matches with the language you want to initializ= e the database with everything works correctly (e.g. selecting system langu= age in the enterprisedb installer). The issue is when you want to initializ= e the database with a specific language which IS NOT the system language. So you have to configure the s= ystem with a different system language than what you later pass to initdb.<= br>


Best Regards,

Simon



Von: Fahar Abbas <fahar.= abbas@enterprisedb.com>
Gesendet: Dienstag, 17. M=E4rz 2020 08:33
An: Wimmesberger, Simon
Cc: Sandeep Thakkar; pgsql-bugs@lists.postgresql.org
Betreff: Re: BUG #16103: Initdb does not respect country for languag= e
 

NOTICE: This mes= sage originates from an external source.



C:\Program Files\PostgreSQL\10\bin>psql.exe -U postgres
Passwort f=FCr Benutzer postgres:
psql (10.12)
Warnung: Konsolencodeseite (850) unterscheidet sich von der Windows-
         Codeseite (1252). 8-Bit-Zeichen funktioni= eren m=F6glicherweise nicht
         richtig. Einzelheiten finden Sie auf der = psql-Handbuchseite unter
         =BBNotes for Windows users=AB.
Geben Sie =BBhelp=AB f=FCr Hilfe ein.

postgres=3D# show lc_messages;
     lc_messages
---------------------
 German_Austria.1252
(1 Zeile)


postgres=3D#

On Tue, Mar 17, 2020 at 12:31 PM Faha= r Abbas <fahar.abbas@ent= erprisedb.com> wrote:
Hi,

I am getting following when we do initdb with system locale is german = Austria:

C:\Program Files\PostgreSQL\10\bin>initdb.exe -D C:\master
Die Dateien, die zu diesem Datenbanksystem geh=F6ren, werden dem Benutzer =BBFahar Abbas=AB geh=F6ren. Diesem Benutzer muss auch der Serverprozess ge= h=F6ren.

Der Datenbankcluster wird mit der Locale =BBGerman_Austria.1252=AB initiali= siert wer
den.
Die Standarddatenbankkodierung wurde entsprechend auf =BBWIN1252=AB gesetzt= .
Die Standardtextsuchekonfiguration wird auf =BBgerman=AB gesetzt.

Datenseitenpr=FCfsummen sind ausgeschaltet.

erzeuge Verzeichnis C:/master ... ok
erzeuge Unterverzeichnisse ... ok
w=E4hle Vorgabewert f=FCr max_connections ... 100
w=E4hle Vorgabewert f=FCr shared_buffers ... 128MB
w=E4hle Vorgabewert f=FCr timezone .. Asia/Karachi
w=E4hle Implementierung von dynamischem Shared Memory ... windows
erzeuge Konfigurationsdateien ... ok
f=FChre Bootstrap-Skript aus ... ok
f=FChre Post-Bootstrap-Initialisierung durch ... ok
synchronisiere Daten auf Festplatte ... ok

WARNUNG: Authentifizierung f=FCr lokale Verbindungen auf =BBtrust=AB gesetz= t
Sie k=F6nnen dies =E4ndern, indem Sie pg_hba.conf bearbeiten oder beim
n=E4chsten Aufruf von initdb die Option -A, oder --auth-local und
--auth-host, verwenden.

Erfolg. Sie k=F6nnen den Datenbankserver jetzt mit

    pg_ctl -D ^"C^:^\master^" -l logdatei start

starten.


C:\Program Files\PostgreSQL\10\bin>




On Wed, Feb 5, 2020 at 1:58 PM Wimmes= berger, Simon <simon.wimmesberger@zoetis.com> wrote:

Any updates regarding this issue? This issue unfornu= tatly makes our work more unconfortable than it should be.

 


Thanks for reporting, We will look into it.<= /u>

 

On Fri, Nov 8, 2019 at 5:45 PM PG Bug reporting form= <noreply@po= stgresql.org> wrote:

The following bug has b= een logged on the website:

Bug reference:      16103
Logged by:          Simon Wimmesberger
Email address:      simon.wimmesberger@zoetis.com
PostgreSQL version: 10.10
Operating system:   Windows Server 2008 R2
Description:       

When using the enterprisedb installer on Windows and I select the language<= br> "German, Austria" it is passed to initdb with "German,Austri= a". When I look
at the database property of the initialized database the "collation&qu= ot; and
"character type" is set to "German_Germany.1252" instea= d of the expected
value of "German_Austria.1252". When I call initdb directly with<= br> "German_Austria.1252" it works as expected. In our usecase we rea= lly want to
use the enterprisedb installer therefore selecting the language should work=
as expected.

I have also tried to select "Englisch, Ireland" in the installer = it is again
passed to initdb as "English,Ireland" but the database is then wr= ongly
initialized with "English_United States.1252" - so it seems like = that the
installer somehow passes the Language/Country wrong the initdb executable o= r
initdb does not respect the country when passed in this format.


 

--

Sandeep = Thakkar

 



--
Fahar Abbas
QMG
EnterpriseDB Corporation
Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: live:fahar.abbas
Website: www.ente= rprisedb.com


--
Fahar Abbas
QMG
EnterpriseDB Corporation
Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: live:fahar.abbas
Website: www.ente= rprisedb.com
--_000_158443354749082121zoetiscom_--