PostgreSQL 10 initdb with locale de-x-icu fails on Windows Server 2012

From: "ROSESOFT S(dot) Hoffmann" <sh(at)rosesoft(dot)de>
To: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: PostgreSQL 10 initdb with locale de-x-icu fails on Windows Server 2012
Date: 2022-07-01 13:07:13
Message-ID: 62310c8c50c74861b80d908310f8a880@rosesoft.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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=de-x-icu --text-search-config=german ..

Error message:
initdb: ungültiger Locale-Name »de-x-icu«

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) there 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ße 100
67061 Ludwigshafen am Rhein
Amtsgericht Ludwigshafen am Rhein / HRA 61632
Komplementärin / Sitz Ellerstadt
ROSESOFT Verwaltungs-GmbH
Amtsgericht Ludwigshafen am Rhein / HRB 65870
Geschäftsführer: Torsten Rosebrock
Tel. 0621 / 63 59 11 - 0
Fax 0621 / 63 59 11 - 99
www.rosesoft.de<http://www.rosesoft.de/>

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2022-07-01 14:21:05 BUG #17535: postgresql-14-orafce 3.22.0-1.pgdg110+1 fails; 3.21.1-1.pgdg110+1 works.
Previous Message Marco Boeringa 2022-07-01 09:49:47 Re: "SELECT COUNT(*) FROM" still causing issues (deadlock) in PostgreSQL 14.3?