Thread: BUG #15885: EnterpriseDB Installer upgrade process fails with icacls error

BUG #15885: EnterpriseDB Installer upgrade process fails with icacls error

From
PG Bug reporting form
Date:
The following bug has been logged on the website:

Bug reference:      15885
Logged by:          Edgar Anderson
Email address:      eanderson@usdataworks.com
PostgreSQL version: 9.4.23
Operating system:   Windows
Description:

I was attempting to upgrade a database on Windows from 9.4.5 to 9.4.23 using
the EnterpriseDB installer. It successfully detected the existing
installation and data directory, but the installer failed while trying to
execute a step involving icacls.exe. Comparing the error message to the
directory created in AppData\Local\Temp, it looks like the installer is
unpacking its files to one directory, then trying to run scripts from
another directory, which does not exist. The installer attempts to restore
permissions using icacls, loading permissions from an aclfile in the
non-existent directory, and fails with a "Access Denied" error when trying
to access the non-existent directory.

Apologies if this should be reported instead to EnterpriseDB.


On Tue, Jul 2, 2019 at 3:44 PM PG Bug reporting form
<noreply@postgresql.org> wrote:
>
> The following bug has been logged on the website:
>
> Bug reference:      15885
> Logged by:          Edgar Anderson
> Email address:      eanderson@usdataworks.com
> PostgreSQL version: 9.4.23
> Operating system:   Windows
> Description:
>
> I was attempting to upgrade a database on Windows from 9.4.5 to 9.4.23 using
> the EnterpriseDB installer. It successfully detected the existing
> installation and data directory, but the installer failed while trying to
> execute a step involving icacls.exe. Comparing the error message to the
> directory created in AppData\Local\Temp, it looks like the installer is
> unpacking its files to one directory, then trying to run scripts from
> another directory, which does not exist. The installer attempts to restore
> permissions using icacls, loading permissions from an aclfile in the
> non-existent directory, and fails with a "Access Denied" error when trying
> to access the non-existent directory.
>
> Apologies if this should be reported instead to EnterpriseDB.

Adding Dave and Sandeep.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company