Re: BUG #16957: initdb.exe initialize a database cluster has stopped working

Hi Sandeep ,

Thanks for the response , the vc++ redistributables are already installed
in the system .
When I failed to install using the binary zip files then I downloaded the
gui installer of official postgresql from their website , which downloaded
all the required
visual c++ redistributables to the system , but that official gui installer
still failed giving the same error.
I am sharing with you the temp log file of official gui installer of
postgresql. May be it is of some help.

...
...
upacking...
unpacking..
Unpacking C:\Program Files\PostgreSQL\13\lib\postgres.lib
Unpacking C:\Program Files\PostgreSQL\13\lib\wxmsw31ud_core.lib
Unpacking C:\Program Files\PostgreSQL\13\installer\vcredist_x86.exe
Unpacking C:\Program Files\PostgreSQL\13\installer\vcredist_x64.exe
Setting variable whoami from C:\WINDOWS\System32\whoami
Script exit code: 0

Script output:
{userame}\{userame}

Script stderr:

Executing C:\WINDOWS\System32\icacls
"C:\Users\{userame}\AppData\Local\Temp/postgresql_installer_4e4790a761"
/inheritance:r
Script exit code: 0

Script output:
processed file:
C:\Users\{userame}\AppData\Local\Temp/postgresql_installer_4e4790a761
Successfully processed 1 files; Failed processing 0 files

Script stderr:

Executing C:\WINDOWS\System32\icacls
"C:\Users\{userame}\AppData\Local\Temp/postgresql_installer_4e4790a761" /T
/Q /grant "{userame}\{userame}:(OI)(CI)F"
Script exit code: 0

Script output:
Successfully processed 1 files; Failed processing 0 files

Script stderr:

[08:23:33] Running the post-installation/upgrade actions:
[08:23:33] Write the base directory to the ini file...
[08:23:33] Write the version number to the ini file...
Initialising the database cluster (this may take a few minutes)...
Executing C:\WINDOWS\System32\cscript //NoLogo "C:\Program
Files\PostgreSQL\13/installer/server/initcluster.vbs" "NT
AUTHORITY\NetworkService" "postgres" "****"
"C:\Users\{userame}\AppData\Local\Temp/postgresql_installer_4e4790a761"
"C:\Program Files\PostgreSQL\13" "C:\Program Files\PostgreSQL\13\data" 5433
"DEFAULT" 0
Script exit code: 0

Script output:
WScript.Shell Initialized...
Scripting.FileSystemObject initialized...

Called CreateDirectory(C:\Program Files\PostgreSQL\13\data)...
Called CreateDirectory(C:\Program Files\PostgreSQL\13)...
Called ClearAcl (C:\Program Files\PostgreSQL\13\data)...
Executing batch file 'rad001AC.bat'...
C:\Program Files\PostgreSQL\13\data NT SERVICE\TrustedInstaller:(I)(F)
NT
SERVICE\TrustedInstaller:(I)(CI)(IO)(F)
NT AUTHORITY\SYSTEM:(I)(F)
NT AUTHORITY\SYSTEM:(I)(OI)(CI)(IO)(F)
BUILTIN\{userame}s:(I)(F)
BUILTIN\{userame}s:(I)(OI)(CI)(IO)(F)
BUILTIN\Users:(I)(RX)
BUILTIN\Users:(I)(OI)(CI)(IO)(GR,GE)
CREATOR OWNER:(I)(OI)(CI)(IO)(F)
APPLICATION PACKAGE AUTHORITY\ALL
APPLICATION PACKAGES:(I)(RX)
APPLICATION PACKAGE AUTHORITY\ALL
APPLICATION PACKAGES:(I)(OI)(CI)(IO)(GR,GE)
APPLICATION PACKAGE AUTHORITY\ALL
RESTRICTED APPLICATION PACKAGES:(I)(RX)
APPLICATION PACKAGE AUTHORITY\ALL
RESTRICTED APPLICATION PACKAGES:(I)(OI)(CI)(IO)(GR,GE)

Successfully processed 1 files; Failed processing 0 files

Removing inherited ACLs on (C:\Program Files\PostgreSQL\13\data)
Executing batch file 'rad001AC.bat'...
processed file: C:\Program Files\PostgreSQL\13\data
Successfully processed 1 files; Failed processing 0 files

WScript.Network initialized...
strParentOfDataDirC:\Program Files\PostgreSQL\13
logged in user{userame}\{userame}
Called AclCheck(C:\Program Files\PostgreSQL\13\data)
Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:10.
MajorVersion:10
Executing icacls to ensure the {userame}\{userame} account can read the
path C:\Program Files\PostgreSQL\13\data
Executing batch file 'rad001AC.bat'...
processed file: C:\Program Files\PostgreSQL\13\data
Successfully processed 1 files; Failed processing 0 files

Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:10.
MajorVersion:10
Ensuring we can write to the data directory (using icacls) to
{userame}\{userame}:
Executing batch file 'rad001AC.bat'...
processed file: C:\Program Files\PostgreSQL\13\data
Successfully processed 1 files; Failed processing 0 files

Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:10.
MajorVersion:10
Granting full access to (NT AUTHORITY\NetworkService) on (C:\Program
Files\PostgreSQL\13\data)
Executing batch file 'rad001AC.bat'...
processed file: C:\Program Files\PostgreSQL\13\data
Successfully processed 1 files; Failed processing 0 files

Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:10.
MajorVersion:10
Granting full access to CREATOR OWNER on (C:\Program
Files\PostgreSQL\13\data)
Executing batch file 'rad001AC.bat'...
processed file: C:\Program Files\PostgreSQL\13\data
Successfully processed 1 files; Failed processing 0 files

Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:10.
MajorVersion:10
Granting full access to SYSTEM on (C:\Program Files\PostgreSQL\13\data)
Executing batch file 'rad001AC.bat'...
processed file: C:\Program Files\PostgreSQL\13\data
Successfully processed 1 files; Failed processing 0 files

Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:10.
MajorVersion:10
Granting full access to {userame}s on (C:\Program Files\PostgreSQL\13\data)
Executing batch file 'rad001AC.bat'...
processed file: C:\Program Files\PostgreSQL\13\data
Successfully processed 1 files; Failed processing 0 files

Executing batch file 'rad001AC.bat'...
Reading: objConfFile is nothing...
Writing: objConfFile is nothing...
Called AclCheck(C:\Program Files\PostgreSQL\13\data)
Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:10.
MajorVersion:10
Executing icacls to ensure the NT AUTHORITY\NetworkService account can read
the path C:\Program Files\PostgreSQL\13\data
Executing batch file 'rad001AC.bat'...
processed file: C:\Program Files\PostgreSQL\13\data
Successfully processed 1 files; Failed processing 0 files

Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:10.
MajorVersion:10
Granting service account access to the data directory (using icacls) to NT
AUTHORITY\NetworkService:
Executing batch file 'rad001AC.bat'...
processed file: C:\Program Files\PostgreSQL\13\data
processed file: C:\Program Files\PostgreSQL\13\data\log
Successfully processed 2 files; Failed processing 0 files

initcluster.vbs ran to completion

Script stderr:

Configuring database server startup...
Executing C:\WINDOWS\System32\cscript //NoLogo "C:\Program
Files\PostgreSQL\13\installer\server\startupcfg.vbs" 13 "NT
AUTHORITY\NetworkService" "****" "C:\Program Files\PostgreSQL\13"
"C:\Program Files\PostgreSQL\13\data" "postgresql-x64-13"
Script exit code: 0

Script output:
startupcfg.vbs ran to completion

Script stderr:

Creating menu shortcuts...
Executing C:\WINDOWS\System32\cscript //NoLogo "C:\Program
Files\PostgreSQL\13\installer\server\createshortcuts_server.vbs" 13
"postgres" 5433 "PostgreSQL 13" "C:\Program Files\PostgreSQL\13"
"C:\Program Files\PostgreSQL\13\data" "postgresql-x64-13"
Script exit code: 0

Script output:
Start FixupFile(C:\Program Files\PostgreSQL\13\scripts\serverctl.vbs)...
Opening file for reading...
Closing file (reading)...
Replacing placeholders...
Opening file for writing...
Closing file...
End FixupFile()...
Start FixupFile(C:\Program Files\PostgreSQL\13\scripts\runpsql.bat)...
Opening file for reading...
Closing file (reading)...
Replacing placeholders...
Opening file for writing...
Closing file...
End FixupFile()...
createshortcuts_server.vbs ran to completion

Script stderr:

Starting the database server...
Executing C:\WINDOWS\System32\cscript //NoLogo "C:\Program
Files\PostgreSQL\13\installer\server\startserver.vbs" postgresql-x64-13
Script exit code: 0

Script output:
startserver.vbs ran to completion

Script stderr:

[08:24:07] Installing the adminpack module in the postgres database...
Executing C:\Program Files\PostgreSQL\13\bin\psql.exe -c "CREATE EXTENSION
adminpack" -d postgres
Script exit code: 2

Script output:

Script stderr:
psql: error: could not connect to server: Connection refused
(0x0000274D/10061)
Is the server running on host "localhost" (::1) and accepting
TCP/IP connections on port 5433?
could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "localhost" (127.0.0.1) and accepting
TCP/IP connections on port 5433?

Failed to load SQL modules into the database cluster.
[08:28:26] Write the data directory to the ini file...
[08:28:26] Write the port number, service ID, locale and superuser to the
ini file...
[08:28:26] Write ServiceID(postgresql-x64-13) to registry/ini...
Problem running post-install step. Installation may not complete correctly
Error reading file C:/Program Files/PostgreSQL/13/data/postgresql.conf
Setting variable whoami from C:\WINDOWS\System32\whoami
Script exit code: 0

Script output:
{userame}\{userame}

Script stderr:

Executing C:\WINDOWS\System32\icacls
"C:\Users\{userame}\AppData\Local\Temp/postgresql_installer_2fbe7cd101"
/inheritance:r
Script exit code: 0

Script output:
processed file:
C:\Users\{userame}\AppData\Local\Temp/postgresql_installer_2fbe7cd101
Successfully processed 1 files; Failed processing 0 files

Script stderr:

Executing C:\WINDOWS\System32\icacls
"C:\Users\{userame}\AppData\Local\Temp/postgresql_installer_2fbe7cd101" /T
/Q /grant "{userame}\{userame}:(OI)(CI)F"
Script exit code: 0

Script output:
Successfully processed 1 files; Failed processing 0 files

Script stderr:

Creating menu shortcuts...
Executing C:\WINDOWS\System32\cscript //NoLogo "C:\Program
Files\PostgreSQL\13\installer\server\createshortcuts_clt.vbs" "PostgreSQL
13" "C:\Program Files\PostgreSQL\13"
Script exit code: 0

Script output:
Start FixupFile(C:\Program Files\PostgreSQL\13\scripts\runpsql.bat)...
Opening file for reading...
Closing file (reading)...
Replacing placeholders...
Opening file for writing...
Closing file...
End FixupFile()...
createshortcuts_clt.vbs ran to completion

Script stderr:

[08:28:42] Write the server description to the ini file...
[08:28:42] Write the server branding to the ini file...
Creating Uninstaller
Creating uninstaller 25%
Creating uninstaller 50%
Creating uninstaller 75%
Creating uninstaller 100%
Installation completed

On Sun, Apr 11, 2021 at 9:18 AM Sandeep Thakkar <
sandeep(dot)thakkar(at)enterprisedb(dot)com> wrote:

> Hi
>
> That DLL seems associated with Visual C++. Can you try installing
> https://aka.ms/vs/16/release/vc_redist.x64.exe and then check again if
> the initdb is working fine?
>
>
> On Sat, Apr 10, 2021 at 2:59 AM PG Bug reporting form <
> noreply(at)postgresql(dot)org> wrote:
>
>> The following bug has been logged on the website:
>>
>> Bug reference: 16957
>> Logged by: ahmed il
>> Email address: sadaqatcustom(at)gmail(dot)com
>> PostgreSQL version: 13.2
>> Operating system: windows 2016 server
>> Description:
>>
>> I am trying to install postgresql binary zip file to my windows machines
>> using a batch file , it gets install on some machines but shows
>> followig error in windows evet log in some of the machies. Pls help
>>
>> Event Log Windows:
>> Faulting application name: initdb.exe, version: 13.0.1.20314, time stamp:
>> 0x5faa5f0f
>> Faulting module name: ucrtbase.dll, version: 10.0.14393.3659, time stamp:
>> 0x5e9140a1
>> Exception code: 0xc0000409
>> Fault offset: 0x000000000006c9e8
>> Faulting process id: 0x579c
>> Faulting application start time: 0x01d72d5bc0a912a0
>> Faulting application path: C:\pgsql\bin\initdb.exe
>> Faulting module path: C:\WINDOWS\System32\ucrtbase.dll
>> Report Id: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> Faulting package full name:
>> Faulting package-relative application ID:
>>
>> After this i tried the official installer of postgresql and it gave me
>> same
>> this error in windows event log
>>
>> Faulting application name: initdb.exe, version: 13.0.1.20314, time stamp:
>> 0x5faa5f0f
>> Faulting module name: ucrtbase.dll, version: 10.0.14393.3659, time stamp:
>> 0x5e9140a1
>> Exception code: 0xc0000409
>> Fault offset: 0x000000000006c9e8
>> Faulting process id: 0xde00
>> Faulting application start time: 0x01d72d717352a9d5
>> Faulting application path: C:\pgsql\bin\initdb.exe
>> Faulting module path: C:\WINDOWS\System32\ucrtbase.dll
>> Report Id: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> Faulting package full name:
>> Faulting package-relative application ID:
>>
>> pls help
>>
>>
>
> --
> Sandeep Thakkar
>
>
>