新安装的Windows 8.1 pro 英文版,在安装postgresql 9.0 9.2 9.4版本的时候会报相同的错误:Failed to load SQL modules into database cluster
不知道是我系统配置存在问题还是这几个版本的数据库存在BUG...........
在网上查找了一下解决方案,大致有如下几种:
修改postgresql数据库安装目录的权限,添加postgres用户权限在该安装目录上,至少为read/write,或者直接Full control,然后重新安装数据库。经验证方法无效。
因为报错步骤是调用的vbs,所以可能是firewall导致的。于是turn off windows firewall。发现问题依旧。
以下给出安装日志,有哪位大神知道如何搞定这个问题还请不吝赐教。
Log started 06/14/2015 at 11:45:34
Preferred installation mode : qt
Trying to init installer in mode qt
Mode qt successfully initialized
Executing C:\Users\Kevin ZHAO\AppData\Local\Temp/postgresql_installer_a869192931/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-9.4 Data Directory. Setting variable iDataDirectory to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-9.4 Base Directory. Setting variable iBaseDirectory to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-9.4 Service ID. Setting variable iServiceName to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-9.4 Service Account. Setting variable iServiceAccount to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-9.4 Super User. Setting variable iSuperuser to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-9.4 Branding. Setting variable iBranding to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-9.4 Version. Setting variable brandingVer to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-9.4 Shortcuts. Setting variable iShortcut to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-9.4 DisableStackBuilder. Setting variable iDisableStackBuilder to empty value
[11:45:40] Existing base directory:
[11:45:40] Existing data directory:
[11:45:40] Using branding: PostgreSQL 9.4
[11:45:40] Using Super User: postgres and Service Account: NT AUTHORITY\NetworkService
[11:45:40] Using Service Name: postgresql-x64-9.4
Executing cscript //NoLogo "C:\Users\Kevin ZHAO\AppData\Local\Temp\postgresql_installer_a869192931\prerun_checks.vbs"
Script exit code: 0
Script output:
The scripting host appears to be functional.
Script stderr:
Executing C:\Users\Kevin ZHAO\AppData\Local\Temp\postgresql_installer_a869192931\vcredist_x64.exe /passive /norestart
Script exit code: 0
Script output:
Script stderr:
Executing C:\Users\Kevin ZHAO\AppData\Local\Temp\postgresql_installer_a869192931\getlocales.exe
Script exit code: 0
Script output:
AfrikaansxxCOMMAxxxxSPxxSouthxxSPxxAfrica=Afrikaans, South Africa
AlbanianxxCOMMAxxxxSPxxAlbania=Albanian, Albania
AlsatianxxCOMMAxxxxSPxxFrance=Alsatian, France
AmharicxxCOMMAxxxxSPxxEthiopia=Amharic, Ethiopia
ArabicxxCOMMAxxxxSPxxAlgeria=Arabic, Algeria
ArabicxxCOMMAxxxxSPxxBahrain=Arabic, Bahrain
ArabicxxCOMMAxxxxSPxxEgypt=Arabic, Egypt
ArabicxxCOMMAxxxxSPxxIraq=Arabic, Iraq
ArabicxxCOMMAxxxxSPxxJordan=Arabic, Jordan
ArabicxxCOMMAxxxxSPxxKuwait=Arabic, Kuwait
ArabicxxCOMMAxxxxSPxxLebanon=Arabic, Lebanon
ArabicxxCOMMAxxxxSPxxLibya=Arabic, Libya
ArabicxxCOMMAxxxxSPxxMorocco=Arabic, Morocco
ArabicxxCOMMAxxxxSPxxOman=Arabic, Oman
ArabicxxCOMMAxxxxSPxxQatar=Arabic, Qatar
ArabicxxCOMMAxxxxSPxxSaudixxSPxxArabia=Arabic, Saudi Arabia
ArabicxxCOMMAxxxxSPxxSyria=Arabic, Syria
ArabicxxCOMMAxxxxSPxxTunisia=Arabic, Tunisia
ArabicxxCOMMAxxxxSPxxUxxDOTxxAxxDOTxxExxDOTxx=Arabic, U.A.E.
ArabicxxCOMMAxxxxSPxxYemen=Arabic, Yemen
ArmenianxxCOMMAxxxxSPxxArmenia=Armenian, Armenia
AssamesexxCOMMAxxxxSPxxIndia=Assamese, India
AzerbaijanixxSPxxxxOBxxCyrillicxxCBxxxxCOMMAxxxxSPxxAzerbaijan=Azerbaijani (Cyrillic), Azerbaijan
AzerbaijanixxSPxxxxOBxxLatinxxCBxxxxCOMMAxxxxSPxxAzerbaijan=Azerbaijani (Latin), Azerbaijan
BanglaxxCOMMAxxxxSPxxBangladesh=Bangla, Bangladesh
BanglaxxCOMMAxxxxSPxxIndia=Bangla, India
BashkirxxCOMMAxxxxSPxxRussia=Bashkir, Russia
BasquexxCOMMAxxxxSPxxSpain=Basque, Spain
BelarusianxxCOMMAxxxxSPxxBelarus=Belarusian, Belarus
BosnianxxSPxxxxOBxxCyrillicxxCBxxxxCOMMAxxxxSPxxBosniaxxSPxxandxxSPxxHerzegovina=Bosnian (Cyrillic), Bosnia and Herzegovina
BosnianxxSPxxxxOBxxLatinxxCBxxxxCOMMAxxxxSPxxBosniaxxSPxxandxxSPxxHerzegovina=Bosnian (Latin), Bosnia and Herzegovina