cancel
Showing results for 
Search instead for 
Did you mean: 

Error when installing postgresql 11.5 on windows 10.

Journeyer

Error when installing postgresql 11.5 on windows 10.

Hi admin,

I have a trouble installing postgreSQL version (postgresql-11.5-1-windows-x64.exe). I tried uninstalling, deleting all related folder, turning off windows defender, firewall and reinstalling but not effective.

These are my installation steps.

1.PNG2.PNG3.PNG4.PNG5.PNG6.PNG7.PNG
8.PNG9.PNG

I don't see postgresql service either. Please help me.

2 REPLIES 2
Journeyer

Re: Error when installing postgresql 11.5 on windows 10.

Log started 08/15/2019 at 15:49:33
Preferred installation mode : qt
Trying to init installer in mode qt
Mode qt successfully initialized
Executing icacls "C:\Users\BATINH\AppData\Local\Temp/postgresql_installer_c65d843757" /inheritance:r
Script exit code: 0

Script output:
 processed file: C:\Users\BATINH\AppData\Local\Temp/postgresql_installer_c65d843757
Successfully processed 1 files; Failed processing 0 files

Script stderr:
 

Executing icacls "C:\Users\BATINH\AppData\Local\Temp/postgresql_installer_c65d843757" /T /Q /grant "BATINH:(OI)(CI)F"
Script exit code: 0

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

Script stderr:
 

Executing cscript //NoLogo "C:\Users\BATINH\AppData\Local\Temp\postgresql_installer_c65d843757\prerun_checks.vbs"
Script exit code: 0

Script output:
 The scripting host appears to be functional.

Script stderr:
 

Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-11 Base Directory. Setting variable iBaseDirectory to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-11 Branding. Setting variable iBranding to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-11 Version. Setting variable brandingVer to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-11 Shortcuts. Setting variable iShortcut to empty value
[15:49:41] Using branding: PostgreSQL 11
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-11 SB_Version. Setting variable sb_version to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-11 pgAdmin_Version. Setting variable pgadmin_version to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-11 CLT_Version. Setting variable clt_version to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-11 Data Directory. Setting variable server_data_dir to empty value
Executing C:\Users\BATINH\AppData\Local\Temp/postgresql_installer_c65d843757/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 Data Directory. Setting variable iDataDirectory to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-11 Base Directory. Setting variable iBaseDirectory to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-11 Service ID. Setting variable iServiceName to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-11 Service Account. Setting variable iServiceAccount to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-11 Super User. Setting variable iSuperuser to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-11 Branding. Setting variable iBranding to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-11 Version. Setting variable brandingVer to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-11 Shortcuts. Setting variable iShortcut to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-11 DisableStackBuilder. Setting variable iDisableStackBuilder to empty value
[15:49:42] Existing base directory: 
[15:49:42] Existing data directory: 
[15:49:42] Using branding: PostgreSQL 11
[15:49:42] Using Super User: postgres and Service Account: NT AUTHORITY\NetworkService
[15:49:42] Using Service Name: postgresql-x64-11
Executing C:\Users\BATINH\AppData\Local\Temp\postgresql_installer_c65d843757\getlocales.exe 
Script exit code: 0

...



...
Directory already exists: C:\Program Files\PostgreSQL\11
Directory already exists: C:\Program Files\PostgreSQL\11\share
Creating directory C:\Program Files\PostgreSQL\11\share\i18n
Creating directory C:\Program Files\PostgreSQL\11\share\i18n\fr_FR
Creating directory C:\Program Files\PostgreSQL\11\share\i18n\tr_TR
Creating directory C:\Program Files\PostgreSQL\11\share\i18n\ru_RU
Creating directory C:\Program Files\PostgreSQL\11\share\i18n\ja_JP
Creating directory C:\Program Files\PostgreSQL\11\share\i18n\de_DE
Creating directory C:\Program Files\PostgreSQL\11\share\i18n\sv_SE
Creating directory C:\Program Files\PostgreSQL\11\share\i18n\zh_CN
Directory already exists: C:\Program Files\PostgreSQL\11\bin
Unpacking files
Unpacking C:\Program Files\PostgreSQL\11\share\i18n\fr_FR\wxstd.mo
Unpacking C:\Program Files\PostgreSQL\11\share\i18n\tr_TR\wxstd.mo
Unpacking C:\Program Files\PostgreSQL\11\share\i18n\ru_RU\wxstd.mo
Unpacking C:\Program Files\PostgreSQL\11\share\i18n\ja_JP\wxstd.mo
Unpacking C:\Program Files\PostgreSQL\11\share\i18n\de_DE\wxstd.mo
Unpacking C:\Program Files\PostgreSQL\11\share\i18n\sv_SE\wxstd.mo
Unpacking C:\Program Files\PostgreSQL\11\share\i18n\zh_CN\wxstd.mo
Unpacking C:\Program Files\PostgreSQL\11\bin\wxbase28u_xml_vc_custom.dll
Unpacking C:\Program Files\PostgreSQL\11\bin\wxbase28u_net_vc_custom.dll
Unpacking C:\Program Files\PostgreSQL\11\share\i18n\fr_FR\StackBuilder.mo
Unpacking C:\Program Files\PostgreSQL\11\share\i18n\tr_TR\StackBuilder.mo
Unpacking C:\Program Files\PostgreSQL\11\share\i18n\ru_RU\StackBuilder.mo
Unpacking C:\Program Files\PostgreSQL\11\share\i18n\ja_JP\StackBuilder.mo
Unpacking C:\Program Files\PostgreSQL\11\share\i18n\de_DE\StackBuilder.mo
Unpacking C:\Program Files\PostgreSQL\11\share\i18n\sv_SE\StackBuilder.mo
Unpacking C:\Program Files\PostgreSQL\11\share\i18n\zh_CN\StackBuilder.mo
Unpacking C:\Program Files\PostgreSQL\11\StackBuilder_3rd_party_licenses.txt
Unpacking C:\Program Files\PostgreSQL\11\bin\libcurl.dll
Unpacking C:\Program Files\PostgreSQL\11\bin\wxbase28u_vc_custom.dll
Unpacking C:\Program Files\PostgreSQL\11\bin\stackbuilder.exe
Unpacking C:\Program Files\PostgreSQL\11\bin\wxmsw28u_core_vc_custom.dll
Unpacking C:\Program Files\PostgreSQL\11\bin\wxmsw28u_aui_vc_custom.dll
Unpacking C:\Program Files\PostgreSQL\11\bin\wxmsw28u_xrc_vc_custom.dll
Unpacking C:\Program Files\PostgreSQL\11\bin\wxmsw28u_html_vc_custom.dll
Unpacking C:\Program Files\PostgreSQL\11\bin\wxmsw28u_adv_vc_custom.dll
Directory already exists: C:\Program Files\PostgreSQL\11
Directory already exists: C:\Program Files\PostgreSQL\11\bin
Creating directory C:\Program Files\PostgreSQL\11\lib
Directory already exists: C:\Program Files\PostgreSQL\11\installer
Directory already exists: C:\Program Files\PostgreSQL\11\installer\server
Directory already exists: C:\Program Files\PostgreSQL\11\scripts
Directory already exists: C:\Program Files\PostgreSQL\11\scripts\images
Unpacking files
Unpacking C:\Program Files\PostgreSQL\11\lib\libpgtypes.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\libecpg.dll
Unpacking C:\Program Files\PostgreSQL\11\bin\pg_basebackup.exe
Unpacking C:\Program Files\PostgreSQL\11\bin\vacuumlo.exe
Unpacking C:\Program Files\PostgreSQL\11\bin\createdb.exe
Unpacking C:\Program Files\PostgreSQL\11\bin\pg_dumpall.exe
Unpacking C:\Program Files\PostgreSQL\11\bin\pgbench.exe
Unpacking C:\Program Files\PostgreSQL\11\bin\libwinpthread-1.dll
Unpacking C:\Program Files\PostgreSQL\11\bin\pg_restore.exe
Unpacking C:\Program Files\PostgreSQL\11\bin\pg_isready.exe
Unpacking C:\Program Files\PostgreSQL\11\bin\createuser.exe
Unpacking C:\Program Files\PostgreSQL\11\bin\dropdb.exe
Unpacking C:\Program Files\PostgreSQL\11\bin\vacuumdb.exe
Unpacking C:\Program Files\PostgreSQL\11\bin\zlib1.dll
Unpacking C:\Program Files\PostgreSQL\11\bin\reindexdb.exe
Unpacking C:\Program Files\PostgreSQL\11\bin\dropuser.exe
Unpacking C:\Program Files\PostgreSQL\11\bin\clusterdb.exe
Unpacking C:\Program Files\PostgreSQL\11\lib\utf8_and_euc_jp.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\utf8_and_sjis.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\utf8_and_johab.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\plperl.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\pltcl.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\libxslt.lib
Unpacking C:\Program Files\PostgreSQL\11\lib\pg_stat_statements.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\postgres_fdw.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\utf8_and_win.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\utf8_and_euc_cn.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\utf8_and_uhc.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\pgcrypto.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\pgevent.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\libssl.lib
Unpacking C:\Program Files\PostgreSQL\11\lib\utf8_and_euc_tw.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\utf8_and_gbk.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\plugin_debugger.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\dblink.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\seg.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\ltree.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\utf8_and_euc_kr.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\cube.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\plpython3.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\_int.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\utf8_and_sjis2004.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\uuid-ossp.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\utf8_and_big5.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\utf8_and_iso8859.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\isn.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\regress.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\utf8_and_euc2004.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\pageinspect.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\btree_gist.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\hstore.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\plpgsql.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\wxbase28u_net.lib
Unpacking C:\Program Files\PostgreSQL\11\lib\pg_trgm.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\libpq.lib
Unpacking C:\Program Files\PostgreSQL\11\lib\fuzzystrmatch.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\amcheck.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\auth_delay.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\adminpack.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\bloom.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\ascii_and_mic.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\auto_explain.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\autoinc.dll
Unpacking C:\Program Files\PostgreSQL\11\scripts\runpsql.bat
Unpacking C:\Program Files\PostgreSQL\11\lib\insert_username.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\cyrillic_and_mic.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\hstore_plperl.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\euc_jp_and_sjis.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\hstore_plpython3.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\euc_kr_and_mic.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\file_fdw.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\dict_int.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\btree_gin.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\dict_xsyn.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\citext.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\earthdistance.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\euc_cn_and_mic.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\euc2004_sjis2004.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\euc_tw_and_big5.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\pg_visibility.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\pg_freespacemap.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\libpqwalreceiver.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\latin2_and_win1250.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\ltree_plpython3.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\jsonb_plpython3.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\jsonb_plperl.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\pg_prewarm.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\passwordcheck.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\latin_and_mic.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\libecpg_compat.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\moddatetime.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\pg_buffercache.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\lo.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\test_bloomfilter.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\test_decoding.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\test_predtest.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\pgrowlocks.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\sslinfo.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\tcn.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\refint.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\pgstattuple.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\pgoutput.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\test_rbtree.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\tablefunc.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\pgxml.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\iconv.lib
Unpacking C:\Program Files\PostgreSQL\11\lib\libecpg_compat.lib
Unpacking C:\Program Files\PostgreSQL\11\lib\utf8_and_cyrillic.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\libpgtypes.lib
Unpacking C:\Program Files\PostgreSQL\11\lib\utf8_and_ascii.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\tsm_system_time.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\tsm_system_rows.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\libecpg.lib
Unpacking C:\Program Files\PostgreSQL\11\lib\unaccent.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\timetravel.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\libintl.lib
Unpacking C:\Program Files\PostgreSQL\11\lib\utf8_and_iso8859_1.dll
Unpacking C:\Program Files\PostgreSQL\11\installer\server\getlocales.exe
Unpacking C:\Program Files\PostgreSQL\11\installer\server\validateuser.exe
Unpacking C:\Program Files\PostgreSQL\11\installer\server\createuser.exe
Unpacking C:\Program Files\PostgreSQL\11\scripts\images\pg-psql.ico
Unpacking C:\Program Files\PostgreSQL\11\lib\wxbase28u_xml.lib
Unpacking C:\Program Files\PostgreSQL\11\commandlinetools_3rd_party_licenses.txt
Unpacking C:\Program Files\PostgreSQL\11\installer\server\createshortcuts_clt.vbs
Unpacking C:\Program Files\PostgreSQL\11\bin\psql.exe
Unpacking C:\Program Files\PostgreSQL\11\bin\libssl-1_1-x64.dll
Unpacking C:\Program Files\PostgreSQL\11\bin\libcrypto-1_1-x64.dll
Unpacking C:\Program Files\PostgreSQL\11\bin\libiconv-2.dll
Unpacking C:\Program Files\PostgreSQL\11\bin\libintl-9.dll
Unpacking C:\Program Files\PostgreSQL\11\bin\pg_dump.exe
Unpacking C:\Program Files\PostgreSQL\11\bin\libpq.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\wxmsw28u_html.lib
Unpacking C:\Program Files\PostgreSQL\11\lib\libpgport.lib
Unpacking C:\Program Files\PostgreSQL\11\lib\zlib.lib
Unpacking C:\Program Files\PostgreSQL\11\lib\libpgcommon.lib
Unpacking C:\Program Files\PostgreSQL\11\lib\wxmsw28u_core.lib
Unpacking C:\Program Files\PostgreSQL\11\lib\libcrypto.lib
Unpacking C:\Program Files\PostgreSQL\11\lib\dict_snowball.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\wxmsw28u_adv.lib
Unpacking C:\Program Files\PostgreSQL\11\lib\wxmsw28u_aui.lib
Unpacking C:\Program Files\PostgreSQL\11\lib\libxml2.lib
Unpacking C:\Program Files\PostgreSQL\11\lib\utf8_and_gb18030.dll
Unpacking C:\Program Files\PostgreSQL\11\lib\postgres.lib
Unpacking C:\Program Files\PostgreSQL\11\lib\wxbase28u.lib
Unpacking C:\Program Files\PostgreSQL\11\lib\wxmsw28u_xrc.lib
Unpacking C:\Program Files\PostgreSQL\11\lib\libpq.dll
Unpacking C:\Program Files\PostgreSQL\11\installer\vcredist_x64.exe
Unpacking C:\Program Files\PostgreSQL\11\installer\vcredist_x86.exe
Unpacking C:\Program Files\PostgreSQL\11\installer\vcredist_x86_2013.exe
Executing icacls "C:\Users\BATINH\AppData\Local\Temp/postgresql_installer_e0fded4cf2" /inheritance:r
Script exit code: 0

Script output:
 processed file: C:\Users\BATINH\AppData\Local\Temp/postgresql_installer_e0fded4cf2
Successfully processed 1 files; Failed processing 0 files

Script stderr:
 

Executing icacls "C:\Users\BATINH\AppData\Local\Temp/postgresql_installer_e0fded4cf2" /T /Q /grant "BATINH:(OI)(CI)F"
Script exit code: 0

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

Script stderr:
 

[15:58:35] Running the post-installation/upgrade actions:
[15:58:35] Write the base directory to the ini file...
[15:58:36] 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\11/installer/server/initcluster.vbs" "NT AUTHORITY\NetworkService" "postgres" "****" "C:\Users\BATINH\AppData\Local\Temp/postgresql_installer_e0fded4cf2" "C:\Program Files\PostgreSQL\11" "C:\Program Files\PostgreSQL\11\data" 5432 "DEFAULT" 0
Script exit code: 1

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

Called CreateDirectory(C:\Program Files\PostgreSQL\11\data)...
Called CreateDirectory(C:\Program Files\PostgreSQL\11)...
Called ClearAcl (C:\Program Files\PostgreSQL\11\data)...
Remove inherited ACLs on (C:\Program Files\PostgreSQL\11\data)
    Executing batch file 'radE7754.bat'...
    'icacls' is not recognized as an internal or external command,
operable program or batch file.

Failed to remove inherited ACLs on (C:\Program Files\PostgreSQL\11\data)
WScript.Network initialized...
strParentOfDataDirC:\Program Files\PostgreSQL\11
logged in userTIPB-DELL\BATINH
Called AclCheck(C:\Program Files\PostgreSQL\11\data)
Called IsVistaOrNewer()...
    'winmgmts' object initialized...
    Version:10.
    MajorVersion:10
Executing icacls to ensure the TIPB-DELL\BATINH account can read the path C:\Program Files\PostgreSQL\11\data
    Executing batch file 'radE7754.bat'...
    'icacls' is not recognized as an internal or external command,
operable program or batch file.

Called IsVistaOrNewer()...
    'winmgmts' object initialized...
    Version:10.
    MajorVersion:10
Ensuring we can write to the data directory (using icacls) to  TIPB-DELL\BATINH:
    Executing batch file 'radE7754.bat'...
    'icacls' is not recognized as an internal or external command,
operable program or batch file.

Failed to ensure the data directory is accessible (C:\Program Files\PostgreSQL\11\data)
Called IsVistaOrNewer()...
    'winmgmts' object initialized...
    Version:10.
    MajorVersion:10
Granting full access to (NT AUTHORITY\NetworkService) on (C:\Program Files\PostgreSQL\11\data)
    Executing batch file 'radE7754.bat'...
    'icacls' is not recognized as an internal or external command,
operable program or batch file.

Failed to grant access to (NT AUTHORITY\NetworkService) on (C:\Program Files\PostgreSQL\11\data)
Called IsVistaOrNewer()...
    'winmgmts' object initialized...
    Version:10.
    MajorVersion:10
Granting full access to CREATOR OWNER on (C:\Program Files\PostgreSQL\11\data)
    Executing batch file 'radE7754.bat'...
    'icacls' is not recognized as an internal or external command,
operable program or batch file.

Failed to grant access to CREATOR OWNER on (C:\Program Files\PostgreSQL\11\data)
Called IsVistaOrNewer()...
    'winmgmts' object initialized...
    Version:10.
    MajorVersion:10
Granting full access to SYSTEM on (C:\Program Files\PostgreSQL\11\data)
    Executing batch file 'radE7754.bat'...
    'icacls' is not recognized as an internal or external command,
operable program or batch file.

Failed to grant access to SYSTEM on (C:\Program Files\PostgreSQL\11\data)
Called IsVistaOrNewer()...
    'winmgmts' object initialized...
    Version:10.
    MajorVersion:10
Granting full access to Administrators on (C:\Program Files\PostgreSQL\11\data)
    Executing batch file 'radE7754.bat'...
    'icacls' is not recognized as an internal or external command,
operable program or batch file.

Failed to grant access to Administrators on (C:\Program Files\PostgreSQL\11\data)
    Executing batch file 'radE7754.bat'...
    The files belonging to this database system will be owned by user "BATINH".
This user must also own the server process.

The database cluster will be initialized with locale "English_United States.1252".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory C:/Program Files/PostgreSQL/11/data ... initdb: could not change permissions of directory "C:/Program Files/PostgreSQL/11/data": Permission denied

Called Die(Failed to initialise the database cluster with initdb)...
Failed to initialise the database cluster with initdb

Script stderr:
 Program ended with an error exit code

Error running cscript //NoLogo "C:\Program Files\PostgreSQL\11/installer/server/initcluster.vbs" "NT AUTHORITY\NetworkService" "postgres" "****" "C:\Users\BATINH\AppData\Local\Temp/postgresql_installer_e0fded4cf2" "C:\Program Files\PostgreSQL\11" "C:\Program Files\PostgreSQL\11\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\BATINH\AppData\Local\Temp/postgresql_installer_9e70d2bcca" /inheritance:r
Script exit code: 0

Script output:
 processed file: C:\Users\BATINH\AppData\Local\Temp/postgresql_installer_9e70d2bcca
Successfully processed 1 files; Failed processing 0 files

Script stderr:
 

Executing icacls "C:\Users\BATINH\AppData\Local\Temp/postgresql_installer_9e70d2bcca" /T /Q /grant "BATINH:(OI)(CI)F"
Script exit code: 0

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

Script stderr:
 

[16:01:49] Delete the temporary scripts directory...
Executing icacls "C:\Users\BATINH\AppData\Local\Temp/postgresql_installer_ba919868a8" /inheritance:r
Script exit code: 0

Script output:
 processed file: C:\Users\BATINH\AppData\Local\Temp/postgresql_installer_ba919868a8
Successfully processed 1 files; Failed processing 0 files

Script stderr:
 

Executing icacls "C:\Users\BATINH\AppData\Local\Temp/postgresql_installer_ba919868a8" /T /Q /grant "BATINH:(OI)(CI)F"
Script exit code: 0

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

Script stderr:
 

Executing icacls "C:\Users\BATINH\AppData\Local\Temp/postgresql_installer_2525639570" /inheritance:r
Script exit code: 0

Script output:
 processed file: C:\Users\BATINH\AppData\Local\Temp/postgresql_installer_2525639570
Successfully processed 1 files; Failed processing 0 files

Script stderr:
 

Executing icacls "C:\Users\BATINH\AppData\Local\Temp/postgresql_installer_2525639570" /T /Q /grant "BATINH:(OI)(CI)F"
Script exit code: 0

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

Script stderr:
 

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

Script output:
 Start FixupFile(C:\Program Files\PostgreSQL\11\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:
 

[16:01:54] Write the server description to the ini file...
[16:01:54] Write the server branding to the ini file...
Creating Uninstaller
Creating uninstaller 25%
Creating uninstaller 50%
Creating uninstaller 75%
Creating uninstaller 100%
Installation completed
Log finished 08/15/2019 at 16:02:08

 

Level 3 Adventurer

Re: Error when installing postgresql 11.5 on windows 10.

Hi tinhpb ,

 

To troubleshoot this issue further could you please try below and let us now it goes:

1> Try changing the TEMP directory or verify if you have proper permission on TEMP directory,
For Example,
Try to launch the installer from cmd by setting the manual TEMP location,
c:\>mkdir mytemp
c:\>cd mytemp
c:\mytemp>set TEMP=c:\mytemp
c:\mytemp>
c:\mytemp>echo %TEMP%
c:\mytemp
c:\mytemp>c:\postgresql-11.5-1-windows-x64.exe

Check if the installer is able to launch or still you are getting the same error?

2> Can you please confirm if you are running the installer using "Run as Administrator" option?

 

Thanks,

Swagata