Thread

1. PostgreSQL 16.3 install fails on Windows with domain user if a local user exists with the same name

   Klaus P. <kpi6288@gmail.com> — 2024-06-12T15:51:38Z

   First detected on a production system when trying to update from 16.2 to
   16.3.
   
   The problem is however reproducable with a fresh installation of version
   16.3 and occurs under the following condition:
   - A local user exists e.g. MyServer\DomAdmin and has a user profile under
   C:\Users\DomAdmin
   - A domain user exists e.g. MyDomain\DomAdmin and has a user profile under
   C:\Users\DomAdmin.MyDomain
   
   Shortly after starting an installation of 16.3 under the domain user, the
   following error occurs:
   Error copying file from packed archive
   C:/Users/DomAdmin.MYDOMAIN/Downloads/postgresql-16.3-2-windows-x64.exe to
   C:/Users/DomAdmin.MYDOMAIN/AppData/Local/Temp/postgresql_installer_da4fcce335/prerun_checks.vbs:Destination
   not writable
   
   The destination directory
   C:/Users/DomAdmin.MYDOMAIN/AppData/Local/Temp/postgresql_installer_da4fcce335
   exists in the correct directory but it is owned by the local user
   MyServer\DomAdmin instead of MyDomain\DomAdmin
   
   Installing 16.3. with the local administrator works without a problem.
   In our case, the setup is however part of another application which must
   run under a domain user.
   
   Thank for your support
   
   Klaus
   

2. Re: PostgreSQL 16.3 install fails on Windows with domain user if a local user exists with the same name

   Sandeep Thakkar <sandeep.thakkar@enterprisedb.com> — 2024-06-16T03:11:52Z

   Hi Klaus
   
   Thanks for the report. Let me check and get back to you
   
   On Wed, Jun 12, 2024 at 9:21 PM Klaus P. <kpi6288@gmail.com> wrote:
   
   > First detected on a production system when trying to update from 16.2 to
   > 16.3.
   >
   > The problem is however reproducable with a fresh installation of version
   > 16.3 and occurs under the following condition:
   > - A local user exists e.g. MyServer\DomAdmin and has a user profile under
   > C:\Users\DomAdmin
   > - A domain user exists e.g. MyDomain\DomAdmin and has a user profile under
   > C:\Users\DomAdmin.MyDomain
   >
   > Shortly after starting an installation of 16.3 under the domain user, the
   > following error occurs:
   > Error copying file from packed archive
   > C:/Users/DomAdmin.MYDOMAIN/Downloads/postgresql-16.3-2-windows-x64.exe to
   > C:/Users/DomAdmin.MYDOMAIN/AppData/Local/Temp/postgresql_installer_da4fcce335/prerun_checks.vbs:Destination
   > not writable
   >
   > The destination directory
   > C:/Users/DomAdmin.MYDOMAIN/AppData/Local/Temp/postgresql_installer_da4fcce335
   > exists in the correct directory but it is owned by the local user
   > MyServer\DomAdmin instead of MyDomain\DomAdmin
   >
   > Installing 16.3. with the local administrator works without a problem.
   > In our case, the setup is however part of another application which must
   > run under a domain user.
   >
   > Thank for your support
   >
   > Klaus
   >
   
   
   -- 
   Sandeep Thakkar
   

3. Re: PostgreSQL 16.3 install fails on Windows with domain user if a local user exists with the same name

   Sandeep Thakkar <sandeep.thakkar@enterprisedb.com> — 2024-08-05T11:47:28Z

   Hi Klaus,
   
   I've sent you the link to download the test installer with the fix in
   another thread. Is it possible for you to confirm the fix so the upcoming
   minor release can include this change?
   
   Thanks
   
   On Wed, Jun 12, 2024 at 9:21 PM Klaus P. <kpi6288@gmail.com> wrote:
   
   > First detected on a production system when trying to update from 16.2 to
   > 16.3.
   >
   > The problem is however reproducable with a fresh installation of version
   > 16.3 and occurs under the following condition:
   > - A local user exists e.g. MyServer\DomAdmin and has a user profile under
   > C:\Users\DomAdmin
   > - A domain user exists e.g. MyDomain\DomAdmin and has a user profile under
   > C:\Users\DomAdmin.MyDomain
   >
   > Shortly after starting an installation of 16.3 under the domain user, the
   > following error occurs:
   > Error copying file from packed archive
   > C:/Users/DomAdmin.MYDOMAIN/Downloads/postgresql-16.3-2-windows-x64.exe to
   > C:/Users/DomAdmin.MYDOMAIN/AppData/Local/Temp/postgresql_installer_da4fcce335/prerun_checks.vbs:Destination
   > not writable
   >
   > The destination directory
   > C:/Users/DomAdmin.MYDOMAIN/AppData/Local/Temp/postgresql_installer_da4fcce335
   > exists in the correct directory but it is owned by the local user
   > MyServer\DomAdmin instead of MyDomain\DomAdmin
   >
   > Installing 16.3. with the local administrator works without a problem.
   > In our case, the setup is however part of another application which must
   > run under a domain user.
   >
   > Thank for your support
   >
   > Klaus
   >
   
   
   -- 
   Sandeep Thakkar