PostgreSQL 12 installation fails because locale name contained non-english characters

From: "Skjalg A(dot) Skagen" <skjalg(dot)skagen(at)pm(dot)me>
To: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: PostgreSQL 12 installation fails because locale name contained non-english characters
Date: 2019-10-24 11:06:01
Message-ID: _Rkh_eJ7FKRUdGms9GAub53-5uvodq4uvTIrbgsTQ13wwHJwj7ofpHXUUtT0JMQft6oXI68hqJTx1bLIaejbuTyu29xeTGrSBCCgl40U1GA=@pm.me
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Hi,

I tried to install PostgreSQL 12 with the "Norwegian Bokmål, Norway" locale in hope that it would, among other things, provide proper support for Norwegian characters out-of-the-box.

But initcluster.vbs appear to fail during post-install because the locale name contains a Norwegian character that is being mishandled (full log in attached zip file):

initdb: error: invalid locale name "NorwegianBokm†l,Norway"

Called Die(Failed to initialise the database cluster with initdb)...
Failed to initialise the database cluster with initdb

Script stderr:
Program ended with an error exit code

Error running cscript //NoLogo "C:\Program Files\PostgreSQL\12/installer/server/initcluster.vbs" "NT AUTHORITY\NetworkService" "postgres" "****" "C:\temp/postgresql_installer_c24b846fc9" "C:\Program Files\PostgreSQL\12" "C:\Program Files\PostgreSQL\12\data" 5432 "NorwegianBokmål,Norway" 0: Program ended with an error exit code
Problem running post-install step. Installation may not complete correctly
The database cluster initialisation failed.
Executing icacls "C:\temp/postgresql_installer_baa40bb6af" /inheritance:r
Script exit code: 0

The letter "å" has been turned into a "†" (cross).

I tried to uninstall, and reinstall with the "Norwegian Bokmål, Norway" locale once more, but with the same error. In the end, I managed to reinstall PostgreSQL 12 without any error by selecting the "Default" locale.

Best regards,
Skjalg

Attachment Content-Type Size
install-postgresql.zip application/x-zip-compressed 128.5 KB

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2019-10-24 15:12:16 BUG #16076: JIT causes huge delays in a complex query. jit=off solves it.
Previous Message Arseny Sher 2019-10-24 09:59:30 Re: ERROR: subtransaction logged without previous top-level txn record

Browse pgsql-hackers by date

  From Date Subject
Next Message Asif Rehman 2019-10-24 11:24:41 Re: WIP/PoC for parallel backup
Previous Message Dilip Kumar 2019-10-24 11:03:31 Re: [HACKERS] Block level parallel vacuum