Silent installation issue on FR language System - postgresql-17.0-1 Application

[Ujola]

Hello,

we have created the package of PostgreSQL 17.0-1 Application.
We have used the command line parameter for installation is this: “postgresql-17.0-1-windows-x64.exe--mode unattended --unattendedmodeui none --optionfile C:\Temp\Install”
This is working in English language machine, but it is failing in French language machine and throwing below error:

"There has been an error
error while writing file C:\windows\Temp\postgresql_installer_8b85d458af\temp_check_comspec.bat"

we tried giving permission to this folder, then we have used “--installer-launage fr” parameter “--locale fr” parameters but still not working.
I have attached the log here.

Log started 11/14/2024 at 09:04:33
Preferred installation mode : unattended
Trying to init installer in mode unattended
Mode unattended successfully initialized
Setting variable whoami from C:\WINDOWS\System32\whoami
Script exit code: 0

Script output:
autorite nt\système

Script stderr:

Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-17 Base Directory. Setting variable iBaseDirectory to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-17 Branding. Setting variable iBranding to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-17 Version. Setting variable brandingVer to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-17 Shortcuts. Setting variable iShortcut to empty value
[09:04:35] Using branding: PostgreSQL 17
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-17 SB_Version. Setting variable sb_version to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-17 pgAdmin_Version. Setting variable pgadmin_version to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-17 CLT_Version. Setting variable clt_version to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-17 Data Directory. Setting variable server_data_dir to empty value
Erreur d'écriture du fichier C:/Windows/Temp/postgresql_installer_ee9259ae9d/temp_check_comspec.bat
Exiting with code 1

Please assist to resolve the issue asap.

[sandeep-edb]

Hi,
Yes it is a known issue for languages other than English when the names carry non-ASCII characters. We are working towards a fix, but there is no ETA unfortunately.

[Ujola]

Thank you for the information.

[sandeep-edb]

I made a small change in the installer to allow the non-ascii characters in the system username and uploaded the "test/snapshot" (not for production) installer postgresql-17.2-0.0snapshot12069192100.994.1.10c136e.1-windows-x64 to https://enterprisedb.sharefile.com/f/fo423619-ac6b-4868-ac4c-b2e3def6e3b0

If you could try installing and confirm how it went? If you're not able to access then please let me know your email and I'll provide the access

Please note there is no handling of non-english service account names included yet. Also, during installation, the Info dialogues will appear to show the name and the SID of the user running the installer. Please confirm if it's correct.

If you have any questions please let me know.

[BlasterCegep]

Same issue here when deploying with MECM (SCCM). Windows 11 Education (french). It was working with postgresql-15.3-1-windows-x64 before but I needed to update postgresql to 15.10 because of security issue. It's working when i'm using an admin account but not when using MECM to deploy which install postgresql with system account. I'm trying to deploy the update on 2 computers labs with an unattend installation.

[BlasterCegep]

I made a small change in the installer to allow the non-ascii characters in the system username and uploaded the "test/snapshot" (not for production) installer postgresql-17.2-0.0snapshot12069192100.994.1.10c136e.1-windows-x64 to https://enterprisedb.sharefile.com/f/fo423619-ac6b-4868-ac4c-b2e3def6e3b0

If you could try installing and confirm how it went? If you're not able to access then please let me know your email and I'll provide the access

Please note there is no handling of non-english service account names included yet. Also, during installation, the Info dialogues will appear to show the name and the SID of the user running the installer. Please confirm if it's correct.

If you have any questions please let me know.

Anything you can do to help me out with the postgresql-15.10-1-windows-x64 installer ?

Thank you ! :)

[sandeep-edb]

@BlasterCegep II can include fixes in Pg15.10 and generate a test installer first and share with you. Could you share your email address?

[sandeep-edb]

The PostgreSQL 17.2-2, 16.6-2, 15.10-2 are available for download. These installers include a fix for system installation issue with non-English name

[BlasterCegep]

Thank you ! It's working now ! :D

[sandeep-edb]

Thank you for the confirmation @BlasterCegep

[sandeep-edb]

@Ujola Were you able to try the latest version?

[Ujola]

The site for downloading the latest version is block at our end for security reason, can you give me the source at my mail id please?
[email protected]

[sandeep-edb]

You mean you're unable to download from EDB website?

[Ujola]

Yes

[Ujola]

https://www.enterprisedb.com/downloads/postgres-postgresql-downloads this website right ?

[Ujola]

I am not able to download can you please send me the installer file?

[sandeep-edb]

Does https://sbp.enterprisedb.com/getfile.jsp?fileid=1259295 work?

[Ujola]

Yes, I downloaded the source i will test and let you know.

[swpackaging]

Hello @sandeep-edb!
We currently have the same problem in our environment with german language machines. Will there be a fix, in the foreseeable future for PostgreSQL 14 XX?

Thank you in advance for your answer :)