RE: [EXTERNAL] Re: BUG #18528: Installer displays error when installing

This is a newly purchased system.  This is the first time I’ve tried to install PostgreSQL on it.
I initially tried to install 15.7 and when that failed I tried the 14 and 16 version installers.  Both had the same behavior.  I even tried the version 12 installer, but it also gave the same errors.

I had deleted all the previous directories that were created, so I had to run the install again this morning.  Log file for this run is attached and the results for the icacls command is below.
I will add that in order to delete the directory/folder that the installer creates I have to double click the folder at which time it says I don’t have permissions and asks if I want to permanently grant permissions.

Output of the icacls command:
C:\Windows\system32>icacls c:\Users\cmware\AppData\Local\Temp\postgresql_installer_a879bd9971
c:\Users\username\AppData\Local\Temp\postgresql_installer_a879bd9971 LA-3544-SPRO9-1\username:(F)

Successfully processed 1 files; Failed processing 0 files

C:\Windows\system32>


Thank you,
Chris

From: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
Sent: Tuesday, July 2, 2024 10:42 PM
To: Ware, Christopher M. (LARC-D318)[RSES] <christopher.m.ware@nasa.gov>; pgsql-bugs@lists.postgresql.org
Subject: [EXTERNAL] Re: BUG #18528: Installer displays error when installing

CAUTION: This email originated from outside of NASA.  Please take care when clicking links or opening attachments.  Use the "Report Message" button to report suspicious messages to the NASA SOC.


Hi,

Thanks for the report. Can you please confirm if the earlier versions (<=15.6) were installed fine on this server?

The forward slashes usually work on windows as well. Could you please share the installation log which must have been created in the system temp with either the name installbuilder or install-postgresql?

Also, on the command line if you can please get the output of:
> icacls C:/Users/username/AppData/Local/Temp/postgresql_installer_f34465eff3


On Wed, Jul 3, 2024 at 1:13 AM PG Bug reporting form <noreply@postgresql.org<mailto:noreply@postgresql.org>> wrote:
The following bug has been logged on the website:

Bug reference:      18528
Logged by:          Chris Ware
Email address:      christopher.m.ware@nasa.gov<mailto:christopher.m.ware@nasa.gov>
PostgreSQL version: 15.7
Operating system:   Windows 11
Description:

This probably isn't the right place to submit this finding, but I couldn't
find any other place to submit it.
If this is not the correct forum for this kind of support, can you please
redirect me to the correct place?
I'm trying to install the PostgreSQL 15.7 installer onto a Microsoft Surface
Pro 9 running Windows 10.
I'm running as an administrator, and I've also clicked "Run as
Administrator" as well.  I receive the following two errors:
1: "Error copying from packed archive
c:/Install/folder/postgresql-15.7.2-windows-x64.exe to
C:/Users/username/AppData/Local/Temp/postgresql_installer_f34465eff3/prerun_checks.vbs:Destination
not writable"
2. "There has been an error. system's temp folder is not writable by the
current user."

The error messages have forward slashes '/' instead of back slashes '\'.
Not sure it that makes a difference or not.
The installer does appear to work on Desktop type computers.
Since I am an administrator on the system and the installer is trying to
write files to the directory owned by this user, it seems to be a problem
with the installer on this type of hardware.

Any assistance is appreciated.
Chris


--
Sandeep Thakkar