Postgresql 未能正确安装

Question

最近几天我一直在尝试安装 PostgreSQL 9.2。我想我已经尝试了所有可以在网上找到的方法，但服务仍然无法启动。我目前正在运行 Windows 7 SP1。我曾经安装过 PostgreSQL 8.3 并且运行良好，但几周前我决定卸载它。我彻底卸载了它(删除了 postgres 用户和数据文件)，现在每次我尝试安装任何版本时，我都会在安装结束时加载数据库模块时遇到这个非 fatal error 。我设法看到 postgresql 服务没有启动，或者正如 Windows 所说，它启动然后停止。这是安装日志文件的相关部分:

成功处理了771个文件；处理 0 个文件失败

initcluster.vbs 运行完成

脚本标准错误:

Configuring database server startup...Executing cscript //NoLogo "C:\Program Files (x86)\PostgreSQL\9.2\installer\server\startupcfg.vbs" 9.2 "NT AUTHORITY\NetworkService" "****" "C:\Program Files (x86)\PostgreSQL\9.2" "C:\Program Files (x86)\PostgreSQL\9.2\data" "postgresql-9.2"Script exit code: 0Script output: startupcfg.vbs ran to completionScript stderr:Creating menu shortcuts...Executing cscript //NoLogo "C:\Program Files (x86)\PostgreSQL\9.2\installer\server\createshortcuts.vbs" 9.2 "postgres" 5432 "PostgreSQL 9.2 (x86)" "C:\Program Files (x86)\PostgreSQL\9.2" "C:\Program Files (x86)\PostgreSQL\9.2\data" "postgresql-9.2"Script exit code: 0Script output: Start FixupFile(C:\Program Files (x86)\PostgreSQL\9.2\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 (x86)\PostgreSQL\9.2\scripts\runpsql.bat)...   Opening file for reading...   Closing file (reading)...   Replacing placeholders...   Opening file for writing...   Closing file...  End FixupFile()...createshortcuts.vbs ran to completionScript stderr:Starting the database server...Executing cscript //NoLogo "C:\Program Files (x86)\PostgreSQL\9.2\installer\server\startserver.vbs" postgresql-9.2Script exit code: 0Script output: Starting postgresql-9.2Service postgresql-9.2 started successfullystartserver.vbs ran to completionScript stderr:Loading additional SQL modules...Executing cscript //NoLogo "C:\Program Files (x86)\PostgreSQL\9.2\installer\server\loadmodules.vbs" "postgres" "****" "C:\Program Files (x86)\PostgreSQL\9.2" "C:\Program Files (x86)\PostgreSQL\9.2\data" 5432Script exit code: 2Script output: Installing the adminpack module in the postgres database...    Executing 'C:\Users\George\AppData\Local\Temp\radA5996.bat'...psql: server closed the connection unexpectedly    This probably means the server terminated abnormally    before or while processing the request.Failed to install the 'adminpack' module in the 'postgres' databaseloadmodules.vbs ran to completionScript stderr: Program ended with an error exit codeError running cscript //NoLogo "C:\Program Files (x86)\PostgreSQL\9.2\installer\server\loadmodules.vbs" "postgres" "****" "C:\Program Files (x86)\PostgreSQL\9.2" "C:\Program Files (x86)\PostgreSQL\9.2\data" 5432 : Program ended with an error exit code[10:34:28] Write the data directory to the ini file...[10:34:28] Write the port number, service ID, locale and superuser to the ini file...[10:34:28] Write ServiceID(postgresql-9.2) to registry/ini...[10:34:28] Write Superuser to ini file and windows registry...[10:34:28] Write Service Account to ini file and windows registry...[10:34:28] Write the server description to the ini file...[10:34:28] Write the server branding to the ini file...[10:34:28] Write the 'whether stack-builder is disabled or not' to the ini file...[10:34:29] Finished running post-installation/upgrade tasks.Creating UninstallerCreating uninstaller 25%Creating uninstaller 50%Creating uninstaller 75%Creating uninstaller 100%Installation completed

Answer 1

我遇到了同样的问题。有一次它需要通过互联网连接获取一个包。这是不对的，因为安装包可以在没有连接的情况下安装，但事实就是如此。您的防火墙正在阻止安装。这是您需要做的:

关闭 Windows 防火墙(控制面板\所有控制面板项\Windows 防火墙\自定义设置)

如果您使用这个很棒的程序，请关闭防火墙控制(从任务栏退出或使用任务管理器终止 UI 和服务 - 2 项)

用于下载选定的软件包:关闭 key 保护服务:关闭基础过滤(让你不 protected !- 依赖项将在 BFE 重新启动时重新启动)基本过滤引擎 IKE 和 AuthIP IPsec 键控模块 IPsec 策略代理 集成电路 ...

不要忘记重新启动所有保护。