RE: Postgres 11.5.1 failed installation

From: Petar Masev <p(dot)masev(at)outlook(dot)com>
To: Sandeep Thakkar <sandeep(dot)thakkar(at)enterprisedb(dot)com>
Cc: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: RE: Postgres 11.5.1 failed installation
Date: 2019-08-22 08:02:06
Message-ID: VI1PR01MB41116D6010F4AF546F9E5A5DEEA50@VI1PR01MB4111.eurprd01.prod.exchangelabs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello Mister Thakkar 😊

As in the previous message the _failed file is from the machine with the issue. Something I forgot to mention is that the os of the machine with the issue is home edition, the other one is pro edition, if it is a thing of matter.

With regards,
Petar Masev

From: Sandeep Thakkar <sandeep(dot)thakkar(at)enterprisedb(dot)com>
Sent: Thursday, August 22, 2019 9:48 AM
To: Petar Masev <p(dot)masev(at)outlook(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: Postgres 11.5.1 failed installation

Thanks, Mr Masev :-) It's very strange that the same OS on two different machines has different behaviors. Could you try these steps, please? I've asked another user also to try these steps.

mkdir C:\Users\user\AppData\Local\Temp\postgresql_temp2
icacls "C:\Users\user\AppData\Local\Temp/postgresql_temp2" /inheritance:r /grant:r Administrators:(OI)(CI)F
icacls "C:\Users\user\AppData\Local\Temp/postgresql_temp2"
icacls "C:\Users\user\AppData\Local\Temp/postgresql_temp2" /T /Q /grant "user:(OI)(CI)F"
icacls "C:\Users\user\AppData\Local\Temp/postgresql_temp2"

Thanks.

On Wed, Aug 21, 2019 at 5:12 PM Petar Masev <p(dot)masev(at)outlook(dot)com<mailto:p(dot)masev(at)outlook(dot)com>> wrote:
Here you are Mister Thakkar 😊

The _success file is from the pc with the success installation, the _failed is from the pc with the issue. The issue is happening when the /T switch is appended to the icacls command.

With regards,
Petar Masev

From: Sandeep Thakkar <sandeep(dot)thakkar(at)enterprisedb(dot)com<mailto:sandeep(dot)thakkar(at)enterprisedb(dot)com>>
Sent: Wednesday, August 21, 2019 1:47 PM
To: Petar Masev <p(dot)masev(at)outlook(dot)com<mailto:p(dot)masev(at)outlook(dot)com>>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org<mailto:pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Postgres 11.5.1 failed installation

On Wed, Aug 21, 2019 at 1:23 PM Petar Masev <p(dot)masev(at)outlook(dot)com<mailto:p(dot)masev(at)outlook(dot)com>> wrote:
Here you are Mister Thakkar 😊

After the execution of the commands the issue still exists. On another computer with the same os the installation was successful.

Yeah, the commands were shared just to figure out the ACLs and it wasn't expected to fix the problem :-) Since the installation is successful on another OS, can you try the following commands on both your machines and share the output, please?

mkdir C:\Users\user\AppData\Local\Temp\postgresql_temp
icacls "C:\Users\user\AppData\Local\Temp\postgresql_temp"
icacls "C:\Users\user\AppData\Local\Temp/postgresql_temp" /inheritance:r
icacls "C:\Users\user\AppData\Local\Temp/postgresql_temp" /T /Q /grant "user:(OI)(CI)F"
icacls "C:\Users\user\AppData\Local\Temp\postgresql_temp"

With regards,
Petar Masev

From: Sandeep Thakkar <sandeep(dot)thakkar(at)enterprisedb(dot)com<mailto:sandeep(dot)thakkar(at)enterprisedb(dot)com>>
Sent: Wednesday, August 21, 2019 10:25 AM
To: Petar Masev <p(dot)masev(at)outlook(dot)com<mailto:p(dot)masev(at)outlook(dot)com>>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org<mailto:pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Postgres 11.5.1 failed installation

I'm not able to reproduce the problem on Windows 10 and 2012 R2. Could you please run the icacls on all directories in that path and share the output?

C:\> icacls C:\
C:\> icacls C:\Users\user
C:\> icacls C:\Users\user\AppData\Local\Temp

On Wed, Aug 21, 2019 at 11:55 AM Petar Masev <p(dot)masev(at)outlook(dot)com<mailto:p(dot)masev(at)outlook(dot)com>> wrote:
The operating system is windows 10, 1903 version, 18362.295 os build. Sorry for the missing information 😊

1. The suggested command resulted in ‘Access is denied’. It seems that the folder postgresql_installer_3011282188and the other folders postgresql_installer_{string} are not owned by the current os user via which the installation has been started.
2. I changed the temp location to custom folder but the result is the same.

There is no any problems with the 11.4.3 installation assembly.

Thank you, with regards,
Petar Masev

From: Sandeep Thakkar <sandeep(dot)thakkar(at)enterprisedb(dot)com<mailto:sandeep(dot)thakkar(at)enterprisedb(dot)com>>
Sent: Wednesday, August 21, 2019 5:30 AM
To: Petar Masev <p(dot)masev(at)outlook(dot)com<mailto:p(dot)masev(at)outlook(dot)com>>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org<mailto:pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Postgres 11.5.1 failed installation

Hi

What's your Windows version? Will investigate the issue and get back to you. Could you run the following command as an Administrator and paste the output?

C:\> icacls C:\Users\user\AppData\Local\Temp/postgresql_installer_3011282188

Can you also please try setting the TEMP variable to some other temporary directory and rerun the installer? So on the command prompt, you may do this:

C:\> set TEMP=C:\MyCustomTemp (Please create this directory if it doesn't exist)
C:\> postgresql-11.5-1-windows-x64.exe

Thanks,

On Tue, Aug 20, 2019 at 8:40 PM Petar Masev <p(dot)masev(at)outlook(dot)com<mailto:p(dot)masev(at)outlook(dot)com>> wrote:
Hello, I tried to upgrade the postgres’version but something goes wrong with the privileges may be. I attach a log about the problem.

Also I saw on the stackoverflow the same problem but with 10.10 version -> https://stackoverflow.com/questions/57480005/postgres-failed-to-install<https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F57480005%2Fpostgres-failed-to-install&data=02%7C01%7C%7C5fd8c4eb3cc84c3b602808d726ccaaef%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637020532796791331&sdata=5Ren8kQ1G5Iyi7jovhTfZAH%2B3TomR%2FPzGeF%2BKkCvsa8%3D&reserved=0>

Thank you for any suggestions to resolve it or do we need to wait for another installation assembly.

With regards,
Petar Masev

--
Sandeep Thakkar

--
Sandeep Thakkar

--
Sandeep Thakkar

--
Sandeep Thakkar

Attachment Content-Type Size
mkdir_icacls_output_failed_2.txt text/plain 1.4 KB
mkdir_icacls_output_success_2.txt text/plain 1.2 KB

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kyotaro Horiguchi 2019-08-22 08:14:39 Re: BUG #15954: Unable to alter partitioned table to set logged
Previous Message Sandeep Thakkar 2019-08-22 06:47:46 Re: Postgres 11.5.1 failed installation