Re: Postgres 11.5.1 failed installation

From: Sandeep Thakkar <sandeep(dot)thakkar(at)enterprisedb(dot)com>
To: Petar Masev <p(dot)masev(at)outlook(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 06:47:46
Message-ID: CANFyU96UtVespwS2t1Vq=B2Fq94_irPqzMd4Tmbr8TpjzS=B=A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F57480005%2Fpostgres-failed-to-install&data=02%7C01%7C%7Cdc38c276c6e643cee31108d72624dd12%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637019812088422116&sdata=119gs4lPmysGGmDsPcSXdEgI%2BWnp6mmO3tA57nIFDZk%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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Petar Masev 2019-08-22 08:02:06 RE: Postgres 11.5.1 failed installation
Previous Message Michael Paquier 2019-08-22 01:47:39 Re: BUG #15964: vacuumdb.c:187:10: error: use of undeclared identifier 'FD_SETSIZE'