Re: Error when installing PostgreSQL 16.3.2 under system context NT AUTHORITY\SYSTEM - Mailing list pgsql-bugs

From Sandeep Thakkar
Subject Re: Error when installing PostgreSQL 16.3.2 under system context NT AUTHORITY\SYSTEM
Date
Msg-id CANFyU97=bCnnPH2mCE_hPN=Mn0Jg3tPBH2gp8hAAt9PqeOK+_g@mail.gmail.com
Whole thread Raw
In response to AW: Error when installing PostgreSQL 16.3.2 under system context NT AUTHORITY\SYSTEM  (<Harald.Munsch@it.nrw.de>)
List pgsql-bugs
OK, I see the system account does have the correct ACL on %TEMP%, so it's odd the installation is failing. Also, I'm unable to reproduce the issue at my end.

Could you please run the installer with the command line option  "--debugtrace debug.txt" and share this file? Also, please share installation log if produced and found at %TEMP%

On Mon, Jul 8, 2024 at 5:14 PM <Harald.Munsch@it.nrw.de> wrote:

Hello Sandeep,

 

here is the output:

 

C:\WINDOWS\system32>whoami

nt-autorität\system

 

C:\WINDOWS\system32>icacls %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)

 

 

Harald

 

 

 

Von: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
Gesendet: Montag, 8. Juli 2024 13:35
An: Munsch, Harald (IT.NRW) <Harald.Munsch@it.nrw.de>
Cc: pgsql-bugs@lists.postgresql.org; Siepmann, Claudia (IT.NRW) <Claudia.Siepmann@it.nrw.de>
Betreff: Re: Error when installing PostgreSQL 16.3.2 under system context NT AUTHORITY\SYSTEM

 

Hi Harald,

Could you execute these commands and share the output in the SYSTEM-context?

whoami
icacls %TEMP%

 

 

On Sun, Jul 7, 2024 at 3:41 PM <Harald.Munsch@it.nrw.de> wrote:

Hello,

 

when installing PostgreSQL version 16.3.2 on a windows 10 client with the setup: „postgresql-16.3-2-windows-x64.exe“ via SCCM, i.e. in SYSTEM-context, the installation failes with following error-message:

(The error occures directly after starting the installation.)

 

„There has been an error. Unable to write inside TEMP environment path“

 

Even though the system-account has full permissions to this path.

An Installation with an  Administrative account (not NT AUTHORITY\SYSTEM ) on the same client runs succesfully.

 

We want to deploy the software with SCCM, therefore, we need to use the SYSTEM-account.

Can you please provide us with a setup that works in SYSTEM-context ?

 

 

 

 

 

Thank you for your support.

Kind regards

 

Mit freundlichen Grüßen

Harald Munsch

 

--

 

Information und Technik

Nordrhein-Westfalen (IT.NRW)

 

 

mailto:harald.munsch@it.nrw.de

 


 

--

Sandeep Thakkar

 



--
Sandeep Thakkar


Attachment

pgsql-bugs by date:

Previous
From:
Date:
Subject: AW: Error when installing PostgreSQL 16.3.2 under system context NT AUTHORITY\SYSTEM
Next
From: Masahiko Sawada
Date:
Subject: Re: Potential data loss due to race condition during logical replication slot creation