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