Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1o7H6A-0004Yk-Dt for pgsql-bugs@arkaria.postgresql.org; Fri, 01 Jul 2022 13:54:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1o7H69-0001fN-6W for pgsql-bugs@arkaria.postgresql.org; Fri, 01 Jul 2022 13:54:17 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1o7GMm-0004Xe-W5 for pgsql-bugs@lists.postgresql.org; Fri, 01 Jul 2022 13:07:25 +0000 Received: from ma04-relay.lansolnet.com ([176.95.46.38]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1o7GMh-00047v-L8 for pgsql-bugs@lists.postgresql.org; Fri, 01 Jul 2022 13:07:23 +0000 Received: from unknown ([192.168.8.230]) by ma04-relay.lansolnet.com; Fri, 01 Jul 2022 15:07:15 +0200 Received: from MBX200C.cloud4partner.com (192.168.8.232) by MBX200A.cloud4partner.com (192.168.8.230) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.669.32; Fri, 1 Jul 2022 15:07:14 +0200 Received: from MBX200A.cloud4partner.com (192.168.8.230) by MBX200C.cloud4partner.com (192.168.8.232) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.669.32; Fri, 1 Jul 2022 15:07:13 +0200 Received: from MBX200A.cloud4partner.com ([fe80::a590:508d:224a:188c]) by MBX200A.cloud4partner.com ([fe80::a590:508d:224a:188c%18]) with mapi id 15.01.0669.032; Fri, 1 Jul 2022 15:07:13 +0200 From: "ROSESOFT S. Hoffmann" To: "pgsql-bugs@lists.postgresql.org" Subject: PostgreSQL 10 initdb with locale de-x-icu fails on Windows Server 2012 Thread-Topic: PostgreSQL 10 initdb with locale de-x-icu fails on Windows Server 2012 Thread-Index: AdiNSBqQiKmeE0k7RqWLpOkrw/Yjcg== Date: Fri, 1 Jul 2022 13:07:13 +0000 Message-ID: <62310c8c50c74861b80d908310f8a880@rosesoft.de> Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [192.168.8.240] Content-Type: multipart/alternative; boundary="_000_62310c8c50c74861b80d908310f8a880rosesoftde_" MIME-Version: 1.0 X-cloud-security-sender: sh@rosesoft.de X-cloud-security-recipient: pgsql-bugs@lists.postgresql.org X-cloud-security-Virusscan: CLEAN X-cloud-security-disclaimer: This E-Mail was scanned by E-Mailservice on ma04-relay.lansolnet.com with 2A5F0B800FA X-cloud-security-connect: unknown[192.168.8.230], TLS=1, IP=192.168.8.230 X-cloud-security: scantime:.3514 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_62310c8c50c74861b80d908310f8a880rosesoftde_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, here my problem in details: Software: Freshly installed Windows Server 2012 R2 (german) Microsoft Visual C++ 2013 Redistributable (x86) - 12.0.40664.0 Microsoft Visual C++ 2015-2022 Redistributable (x86) - 14.31.31103 PostgreSQL 10.20 32-bit binaries from https://www.enterprisedb.com/download= -postgresql-binaries Call (excerpt): initdb.exe .. -E UTF8 --locale=3Dde-x-icu --text-search-config=3Dgerman .. Error message: initdb: ung=FCltiger Locale-Name =BBde-x-icu=AB According to https://www.postgresql.org/download/windows/ PostgreSQL 10 is= supported by Windows Server 2012. The collation 'de-x-icu' is contained in table "pg_collation". With default-locale "German_Germany.1252" initdb succeeds, but that locale = is not allowed in our environment! On all newer Windows-OS (Windows Server 2016/2019/2022, Windows 10/11) ther= e is no problem. Is this a PostgreSQL Bug? Do you know a work-around? Is a Windows-Patch or a special software necessary to use ICU? Best Regards, Stefan Hoffmann. ________________________________ ROSESOFT GmbH & Co. KG Mundenheimer Stra=DFe 100 67061 Ludwigshafen am Rhein Amtsgericht Ludwigshafen am Rhein / HRA 61632 Komplement=E4rin / Sitz Ellerstadt ROSESOFT Verwaltungs-GmbH Amtsgericht Ludwigshafen am Rhein / HRB 65870 Gesch=E4ftsf=FChrer: Torsten Rosebrock Tel. 0621 / 63 59 11 - 0 Fax 0621 / 63 59 11 - 99 www.rosesoft.de --_000_62310c8c50c74861b80d908310f8a880rosesoftde_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hello,

 

here my problem in details:

 

Software:

Freshly installed Windows Server 2012 R2 (german)

Microsoft Visual C++ 2013 Redistributable (x= 86) - 12.0.40664.0

Microsoft Visual C++ 2015-2022 Redistributab= le (x86) - 14.31.31103

PostgreSQL 10.20 32-bit binaries from https://www.enterprisedb.com/download-postgresql-binaries

 

Call (excerpt):

initdb.exe .. -E UTF8 --locale=3Dde-x-icu --text-sea= rch-config=3Dgerman ..

 

Error message:

initdb: ung=FCltiger Locale-Name =BBde-x-icu=AB=

 

According to  https://www.postgresql.org/download/windows/ Po= stgreSQL 10 is supported by Windows Server 2012.

The collation 'de-x-icu' is contained in table ̶= 2;pg_collation“.

With default-locale "German_Germany.1252" = initdb succeeds, but that locale is not allowed in our environment!

On all newer Windows-OS (Windows Server 2016/2019/20= 22, Windows 10/11) there is no problem.

 

Is this a PostgreSQL Bug?

Do you know a work-around?

Is a Windows-Patch or a special software necessary t= o use ICU?

 

Best Regards,

Stefan Hoffmann.

 

ROSESOFT GmbH & Co. KG
Mundenheimer Stra=DFe 100
67061 Ludwigshafen am Rhein
Amtsgericht Ludwigshafen am Rhein / HRA 61632
Komplement=E4rin / Sitz Ellerstadt
ROSESOFT Verwaltungs-GmbH
Amtsgericht Ludwigshafen am Rhein / HRB 65870
Gesch=E4ftsf=FChrer: Torsten Rosebrock
Tel. 0621 / 63 59 11 - 0
Fax 0621 / 63 59 11 - 99
www.rosesoft= .de

 

--_000_62310c8c50c74861b80d908310f8a880rosesoftde_--