Thread

1. Error when installing PostgreSQL 16.3.2 under system context NT AUTHORITY\SYSTEM

   harald.munsch@it.nrw.de — 2024-07-05T11:21:11Z

   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
   
    
   
   

2. Re: Error when installing PostgreSQL 16.3.2 under system context NT AUTHORITY\SYSTEM

   Muhammad Ikram <mmikram@gmail.com> — 2024-07-07T10:56:35Z

   Hi,
   
   Have you checked whether the system user has the right permissions on Temp
   which is being used ? Please navigate to the temp that SYSTEM is using and
   check permissions and adjust accordingly.  Right click on the Temp
   directory, move to the Security tab and ensure that the system user has
   full control permissions.
   
   You may get more detailed logging by trying to install using a terminal.
   
   postgresql-16.3-2-windows-x64.exe /S /L*v %TEMP%\postgresql-install.log
   
   Hope this helps
   
   Regards,
   Muhammad Ikram,
   Bitnine Global.
   
   
   On Sun, Jul 7, 2024 at 3:11 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 <harald.munsch@it.nrw.de>
   >
   >
   >
   
   
   -- 
   Muhammad Ikram
   

3. AW: Error when installing PostgreSQL 16.3.2 under system context NT AUTHORITY\SYSTEM

   harald.munsch@it.nrw.de — 2024-07-08T06:01:48Z

   Hello,
   
    
   
   thank you for your fast response.
   
    
   
   I checked the permissions: the SYSTEM-account has full permissions to the TEMP-folder.
   
    
   
   In the internet i found a correspondence regarding an older version of PostgreSQL from a user with a similar problem. Please see following link:
   
   https://www.postgresql.org/message-id/SL2P216MB0666FD5553AA70BAE3092060F9D00%40SL2P216MB0666.KORP216.PROD.OUTLOOK.COM
   
    
   
   Maybe the cause of the current error is similar?
   
    
   
   Kind regards,
   
   Harald
   
    
   
    
   
   Von: Muhammad Ikram <mmikram@gmail.com> 
   Gesendet: Sonntag, 7. Juli 2024 12:57
   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,
   
    
   
   Have you checked whether the system user has the right permissions on Temp which is being used ? Please navigate to the temp that SYSTEM is using and check permissions and adjust accordingly.  Right click on the Temp directory, move to the Security tab and ensure that the system user has full control permissions.
   
    
   
   You may get more detailed logging by trying to install using a terminal.
   
    
   
   postgresql-16.3-2-windows-x64.exe /S /L*v %TEMP%\postgresql-install.log
   
    
   
   Hope this helps
   
    
   
   Regards,
   
   Muhammad Ikram,
   
   Bitnine Global.
   
    
   
    
   
   On Sun, Jul 7, 2024 at 3:11 PM <Harald.Munsch@it.nrw.de <mailto: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
   
    
   
   
   
   -- 
   
   Muhammad Ikram
   
   

4. Re: Error when installing PostgreSQL 16.3.2 under system context NT AUTHORITY\SYSTEM

   Muhammad Ikram <mmikram@gmail.com> — 2024-07-08T06:13:19Z

   Hi Harald.Munsch,
   
   Thanks  for sharing it with me. Could you try the solution suggested ?
   
   For quite sometime, I have not worked on Windows so don't have environment
   with me to try things for you.
   
   Regards,
   Muhammad Ikram
   
   
   On Mon, Jul 8, 2024 at 11:01 AM <Harald.Munsch@it.nrw.de> wrote:
   
   > Hello,
   >
   >
   >
   > thank you for your fast response.
   >
   >
   >
   > I checked the permissions: the SYSTEM-account has full permissions to the
   > TEMP-folder.
   >
   >
   >
   > In the internet i found a correspondence regarding an older version of
   > PostgreSQL from a user with a similar problem. Please see following link:
   >
   >
   > https://www.postgresql.org/message-id/SL2P216MB0666FD5553AA70BAE3092060F9D00%40SL2P216MB0666.KORP216.PROD.OUTLOOK.COM
   >
   >
   >
   > Maybe the cause of the current error is similar?
   >
   >
   >
   > Kind regards,
   >
   > Harald
   >
   >
   >
   >
   >
   > *Von:* Muhammad Ikram <mmikram@gmail.com>
   > *Gesendet:* Sonntag, 7. Juli 2024 12:57
   > *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,
   >
   >
   >
   > Have you checked whether the system user has the right permissions on Temp
   > which is being used ? Please navigate to the temp that SYSTEM is using and
   > check permissions and adjust accordingly.  Right click on the Temp
   > directory, move to the Security tab and ensure that the system user has
   > full control permissions.
   >
   >
   >
   > You may get more detailed logging by trying to install using a terminal.
   >
   >
   >
   > postgresql-16.3-2-windows-x64.exe /S /L*v %TEMP%\postgresql-install.log
   >
   >
   >
   > Hope this helps
   >
   >
   >
   > Regards,
   >
   > Muhammad Ikram,
   >
   > Bitnine Global.
   >
   >
   >
   >
   >
   > On Sun, Jul 7, 2024 at 3:11 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 <harald.munsch@it.nrw.de>
   >
   >
   >
   >
   >
   > --
   >
   > Muhammad Ikram
   >
   
   
   -- 
   Muhammad Ikram
   

5. Re: Error when installing PostgreSQL 16.3.2 under system context NT AUTHORITY\SYSTEM

   Sandeep Thakkar <sandeep.thakkar@enterprisedb.com> — 2024-07-08T11:35:06Z

   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 <harald.munsch@it.nrw.de>
   >
   >
   >
   
   
   -- 
   Sandeep Thakkar
   

6. AW: Error when installing PostgreSQL 16.3.2 under system context NT AUTHORITY\SYSTEM

   harald.munsch@it.nrw.de — 2024-07-08T11:44:22Z

   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 <mailto: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
   
    
   
   

7. Re: Error when installing PostgreSQL 16.3.2 under system context NT AUTHORITY\SYSTEM

   Sandeep Thakkar <sandeep.thakkar@enterprisedb.com> — 2024-07-08T12:58:01Z

   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 <harald.munsch@it.nrw.de>
   >
   >
   >
   >
   >
   >
   > --
   >
   > Sandeep Thakkar
   >
   >
   >
   
   
   -- 
   Sandeep Thakkar