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

Lists: pgsql-bugs
From: "Klaus P(dot)" <kpi6288(at)gmail(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: PostgreSQL 16.3 install fails on Windows with domain user if a local user exists with the same name
Date: 2024-06-12 15:51:38
Message-ID: CAGZW8jXB8QHimGFfjSvug3M8FoY_tUfMFVSOdxRhcoW_qmn1Zw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

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


From: Sandeep Thakkar <sandeep(dot)thakkar(at)enterprisedb(dot)com>
To: "Klaus P(dot)" <kpi6288(at)gmail(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org, Neha Sharma <neha(dot)sharma(at)enterprisedb(dot)com>
Subject: Re: PostgreSQL 16.3 install fails on Windows with domain user if a local user exists with the same name
Date: 2024-06-16 03:11:52
Message-ID: CANFyU97471R9bP8wwb+jmqfNuD4KJ-482GTMEyoTZ7NbxuGU5A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

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(at)gmail(dot)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


From: Sandeep Thakkar <sandeep(dot)thakkar(at)enterprisedb(dot)com>
To: "Klaus P(dot)" <kpi6288(at)gmail(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org, Muralikrishna Bandaru <muralikrishna(dot)bandaru(at)enterprisedb(dot)com>
Subject: Re: PostgreSQL 16.3 install fails on Windows with domain user if a local user exists with the same name
Date: 2024-08-05 11:47:28
Message-ID: CANFyU97zdSCqmCCzp4ZDbKo6X=XD0hZdLFu5LyEXKomdBTNdWg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

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(at)gmail(dot)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