PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16341
PG Version9.6.17
OSWindows Server 2016
Opened2020-04-03 14:02:01+00
Reported byEnrico La Torre
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16341
Logged by:          Enrico La Torre
Email address:      (redacted)
PostgreSQL version: 9.6.17
Operating system:   Windows Server 2016
Description:        

Hi,

it could be that the same bug was reported in
https://www.postgresql.org/message-id/16001-fa33ba75a039fc7d%40postgresql.org
, but nobody answered until today.

It is impossible for me to install PostgreSQL 9.6.17 with the EnterpriseDB
installer (free Community Edition) on Windows Server 2016 in the security
context of NT AUTHORITY\SYSTEM. If I start the installer with a regular
domain admin account, which is also local administrator, the installer
starts.  

I receive the error message: 
"Error running icacls "C:\Windows\Temp/postgresql_installer_ca555e4059" /T
/Q /grant "<DOMAIN>/<COMPUTERNAME>$:(OI)(CI)F":
C:\Windows\Temp/postgresql_installer_ca555e4059\*: Access is denied"

I disclaimed The log file of the installer
'C:\Windows\Temp\install-postgresql.log' is never written.

SYSTEM has FULL CONTROL for 'C:\Windows\Temp'. Created directories in this
directory by SYSTEM inherit FULL CONTROL from the parent. But if I check the
temporary directory '.\postgresql_installer_ca555e4059' I see that the
inheritance is disabled for this particular directory. Only the principal
named <DOMAIN>/<COMPUTERNAME>$ has FULL CONTROL not SYSTEM.

The same issue is also true for PostgreSQL 12.2. The last time this
procedure worked that I know is with the installer for PostgreSQL 9.6.12.

Kind regards

Messages

DateAuthorSubject
2020-04-03 14:02:01+00PG Bug reporting formBUG #16341: Installation with EnterpriseDB Community installer in NT AUTHORITY\SYSTEM context not possible
2020-04-06 12:27:25+00Sandeep ThakkarRe: BUG #16341: Installation with EnterpriseDB Community installer in NT AUTHORITY\SYSTEM context not possible
2020-04-06 14:11:07+00Bert BrezelRe: BUG #16341: Installation with EnterpriseDB Community installer in NT AUTHORITY\SYSTEM context not possible
2020-04-10 13:27:57+00Fahar AbbasRe: BUG #16341: Installation with EnterpriseDB Community installer in NT AUTHORITY\SYSTEM context not possible
2020-04-10 14:09:54+00Fahar AbbasRe: BUG #16341: Installation with EnterpriseDB Community installer in NT AUTHORITY\SYSTEM context not possible
2020-04-11 05:11:58+00Sandeep ThakkarRe: BUG #16341: Installation with EnterpriseDB Community installer in NT AUTHORITY\SYSTEM context not possible
2020-04-15 15:04:56+00Bert BrezelRe: BUG #16341: Installation with EnterpriseDB Community installer in NT AUTHORITY\SYSTEM context not possible
2020-04-20 09:09:54+00Sandeep ThakkarRe: BUG #16341: Installation with EnterpriseDB Community installer in NT AUTHORITY\SYSTEM context not possible
2020-04-20 13:20:44+00Bert BrezelRe: BUG #16341: Installation with EnterpriseDB Community installer in NT AUTHORITY\SYSTEM context not possible
2020-04-21 08:06:03+00Sandeep ThakkarRe: BUG #16341: Installation with EnterpriseDB Community installer in NT AUTHORITY\SYSTEM context not possible
2020-04-27 06:33:27+00Sandeep ThakkarRe: BUG #16341: Installation with EnterpriseDB Community installer in NT AUTHORITY\SYSTEM context not possible