Обсуждение: Postgres 11.5.1 failed installation
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
Вложения
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
The operating system is windows 10, 1903 version, 18362.295 os build. Sorry for the missing information 😊
- 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.
- 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
The operating system is windows 10, 1903 version, 18362.295 os build. Sorry for the missing information 😊
- 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.
- 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 😊
- 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.
- 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
Вложения
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 😊
- 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.
- 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
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 😊
- 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.
- 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
Вложения
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"
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 😊
- 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.
- 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
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 😊
- 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.
- 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
Вложения
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 😊
- 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.
- 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
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 😊
- 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.
- 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
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 😊
- 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.
- 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
Вложения
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 😊
- 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.
- 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.
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.
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
Hi Wilm,On Wed, Sep 11, 2019 at 1:13 PM Wilm Hoyer <W.Hoyer@dental-vision.de> wrote: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.
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
--
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: live:fahar.abbas
Website: www.enterprisedb.com
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
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