Re: BUG #16808: Postgres Windows installer fails with unknown error and terminates

Hi Michael,

Thanks for reporting this bug. The fix is part of the updated installer
postgresql-11.10-2-windows-x64.exe.
Please download it.

Regards,
Mihir Pandya

On Wed, Jan 6, 2021 at 6:57 PM PG Bug reporting form <noreply(at)postgresql(dot)org>
wrote:

> The following bug has been logged on the website:
>
> Bug reference: 16808
> Logged by: Michael Wilder
> Email address: wilder(dot)michael(at)cimcor(dot)com
> PostgreSQL version: 11.10
> Operating system: Windows 8.1
> Description:
>
> upgrading windows Postgres from 11.2 to 11.10
>
> fails to install
>
> unknown error reported and Install Builder terminates
>
> I ran installer executable as adminstrator
>
> Install Builder script is incorrectly adding lower case "i" before the
> "C:\"
> drive in path causing command to fail.
> Errorneous command: Executing iC:\WINDOWS\System32\icacls "C:\Program
> Files\PostgreSQL\11\data" /T /Q /grant "NT
> AUTHORITY\NetworkService:(OI)(CI)F"
> I removed the leading "i" and ran command in the command prompt with no
> problem.
>
> See attached log below. Error is at the bottom of log
>
>
> Installer executable (from EDB): postgresql-11.10-1-windows-x64.exe
>
> Windows system: Windows 8.1 Pro, 64 bit
> updates current as of Dec 9 2020
>
>
> Install log:
>
>
> Log started 01/05/2021 at 20:41:26
> Preferred installation mode : qt
> Trying to init installer in mode qt
> Mode qt successfully initialized
> Setting variable whoami from C:\WINDOWS\System32\whoami
> Script exit code: 0
>
> Script output:
> cimcor\wilder.michael
>
> Script stderr:
>
>
> Executing C:\WINDOWS\System32\icacls
>
> "C:\Users\wilder.michael\AppData\Local\Temp/postgresql_installer_ec3c8740be"
> /inheritance:r
> Script exit code: 0
>
> Script output:
> processed file:
> C:\Users\wilder.michael\AppData\Local\Temp/postgresql_installer_ec3c8740be
> Successfully processed 1 files; Failed processing 0 files
>
> Script stderr:
>
>
> Executing C:\WINDOWS\System32\icacls
>
> "C:\Users\wilder.michael\AppData\Local\Temp/postgresql_installer_ec3c8740be"
> /T /Q /grant "cimcor\wilder.michael:(OI)(CI)F"
> Script exit code: 0
>
> Script output:
> Successfully processed 1 files; Failed processing 0 files
>
> Script stderr:
>
>
> Executing C:\WINDOWS\System32\cscript //NoLogo
>
> "C:\Users\wilder.michael\AppData\Local\Temp\postgresql_installer_ec3c8740be\prerun_checks.vbs"
> Script exit code: 0
>
> Script output:
> The scripting host appears to be functional.
>
> Script stderr:
>
>
> [20:41:32] Using branding: PostgreSQL 11
> Executing
>
> C:\Users\wilder.michael\AppData\Local\Temp/postgresql_installer_ec3c8740be/temp_check_comspec.bat
>
> Script exit code: 0
>
> Script output:
> "test ok"
>
> Script stderr:
>
>
> Could not find registry key
> HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-11
> DisableStackBuilder. Setting variable iDisableStackBuilder to empty value
> [20:41:33] Existing base directory: C:\Program Files\PostgreSQL\11
> [20:41:33] Existing data directory: C:\Program Files\PostgreSQL\11\data
> [20:41:33] Using branding: PostgreSQL 11
> [20:41:33] Using Super User: postgres and Service Account: NT
> AUTHORITY\NetworkService
> [20:41:33] Using Service Name: postgresql-x64-11
> Executing
>
> C:\Users\wilder.michael\AppData\Local\Temp\postgresql_installer_ec3c8740be\pg_controldata.exe
> "C:\Program Files\PostgreSQL\11\data"
> Script exit code: 0
>
> Script output:
> pg_control version number: 1100
> Catalog version number: 201809051
> Database system identifier: 6833885629359526376
> Database cluster state: shut down
> pg_control last modified: 1/5/2021 8:03:44 PM
> Latest checkpoint location: 0/2D8F750
> Latest checkpoint's REDO location: 0/2D8F750
> Latest checkpoint's REDO WAL file: 000000010000000000000002
> Latest checkpoint's TimeLineID: 1
> Latest checkpoint's PrevTimeLineID: 1
> Latest checkpoint's full_page_writes: on
> Latest checkpoint's NextXID: 0:1400
> Latest checkpoint's NextOID: 24601
> Latest checkpoint's NextMultiXactId: 1
> Latest checkpoint's NextMultiOffset: 0
> Latest checkpoint's oldestXID: 562
> Latest checkpoint's oldestXID's DB: 1
> Latest checkpoint's oldestActiveXID: 0
> Latest checkpoint's oldestMultiXid: 1
> Latest checkpoint's oldestMulti's DB: 1
> Latest checkpoint's oldestCommitTsXid:0
> Latest checkpoint's newestCommitTsXid:0
> Time of latest checkpoint: 1/5/2021 8:03:44 PM
> Fake LSN counter for unlogged rels: 0/1
> Minimum recovery ending location: 0/0
> Min recovery ending loc's timeline: 0
> Backup start location: 0/0
> Backup end location: 0/0
> End-of-backup record required: no
> wal_level setting: replica
> wal_log_hints setting: off
> max_connections setting: 100
> max_worker_processes setting: 8
> max_prepared_xacts setting: 0
> max_locks_per_xact setting: 64
> track_commit_timestamp setting: off
> Maximum data alignment: 8
> Database block size: 8192
> Blocks per segment of large relation: 131072
> WAL block size: 8192
> Bytes per WAL segment: 16777216
> Maximum length of identifiers: 64
> Maximum columns in an index: 32
> Maximum size of a TOAST chunk: 1996
> Size of a large-object chunk: 2048
> Date/time type storage: 64-bit integers
> Float4 argument passing: by value
> Float8 argument passing: by value
> Data page checksum version: 0
> Mock authentication nonce:
> 24c99494b0510fdd51313a6c8ff5344f7ac120c1f7413e99a8452cac1dbd8cc9
>
> Script stderr:
>
>
> [20:41:35] Existing cluster catalog version: 201809051, installer catalog
> version: 201809051
> [20:41:35] Existing cluster Date/time settings: 64-bit integers, installer
> Date/time settings: 64-bit integers
> [20:41:35] Existing cluster pg_control version number: 1100, installer
> pg_control version number: 1100
> [20:41:35] Switching to upgrade mode with cluster: C:\Program
> Files\PostgreSQL\11\data
> [20:42:49] Reading port number from C:\Program
> Files\PostgreSQL\11\data/postgresql.conf
> Preparing to Install
> [20:44:53] Removing OpenSSL 1.0.2 files from installdir if exist
> Preparing to Install
> [20:44:54] Fixing the ACLs on data directory
> Executing C:\WINDOWS\System32\icacls "C:\Program Files\PostgreSQL\11\data"
> /inheritance:r
> Script exit code: 0
>
> Script output:
> processed file: C:\Program Files\PostgreSQL\11\data
> Successfully processed 1 files; Failed processing 0 files
>
> Script stderr:
>
>
> Executing C:\WINDOWS\System32\icacls "C:\Program Files\PostgreSQL\11\data"
> /T /Q /grant "wilder.michael:(OI)(CI)F"
> Script exit code: 0
>
> Script output:
> Successfully processed 1784 files; Failed processing 0 files
>
> Script stderr:
>
>
> Executing iC:\WINDOWS\System32\icacls "C:\Program Files\PostgreSQL\11\data"
> /T /Q /grant "NT AUTHORITY\NetworkService:(OI)(CI)F"
> Script exit code:
>
> Script output:
>
>
> Script stderr:
>
>
> Unknown error while running iC:\WINDOWS\System32\icacls "C:\Program
> Files\PostgreSQL\11\data" /T /Q /grant "NT
> AUTHORITY\NetworkService:(OI)(CI)F"
>
>