Re: BUG #16808: Postgres Windows installer fails with iso-8859-1 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@postgresql.org> wrote:

The following bug has been logged on the website:

Bug reference:      16808
Logged by:          Michael Wilder
Email address:      wilder.michael@cimcor.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"