Обсуждение: Postgresql 16.3 installation error (setup file) on Windows 11

Hello, 

I have Postgresql 16.2 on my development environment.

I tried upgrade the latest version but installation file not working (from EDB > postgresql-16.3-1-windows-x64.exe  ).

Error message is : 

" 

There has benn an error .

Error running 'C:\Windows\System32\icacls'  'D:\Temp/ Postgresql_installer_4c1b8061b5' /T /Q grant  'mycomputer:(OI)(CI)'F':D:\Temp/Postgresql_installer_4c1b8061b5\*:Access denied

"

I added the image of error message enclosed file

With my best regards

Hi,

On 2024-05-14 07:40:41 +0000, Ugur Yilmaz wrote:
> My computer language settings are : Türkiye (country) / Türkçe (language)

In that case, this thread might be relevant:
https://postgr.es/m/PH8PR21MB3902F334A3174C54058F792CE5182%40PH8PR21MB3902.namprd21.prod.outlook.com

Thomas has a patch at
https://postgr.es/m/CA%2BhUKGJJgyc9xg%2Bg_8_jPUV08Kr0NFdgq2_H9mm7-eZd7YVRQg%40mail.gmail.com

Greetings,

Andres Freund

Thank you for sharing details. We are unable to reproduce the issue on Windows Server 2022. It could be Windows 11 specific. We are going to verify it on WIndows 11 and get back to you. 

On Tue, May 14, 2024 at 1:10 PM Ugur Yilmaz <ugurlu2001@hotmail.com> wrote:

Hi Sandeep; 

Sorry for late reply. 

My computer language settings are : Türkiye (country) / Türkçe (language)

Script and result on powershell: 

   powershell get-uiculture

LCID             Name             DisplayName

----             ----             -----------

1055             tr-TR            Türkçe (Türkiye)

For postgresql create db script is  (on pgadmin) : 

-- Database: postgres

-- DROP DATABASE IF EXISTS postgres;

CREATE DATABASE postgres

    WITH

    OWNER = postgres

    ENCODING = 'UTF8'

    LC_COLLATE = 'C'

    LC_CTYPE = 'C'

    LOCALE_PROVIDER = 'libc'

    TABLESPACE = pg_default

    CONNECTION LIMIT = -1

    IS_TEMPLATE = False;

COMMENT ON DATABASE postgres

    IS 'default administrative connection database';

Notes: 

Problem is not related for admin rights (executing setup exe and folder permission rights)

---

Gönderen: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
Gönderildi: 13 Mayıs 2024 Pazartesi 05:34
Kime: Ugur Yilmaz <ugurlu2001@hotmail.com>
Bilgi: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Konu: Re: Postgresql 16.3 installation error (setup file) on Windows 11

 

Hi,

Can you please share what language/locale you use? Also, what's your logged in user name as I see two names in the attached screenshot?

On Fri, May 10, 2024 at 7:58 PM Ugur Yilmaz <ugurlu2001@hotmail.com> wrote:

Hello, 

I have Postgresql 16.2 on my development environment.

I tried upgrade the latest version but installation file not working (from EDB > postgresql-16.3-1-windows-x64.exe  ).

Error message is : 

" 

There has benn an error .

Error running 'C:\Windows\System32\icacls'  'D:\Temp/ Postgresql_installer_4c1b8061b5' /T /Q grant  'mycomputer:(OI)(CI)'F':D:\Temp/Postgresql_installer_4c1b8061b5\*:Access denied

"

I added the image of error message enclosed file

With my best regards

--

Sandeep Thakkar

--

Sandeep Thakkar

We have the same issue on Windows 10 Enterprise 22H2 build 19045.4412 when running postgresql-16.3-1-windows-x64.exe.

Postgres 15.6 is installed already. Postgres 16.2 was previously installed and removed, directories are deleted.

The installer shows the error message as soon as started, not showing any prompt page.

The installation log is attached.

Thanks,

Kamil Adem

Hi Ugur,

We couldn't reproduce the issue on Windows 11 as well. Here is what we did to reproduce. Can you please share the installation log from the system temp? That may give some clue. 

On Thu, May 16, 2024 at 11:57 AM Sandeep Thakkar <sandeep.thakkar@enterprisedb.com> wrote:

Thank you for sharing details. We are unable to reproduce the issue on Windows Server 2022. It could be Windows 11 specific. We are going to verify it on WIndows 11 and get back to you. 

 

On Tue, May 14, 2024 at 1:10 PM Ugur Yilmaz <ugurlu2001@hotmail.com> wrote:

Hi Sandeep; 

 

Sorry for late reply. 

 

My computer language settings are : Türkiye (country) / Türkçe (language)

 

Script and result on powershell: 

 

   powershell get-uiculture

 

LCID             Name             DisplayName

----             ----             -----------

1055             tr-TR            Türkçe (Türkiye)

 

For postgresql create db script is  (on pgadmin) : 

 

-- Database: postgres

 

-- DROP DATABASE IF EXISTS postgres;

 

CREATE DATABASE postgres

    WITH

    OWNER = postgres

    ENCODING = 'UTF8'

    LC_COLLATE = 'C'

    LC_CTYPE = 'C'

    LOCALE_PROVIDER = 'libc'

    TABLESPACE = pg_default

    CONNECTION LIMIT = -1

    IS_TEMPLATE = False;

 

COMMENT ON DATABASE postgres

    IS 'default administrative connection database';

 

Notes: 

Problem is not related for admin rights (executing setup exe and folder permission rights)

 

---

Gönderen: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
Gönderildi: 13 Mayıs 2024 Pazartesi 05:34
Kime: Ugur Yilmaz <ugurlu2001@hotmail.com>
Bilgi: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Konu: Re: Postgresql 16.3 installation error (setup file) on Windows 11

 

Hi,

Can you please share what language/locale you use? Also, what's your logged in user name as I see two names in the attached screenshot?

On Fri, May 10, 2024 at 7:58 PM Ugur Yilmaz <ugurlu2001@hotmail.com> wrote:

Hello, 

 

I have Postgresql 16.2 on my development environment.

 

I tried upgrade the latest version but installation file not working (from EDB > postgresql-16.3-1-windows-x64.exe  ).

 

Error message is : 

 

" 

There has benn an error .

Error running 'C:\Windows\System32\icacls'  'D:\Temp/ Postgresql_installer_4c1b8061b5' /T /Q grant  'mycomputer:(OI)(CI)'F':D:\Temp/Postgresql_installer_4c1b8061b5\*:Access denied

"

 

I added the image of error message enclosed file

 

With my best regards

 

 

 

--

Sandeep Thakkar

 

 

--

Sandeep Thakkar

 

--

Sandeep Thakkar