Thread: 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

 

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

 

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

 

With regards,

Petar Masev

 

--

Sandeep Thakkar

 

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> 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

 

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

 

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 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

 

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

 

Hi Sandeep,

 

>here 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.

 

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