pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #17536: PostgreSQL 10 initdb with locale de-x-icu fails on Windows Server 2012
2+ messages / 2 participants
[nested] [flat]

* BUG #17536: PostgreSQL 10 initdb with locale de-x-icu fails on Windows Server 2012
@ 2022-07-01 14:36 PG Bug reporting form <noreply@postgresql.org>
  2022-07-01 14:48 ` Re: BUG #17536: PostgreSQL 10 initdb with locale de-x-icu fails on Windows Server 2012 Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: PG Bug reporting form @ 2022-07-01 14:36 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: sh@rosesoft.de

The following bug has been logged on the website:

Bug reference:      17536
Logged by:          Stefan Hoffmann
Email address:      sh@rosesoft.de
PostgreSQL version: 10.20
Operating system:   Windows Server 2012 R2
Description:        

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?



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: BUG #17536: PostgreSQL 10 initdb with locale de-x-icu fails on Windows Server 2012
  2022-07-01 14:36 BUG #17536: PostgreSQL 10 initdb with locale de-x-icu fails on Windows Server 2012 PG Bug reporting form <noreply@postgresql.org>
@ 2022-07-01 14:48 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2022-07-01 14:48 UTC (permalink / raw)
  To: sh@rosesoft.de; +Cc: pgsql-bugs@lists.postgresql.org

PG Bug reporting form <noreply@postgresql.org> writes:
> Call (excerpt):
> initdb.exe .. -E UTF8 --locale=de-x-icu --text-search-config=german ..

PG v15 is the first to allow ICU locales as database-wide locale
settings, so it's not too surprising that this fails in v10.

			regards, tom lane





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2022-07-01 14:48 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-07-01 14:36 BUG #17536: PostgreSQL 10 initdb with locale de-x-icu fails on Windows Server 2012 PG Bug reporting form <noreply@postgresql.org>
2022-07-01 14:48 ` Tom Lane <tgl@sss.pgh.pa.us>

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