Postgresql数据库安装报错

在Windows 8.1英文版中尝试安装PostgreSQL 9.0, 9.2, 9.4版本时遇到'Failed to load SQL modules into database cluster'错误。尝试了修改安装目录权限、关闭防火墙等方法均未解决问题。日志显示可能与注册表键值缺失和数据库服务配置有关。寻求解决方案。" 138364472,23135242,前端开发必备:12款实用小插件介绍,"['前端开发', 'JavaScript', '插件', '状态管理', '视频播放']
摘要由CSDN通过智能技术生成

新安装的Windows 8.1 pro 英文版,在安装postgresql 9.0 9.2 9.4版本的时候会报相同的错误:Failed to load SQL modules into database cluster

不知道是我系统配置存在问题还是这几个版本的数据库存在BUG...........

在网上查找了一下解决方案,大致有如下几种:

  1. 修改postgresql数据库安装目录的权限,添加postgres用户权限在该安装目录上,至少为read/write,或者直接Full control,然后重新安装数据库。经验证方法无效。

  2. 因为报错步骤是调用的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

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值