RE: [EXTERNAL] Re: BUG #18528: Installer displays error when installing - Mailing list pgsql-bugs

I have some more information to share on the installation issue.

I was able to find a partial work-around for the installation issue on the surface Pro 9 system running windows 10. (As a side note, the installation worked without issue on a laptop running windows 11.)

Once I started the installer, I waited for the first error message box to pop up that had the “Retry, Ignore, Cancel” option on it (while watching the user/appdata/local/temp folder.)  Once the folder appeared, I ran the following command from an administrator command prompt window: takeown /F c:\users\USER\appdata\local\temp\postgresql_installer_XXXXXXXXXX (where XXXXXXXXXX is the hex value the installer used).  After the command was run (choosing ‘y’ to accept), I clicked on the ‘Retry’ button of the message box.  The installation was then able to proceed.  I didn’t have any other issues until the end of the installer when I received a message box about a problem running post-install step, screen shot attached.

I also noticed several more postgresql_installer_xxxxxxxxxx folders were created, all with the same permissions problem.

It almost seems like the installer doesn’t recognize the hardware or something and not applying permissions correctly.  I have Cygwin installed on the system and using it to get a listing of the folders that have the permission problem it lists the folder as owned by Administrators and the group of Domain Users.  The actual permissions seen are “d---rwx---+” which is no permissions for user, read, write and execute for group, and no permissions for other.

I don’t know why the installer would put incorrect permissions on the folders it creates.  I’m also assuming that the attached screen shot of the last error received is due to the same permissions problem for later steps in the install process that creates the additional folders.

One other piece of information is that looking at the permissions of the folder after I ran the takeown command on it, cygwin shows “drwxr-x---” with an “Unknown+User” and “Unknown+Group” but apparently it doesn’t care about who the user is, just the permissions that the OS has to follow.

I have also attached the log files generated during this partial work-around attempt.

Thanks,

Chris

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