This seems to be a prevelant issue with many different versions of the database and lots of people providing lots of different answers, however none of them have worked for me. I am trying to install postgresql-12.0-1-windows-x64.exe. I have tried changing the location of my data folder, I have checked %COMSPEC%, I have disabled AVAST, I have tried manually changing the permissions on my data folder but no luck. Here is I believe the pertinent section of the log file:
[02:44:33] Running the post-installation/upgrade actions:
[02:44:33] Write the base directory to the ini file...
[02:44:33] Write the version number to the ini file...
Initialising the database cluster (this may take a few minutes)...
Executing cscript //NoLogo "C:\Program Files\PostgreSQL\12/installer/server/initcluster.vbs" "NT AUTHORITY\NetworkService" "postgres" "****" "C:\Users\lehrian\AppData\Local\Temp/postgresql_installer_0339009b14" "C:\Program Files\PostgreSQL\12" "C:\Program Files\PostgreSQL\12\data" 5432 "DEFAULT" 0
Script exit code: 1
Script output:
WScript.Shell Initialized...
Scripting.FileSystemObject initialized...
Called CreateDirectory(C:\Program Files\PostgreSQL\12\data)...
Called CreateDirectory(C:\Program Files\PostgreSQL\12)...
Called ClearAcl (C:\Program Files\PostgreSQL\12\data)...
Executing batch file 'radF5BB8.bat'...
Called Die(Failed to reset the ACL (C:\Program Files\PostgreSQL\12\data))...
Failed to reset the ACL (C:\Program Files\PostgreSQL\12\data)
Script stderr:
Program ended with an error exit code
Error running cscript //NoLogo "C:\Program Files\PostgreSQL\12/installer/server/initcluster.vbs" "NT AUTHORITY\NetworkService" "postgres" "****" "C:\Users\lehrian\AppData\Local\Temp/postgresql_installer_0339009b14" "C:\Program Files\PostgreSQL\12" "C:\Program Files\PostgreSQL\12\data" 5432 "DEFAULT" 0: Program ended with an error exit code
Problem running post-install step. Installation may not complete correctly
The database cluster initialisation failed.
Executing icacls "C:\Users\lehrian\AppData\Local\Temp/postgresql_installer_1b52e140ee" /inheritance:r
Script exit code: 0
radF5BB8.bat is failing. The contents of the bat file are:
@ECHO OFF
CHCP 1252
icacls "C:\Program Files\PostgreSQL\12\data > "C:\Users\lehrian\AppData\Local\Temp\rad2ABF0.tmp" 2>&1
EXIT /B %ERRORLEVEL%
I notice there is a " missing from after data. I believe this is causing this script to fail and the rest of initcluster.vbs to die.
The method call in initcluster.vbs that generates this file is DoCmd and I have included it here. I believe the error is on the bolded line. The single " should be triple like """. This will add the closing " to the command. As this file gets overwritten ever time I run the installer I can't test to see that this actually fixes the issue so I still don't have PostgreSQL installed :-( Any ideas how to get the installation to complete?
' Execute a command
Function DoCmd(strCmd)
Dim objBatchFile
Set objBatchFile = objTempFolder.CreateTextFile(strBatchFile, True)
objBatchFile.WriteLine "@ECHO OFF"
objBatchFile.WriteLine "CHCP " & objShell.RegRead("HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Nls\CodePage\ACP")
objBatchFile.WriteLine strCmd & " > """ & strOutputFile & """ 2>&1"
objBatchFile.WriteLine "EXIT /B %ERRORLEVEL%"
objBatchFile.Close
WScript.Echo " Executing batch file '" & strBatchFile & "'..."
DoCmd = objShell.Run(objTempFolder.Path & "\" & strBatchFile, 0, True)
If objFso.FileExists(objTempFolder.Path & "\" & strBatchFile) = True Then
objFso.DeleteFile objTempFolder.Path & "\" & strBatchFile, True
Else
WScript.Echo " Batch file '" & strBatchFile & "' does not exist..."
End If
If objFso.FileExists(strOutputFile) = True Then
Dim objOutputFile
Set objOutputFile = objFso.OpenTextFile(strOutputFile, ForReading)
WScript.Echo " " & objOutputFile.ReadAll
objOutputFile.Close
objFso.DeleteFile strOutputFile, True
Else
WScript.Echo " Output file does not exists..."
End If
End Function
.png "EDB Team Member"){kind=icon}
