Postgres 11.5.1 failed installation

Started by Petar Masevover 6 years ago18 messagesbugs

p.masev@outlook.com

over 6 years ago

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

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@enterprisedb.com

over 6 years ago

In reply to: Petar Masev (#1)

Re: Postgres 11.5.1 failed installation

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.masev@outlook.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

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

With regards,

Petar Masev

--
Sandeep Thakkar

Petar Masev

p.masev@outlook.com

over 6 years ago

In reply to: Sandeep Thakkar (#2)

RE: Postgres 11.5.1 failed installation

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.thakkar@enterprisedb.com>
Sent: Wednesday, August 21, 2019 5:30 AM
To: Petar Masev <p.masev@outlook.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: Postgres 11.5.1 failed installation

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.masev@outlook.com<mailto:p.masev@outlook.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://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F57480005%2Fpostgres-failed-to-install&data=02%7C01%7C%7Cb8f97ee6e2464926d80f08d725df7370%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637019513960249235&sdata=aTamZ%2BatEjcESG9LVA0nuvywm9Q9Ki7xJpFJL7jIDTE%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@enterprisedb.com

over 6 years ago

In reply to: Petar Masev (#3)

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.masev@outlook.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.thakkar@enterprisedb.com>
*Sent:* Wednesday, August 21, 2019 5:30 AM
*To:* Petar Masev <p.masev@outlook.com>
*Cc:* pgsql-bugs@lists.postgresql.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.masev@outlook.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://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F57480005%2Fpostgres-failed-to-install&data=02%7C01%7C%7Cb8f97ee6e2464926d80f08d725df7370%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637019513960249235&sdata=aTamZ%2BatEjcESG9LVA0nuvywm9Q9Ki7xJpFJL7jIDTE%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

Petar Masev

p.masev@outlook.com

over 6 years ago

In reply to: Sandeep Thakkar (#4)

RE: Postgres 11.5.1 failed installation

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.

With regards,
Petar Masev

From: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
Sent: Wednesday, August 21, 2019 10:25 AM
To: Petar Masev <p.masev@outlook.com>
Cc: pgsql-bugs@lists.postgresql.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.masev@outlook.com<mailto:p.masev@outlook.com>> wrote:
The operating system is windows 10, 1903 version, 18362.295 os build. Sorry for the missing information 😊

There is no any problems with the 11.4.3 installation assembly.

Thank you, with regards,
Petar Masev

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

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,

Also I saw on the stackoverflow the same problem but with 10.10 version -> https://stackoverflow.com/questions/57480005/postgres-failed-to-install<https://nam05.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F57480005%2Fpostgres-failed-to-install&data=02%7C01%7C%7C3418c75e84e14564dacf08d72608b179%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637019691094493881&sdata=fMXQQnMaw71d%2Bc6kgZaDDHDejLha2%2BP6uSq70cdAWWE%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@enterprisedb.com

over 6 years ago

In reply to: Petar Masev (#5)

Re: Postgres 11.5.1 failed installation

On Wed, Aug 21, 2019 at 1:23 PM Petar Masev <p.masev@outlook.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.thakkar@enterprisedb.com>
*Sent:* Wednesday, August 21, 2019 10:25 AM
*To:* Petar Masev <p.masev@outlook.com>
*Cc:* pgsql-bugs@lists.postgresql.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.masev@outlook.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.thakkar@enterprisedb.com>
*Sent:* Wednesday, August 21, 2019 5:30 AM
*To:* Petar Masev <p.masev@outlook.com>
*Cc:* pgsql-bugs@lists.postgresql.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.masev@outlook.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://nam05.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F57480005%2Fpostgres-failed-to-install&data=02%7C01%7C%7C3418c75e84e14564dacf08d72608b179%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637019691094493881&sdata=fMXQQnMaw71d%2Bc6kgZaDDHDejLha2%2BP6uSq70cdAWWE%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

Petar Masev

p.masev@outlook.com

over 6 years ago

In reply to: Sandeep Thakkar (#6)

RE: Postgres 11.5.1 failed installation

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.thakkar@enterprisedb.com>
Sent: Wednesday, August 21, 2019 1:47 PM
To: Petar Masev <p.masev@outlook.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: Postgres 11.5.1 failed installation

On Wed, Aug 21, 2019 at 1:23 PM Petar Masev <p.masev@outlook.com<mailto:p.masev@outlook.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.thakkar@enterprisedb.com<mailto:sandeep.thakkar@enterprisedb.com>>
Sent: Wednesday, August 21, 2019 10:25 AM
To: Petar Masev <p.masev@outlook.com<mailto:p.masev@outlook.com>>
Cc: pgsql-bugs@lists.postgresql.org<mailto:pgsql-bugs@lists.postgresql.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

There is no any problems with the 11.4.3 installation assembly.

Thank you, with regards,
Petar Masev

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,

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@enterprisedb.com

over 6 years ago

In reply to: Petar Masev (#7)

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.masev@outlook.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.thakkar@enterprisedb.com>
*Sent:* Wednesday, August 21, 2019 1:47 PM
*To:* Petar Masev <p.masev@outlook.com>
*Cc:* pgsql-bugs@lists.postgresql.org
*Subject:* Re: Postgres 11.5.1 failed installation

On Wed, Aug 21, 2019 at 1:23 PM Petar Masev <p.masev@outlook.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.thakkar@enterprisedb.com>
*Sent:* Wednesday, August 21, 2019 10:25 AM
*To:* Petar Masev <p.masev@outlook.com>
*Cc:* pgsql-bugs@lists.postgresql.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.masev@outlook.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.thakkar@enterprisedb.com>
*Sent:* Wednesday, August 21, 2019 5:30 AM
*To:* Petar Masev <p.masev@outlook.com>
*Cc:* pgsql-bugs@lists.postgresql.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.masev@outlook.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

Petar Masev

p.masev@outlook.com

over 6 years ago

In reply to: Sandeep Thakkar (#8)

RE: Postgres 11.5.1 failed installation

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.thakkar@enterprisedb.com>
Sent: Thursday, August 22, 2019 9:48 AM
To: Petar Masev <p.masev@outlook.com>
Cc: pgsql-bugs@lists.postgresql.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.masev@outlook.com<mailto:p.masev@outlook.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.thakkar@enterprisedb.com<mailto:sandeep.thakkar@enterprisedb.com>>
Sent: Wednesday, August 21, 2019 1:47 PM
To: Petar Masev <p.masev@outlook.com<mailto:p.masev@outlook.com>>
Cc: pgsql-bugs@lists.postgresql.org<mailto:pgsql-bugs@lists.postgresql.org>
Subject: Re: Postgres 11.5.1 failed installation

On Wed, Aug 21, 2019 at 1:23 PM Petar Masev <p.masev@outlook.com<mailto:p.masev@outlook.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

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

There is no any problems with the 11.4.3 installation assembly.

Thank you, with regards,
Petar Masev

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,

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

#10

Sandeep Thakkar

sandeep.thakkar@enterprisedb.com

over 6 years ago

In reply to: Petar Masev (#9)

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.masev@outlook.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.thakkar@enterprisedb.com>
*Sent:* Thursday, August 22, 2019 9:48 AM
*To:* Petar Masev <p.masev@outlook.com>
*Cc:* pgsql-bugs@lists.postgresql.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.masev@outlook.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.thakkar@enterprisedb.com>
*Sent:* Wednesday, August 21, 2019 1:47 PM
*To:* Petar Masev <p.masev@outlook.com>
*Cc:* pgsql-bugs@lists.postgresql.org
*Subject:* Re: Postgres 11.5.1 failed installation

On Wed, Aug 21, 2019 at 1:23 PM Petar Masev <p.masev@outlook.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.thakkar@enterprisedb.com>
*Sent:* Wednesday, August 21, 2019 10:25 AM
*To:* Petar Masev <p.masev@outlook.com>
*Cc:* pgsql-bugs@lists.postgresql.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.masev@outlook.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.thakkar@enterprisedb.com>
*Sent:* Wednesday, August 21, 2019 5:30 AM
*To:* Petar Masev <p.masev@outlook.com>
*Cc:* pgsql-bugs@lists.postgresql.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.masev@outlook.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

#11

Sandeep Thakkar

sandeep.thakkar@enterprisedb.com

over 6 years ago

In reply to: Petar Masev (#9)

Re: Postgres 11.5.1 failed installation

Hi Petar and Wilm,

here
<https://drive.google.com/file/d/1IRi1-ZS9DnuxsBNgg3-Y5Zi4mx3_DVHq/view?usp=sharing>
is
the link to the *test* installer. Could you please install and confirm if
it's working fine

Thanks.

On Thu, Aug 22, 2019 at 1:32 PM Petar Masev <p.masev@outlook.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.thakkar@enterprisedb.com>
*Sent:* Thursday, August 22, 2019 9:48 AM
*To:* Petar Masev <p.masev@outlook.com>
*Cc:* pgsql-bugs@lists.postgresql.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.masev@outlook.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.thakkar@enterprisedb.com>
*Sent:* Wednesday, August 21, 2019 1:47 PM
*To:* Petar Masev <p.masev@outlook.com>
*Cc:* pgsql-bugs@lists.postgresql.org
*Subject:* Re: Postgres 11.5.1 failed installation

On Wed, Aug 21, 2019 at 1:23 PM Petar Masev <p.masev@outlook.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.thakkar@enterprisedb.com>
*Sent:* Wednesday, August 21, 2019 10:25 AM
*To:* Petar Masev <p.masev@outlook.com>
*Cc:* pgsql-bugs@lists.postgresql.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.masev@outlook.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.thakkar@enterprisedb.com>
*Sent:* Wednesday, August 21, 2019 5:30 AM
*To:* Petar Masev <p.masev@outlook.com>
*Cc:* pgsql-bugs@lists.postgresql.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.masev@outlook.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

#12

Petar Masev

p.masev@outlook.com

over 6 years ago

In reply to: Sandeep Thakkar (#11)

RE: Postgres 11.5.1 failed installation

Hello mister Thakkar,

The installation was successful. During the installation there was a form with the Location/username pooping up. I attach a log file. Thank you and have a nice week 😊

With regards,
Petar Masev

From: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
Sent: Monday, September 9, 2019 12:23 PM
To: Petar Masev <p.masev@outlook.com>; Wilm Hoyer <W.Hoyer@dental-vision.de>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: Postgres 11.5.1 failed installation

Hi Petar and Wilm,

here<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdrive.google.com%2Ffile%2Fd%2F1IRi1-ZS9DnuxsBNgg3-Y5Zi4mx3_DVHq%2Fview%3Fusp%3Dsharing&data=02%7C01%7C%7C42d78c37c7a9451be87208d735074a17%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637036177750081403&sdata=wrlClew6RfedcF1c%2Fw7PdW4%2BlZqmpEhF6wkTo7cAlsM%3D&reserved=0> is the link to the *test* installer. Could you please install and confirm if it's working fine

Thanks.

On Thu, Aug 22, 2019 at 1:32 PM Petar Masev <p.masev@outlook.com<mailto:p.masev@outlook.com>> wrote:
Hello Mister Thakkar 😊

With regards,
Petar Masev

From: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com<mailto:sandeep.thakkar@enterprisedb.com>>
Sent: Thursday, August 22, 2019 9:48 AM
To: Petar Masev <p.masev@outlook.com<mailto:p.masev@outlook.com>>
Cc: pgsql-bugs@lists.postgresql.org<mailto:pgsql-bugs@lists.postgresql.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.masev@outlook.com<mailto:p.masev@outlook.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

On Wed, Aug 21, 2019 at 1:23 PM Petar Masev <p.masev@outlook.com<mailto:p.masev@outlook.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

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

There is no any problems with the 11.4.3 installation assembly.

Thank you, with regards,
Petar Masev

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,

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%7C42d78c37c7a9451be87208d735074a17%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637036177750091420&sdata=w6iKExTrnWvzyB5DEINQYQKnWeZc3ymOKCVlNf74NMY%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

#13

Sandeep Thakkar

sandeep.thakkar@enterprisedb.com

over 6 years ago

In reply to: Petar Masev (#12)

Re: Postgres 11.5.1 failed installation

Hello

On Mon, Sep 9, 2019 at 3:42 PM Petar Masev <p.masev@outlook.com> wrote:

Hello mister Thakkar,

The installation was successful. During the installation there was a form
with the Location/username pooping up. I attach a log file. Thank you and
have a nice week 😊

Good to know. Yes, the pop up is expected as I have included it for
debugging. Thanks.

With regards,

Petar Masev

*From:* Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
*Sent:* Monday, September 9, 2019 12:23 PM
*To:* Petar Masev <p.masev@outlook.com>; Wilm Hoyer <
W.Hoyer@dental-vision.de>
*Cc:* pgsql-bugs@lists.postgresql.org
*Subject:* Re: Postgres 11.5.1 failed installation

Hi Petar and Wilm,

here
<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdrive.google.com%2Ffile%2Fd%2F1IRi1-ZS9DnuxsBNgg3-Y5Zi4mx3_DVHq%2Fview%3Fusp%3Dsharing&data=02%7C01%7C%7C42d78c37c7a9451be87208d735074a17%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637036177750081403&sdata=wrlClew6RfedcF1c%2Fw7PdW4%2BlZqmpEhF6wkTo7cAlsM%3D&reserved=0> is
the link to the *test* installer. Could you please install and confirm if
it's working fine

Thanks.

On Thu, Aug 22, 2019 at 1:32 PM Petar Masev <p.masev@outlook.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.thakkar@enterprisedb.com>
*Sent:* Thursday, August 22, 2019 9:48 AM
*To:* Petar Masev <p.masev@outlook.com>
*Cc:* pgsql-bugs@lists.postgresql.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.masev@outlook.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.thakkar@enterprisedb.com>
*Sent:* Wednesday, August 21, 2019 1:47 PM
*To:* Petar Masev <p.masev@outlook.com>
*Cc:* pgsql-bugs@lists.postgresql.org
*Subject:* Re: Postgres 11.5.1 failed installation

On Wed, Aug 21, 2019 at 1:23 PM Petar Masev <p.masev@outlook.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.thakkar@enterprisedb.com>
*Sent:* Wednesday, August 21, 2019 10:25 AM
*To:* Petar Masev <p.masev@outlook.com>
*Cc:* pgsql-bugs@lists.postgresql.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.masev@outlook.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.thakkar@enterprisedb.com>
*Sent:* Wednesday, August 21, 2019 5:30 AM
*To:* Petar Masev <p.masev@outlook.com>
*Cc:* pgsql-bugs@lists.postgresql.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.masev@outlook.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%7C42d78c37c7a9451be87208d735074a17%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637036177750091420&sdata=w6iKExTrnWvzyB5DEINQYQKnWeZc3ymOKCVlNf74NMY%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

--
Sandeep Thakkar

#14

Wilm Hoyer

W.Hoyer@dental-vision.de

over 6 years ago

In reply to: Sandeep Thakkar (#11)

AW: Postgres 11.5.1 failed installation

Hi Sandeep,

here<https://drive.google.com/file/d/1IRi1-ZS9DnuxsBNgg3-Y5Zi4mx3_DVHq/view?usp=sharing> is the link to the *test* installer. Could you please install and confirm if it's working fine

The *test* installation works like a charm.

The pop up tells me, that it is using the correct windows AD user (domain + user name).

Just for your information:

* The startup phase took a while, since the installation wasn’t able to find the existing data directory anymore.
* Once i provide the data directory, everything works as expected (the windows service was stopped, deleted and reinstalled etc.)
Since i had the same problem with the postgreSQL 9.6 installation in the past, this is really just for your information and not an issue (at least not to me).

Sorry fort he delayed response (was away Monday and Tuesday).

Best regards,
Wilm.

#15

Sandeep Thakkar

sandeep.thakkar@enterprisedb.com

over 6 years ago

In reply to: Wilm Hoyer (#14)

Re: Postgres 11.5.1 failed installation

Hi Wilm,

On Wed, Sep 11, 2019 at 1:13 PM Wilm Hoyer <W.Hoyer@dental-vision.de> wrote:

Hi Sandeep,

here

<https://drive.google.com/file/d/1IRi1-ZS9DnuxsBNgg3-Y5Zi4mx3_DVHq/view?usp=sharing> is
the link to the *test* installer. Could you please install and confirm if
it's working fine

The *test* installation works like a charm.

Good to know. Thanks for testing.

The pop up tells me, that it is using the correct windows AD user (domain
+ user name).

Just for your information:

- The startup phase took a while, since the installation wasn’t able
to find the existing data directory anymore.
- Once i provide the data directory, everything works as expected (the
windows service was stopped, deleted and reinstalled etc.)

In a fresh installation, the installer will create the data directory at

the given location. But, in upgrade mode (when the files on disk and the
registry entries already exist), the installer doesn't try to create the
data directory and it just dumps the binaries, updates the registry entries
and restarts the service.

-

Since i had the same problem with the postgreSQL 9.6 installation in the
past, this is really just for your information and not an issue (at least
not to me).

Sorry fort he delayed response (was away Monday and Tuesday).

Best regards,

Wilm.

--
Sandeep Thakkar

#16

Fahar Abbas

fahar.abbas@enterprisedb.com

over 6 years ago

In reply to: Sandeep Thakkar (#15)

Re: Postgres 11.5.1 failed installation

Hi Team!

Windows 10 is not the supported platform for v11

*Supported Operating SystemsThe macOS build has been tested on 10.12 Sierra
and above. The Windows builds of this installer have been tested on variety
of different versions of 64bit Windows platforms like Windows 2012R2,
Windows 2016 and above. Please let us know if the installer does not
operate as expected on your operating system, and where possible, we will
try to add support*

On Wed, Sep 11, 2019 at 1:13 PM Sandeep Thakkar <
sandeep.thakkar@enterprisedb.com> wrote:

Hi Wilm,

On Wed, Sep 11, 2019 at 1:13 PM Wilm Hoyer <W.Hoyer@dental-vision.de>
wrote:

Hi Sandeep,

here

<https://drive.google.com/file/d/1IRi1-ZS9DnuxsBNgg3-Y5Zi4mx3_DVHq/view?usp=sharing> is
the link to the *test* installer. Could you please install and confirm if
it's working fine

The *test* installation works like a charm.

Good to know. Thanks for testing.

The pop up tells me, that it is using the correct windows AD user (domain
+ user name).

Just for your information:

- The startup phase took a while, since the installation wasn’t able
to find the existing data directory anymore.
- Once i provide the data directory, everything works as expected
(the windows service was stopped, deleted and reinstalled etc.)

In a fresh installation, the installer will create the data directory at

the given location. But, in upgrade mode (when the files on disk and the
registry entries already exist), the installer doesn't try to create the
data directory and it just dumps the binaries, updates the registry entries
and restarts the service.

-

Since i had the same problem with the postgreSQL 9.6 installation in the
past, this is really just for your information and not an issue (at least
not to me).

Sorry fort he delayed response (was away Monday and Tuesday).

Best regards,

Wilm.

--
Sandeep Thakkar

--
Fahar Abbas
QMG
EnterpriseDB Corporation
Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: *live:fahar.abbas*
Website: www.enterprisedb.com

#17

Igor Neyman

ineyman@perceptron.com

over 6 years ago

In reply to: Fahar Abbas (#16)

RE: Postgres 11.5.1 failed installation

From: Fahar Abbas [mailto:fahar.abbas@enterprisedb.com]
Sent: Monday, September 23, 2019 4:17 AM
To: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
Cc: Wilm Hoyer <W.Hoyer@dental-vision.de>; Petar Masev <p.masev@outlook.com>; pgsql-bugs@lists.postgresql.org
Subject: Re: Postgres 11.5.1 failed installation

Hi Team!

Windows 10 is not the supported platform for v11

Supported Operating Systems
The macOS build has been tested on 10.12 Sierra and above. The Windows builds of this installer have been tested on variety of different versions of 64bit Windows platforms like Windows 2012R2, Windows 2016 and above. Please let us know if the installer does not operate as expected on your operating system, and where possible, we will try to add support

So, you aren’t going to add Windows 10 support? One of the most used Windows versions?
Really?

Regards,
Igor Neyman

#18

Sandeep Thakkar

sandeep.thakkar@enterprisedb.com

over 6 years ago

In reply to: Igor Neyman (#17)

Re: Postgres 11.5.1 failed installation

All,

11.5-2 installer is released yesterday! It includes the fix for this issue
and also bundles pgAdmin 4.13. Thanks, everyone for their patience and
helping to resolve the issue.

On Mon, Sep 23, 2019 at 8:16 PM Igor Neyman <ineyman@perceptron.com> wrote:

*From:* Fahar Abbas [mailto:fahar.abbas@enterprisedb.com]
*Sent:* Monday, September 23, 2019 4:17 AM
*To:* Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
*Cc:* Wilm Hoyer <W.Hoyer@dental-vision.de>; Petar Masev <
p.masev@outlook.com>; pgsql-bugs@lists.postgresql.org
*Subject:* Re: Postgres 11.5.1 failed installation

Hi Team!

Windows 10 is not the supported platform for v11

*Supported Operating Systems The macOS build has been tested on 10.12
Sierra and above. The Windows builds of this installer have been tested on
variety of different versions of 64bit Windows platforms like Windows
2012R2, Windows 2016 and above. Please let us know if the installer does
not operate as expected on your operating system, and where possible, we
will try to add support*

So, you aren’t going to add Windows 10 support? One of the most used
Windows versions?

Really?

Regards,

Igor Neyman

--
Sandeep Thakkar

Postgres 11.5.1 failed installation

Attachments:

Attachments:

Attachments:

Attachments:

Attachments: