AW: BUG #18615: installer cannot be executed as "nt-autorität\system"

PS C:\> icacls c:\Windows\Temp
c:\Windows\Temp VORDEFINIERT\Benutzer:(CI)(S,WD,AD,X)

VORDEFINIERT\Administratoren:(F)

VORDEFINIERT\Administratoren:(OI)(CI)(IO)(F)

NT-AUTORITÄT\SYSTEM:(F)

NT-AUTORITÄT\SYSTEM:(OI)(CI)(IO)(F)

ERSTELLER-BESITZER:(OI)(CI)(IO)(F)

Successfully processed 1 files; Failed processing 0 files

PS C:\>

It looks like installer does set incorrect permissions for its temp folder in c:\Windows\Temp\. I can see the folder, e.g. C:\Windows\Temp \postgresql_installer_3086eea437.

PS C:\> icacls C:\Windows\Temp\postgresql_installer_3086eea437\

C:\Windows\Temp\postgresql_installer_3086eea437\DEVICENAME$:(F)

It should inherit permission from c:\Windows\Temp\.

Von: Muralikrishna Bandaru <muralikrishna(dot)bandaru(at)enterprisedb(dot)com>
Gesendet: Mittwoch, 18. September 2024 14:58
An: neral85(at)gmx(dot)de; pgsql-bugs(at)lists(dot)postgresql(dot)org
Betreff: Re: BUG #18615: installer cannot be executed as "nt-autorität\system"

On Thu, Sep 12, 2024 at 4:19 PM PG Bug reporting form <noreply(at)postgresql(dot)org <mailto:noreply(at)postgresql(dot)org> > wrote:

The following bug has been logged on the website:

Bug reference: 18615
Logged by: neeral85
Email address: neral85(at)gmx(dot)de <mailto:neral85(at)gmx(dot)de>
PostgreSQL version: 16.4
Operating system: Windows x64
Description:

16.2 could be executed as "nt-autorität\system" while 16.4 cannot be
executed as "nt-autorität\system"

This is required by patch management software as it runs any installation as
"nt-autorität\system" and not with current login user.
----------
Log started 09/12/2024 at 12:23:00
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:
nt-autorität\system

Script stderr:

Error copying file from packed archive
C:/Users/User/tmp/postgresql-16.4-1-windows-x64.exe to
C:/Windows/Temp/postgresql_installer_a27c6b7106/prerun_checks.vbs
:Destination not writable
system's temp folder is not writable by the current user.
Exiting with code 1
------

Hi,

Maybe "nt-autorität\system" user doesn't have the write permission for the "C:/Windows/Temp/" folder.
Can you please run the below icacls command and share the output.

icacls c:\Windows\Temp