Re: Postgres 11.5.1 failed installation

OK, thanks. Looks like there is an issue with ACLs on Windows 10 and few
users have reported the same.

Will fix this and provide the new update soon.

On Thu, Aug 22, 2019 at 1:32 PM Petar Masev <p(dot)masev(at)outlook(dot)com> wrote:

> 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> 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>
> *Sent:* Wednesday, August 21, 2019 1:47 PM
> *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
>
>
>
>
>
>
>
> On Wed, Aug 21, 2019 at 1:23 PM Petar Masev <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>
> *Sent:* Wednesday, August 21, 2019 10:25 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
>
>
>
> 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> 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>
> *Sent:* Wednesday, August 21, 2019 5:30 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
>
>
>
> 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> 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
>
>
>

--
Sandeep Thakkar