PostgreSQL安装期间无法将sql模块加载到数据库集群中 [英] Failed to load sql modules into the database cluster during PostgreSQL Installation

问题描述

我尝试多次安装PostgreSQL 9.4和8.4，无论我尝试了什么，它都失败了。我正在尝试在Windows 7 SP1 x64上安装。每次失败安装后，我都卸载并删除了安装文件夹以重新开始安装。

I have attempted to install PostgreSQL 9.4 and 8.4 multiple times and it is failing no matter what I have tried. I am attempting to install on Windows 7 SP1 x64. After each failed install I have uninstalled and deleted the installation folder to start fresh.

每次尝试安装时，都会在安装结束时弹出错误提示： ：
无法将sql模块加载到数据库集群中。

Each time I attempt the install I get an error pop up near the end of installation that says: "failed to load sql modules into the database cluster".

然后在显示以下错误消息后立即弹出另一个错误：
安装后运行步骤时出错。安装可能无法正确完成。读取C：/ Program Files / PostgreSQL / 9.4 / postgresql.conf时出错

Then another error pop up displays immediately after that says: "Error running post install step. Installation may not complete correctly. Error reading C:/Program Files/PostgreSQL/9.4/postgresql.conf"

我尝试通过以下操作进行安装：

I have attempted installation with the following actions:

• 始终以管理员身份安装


• 关闭所有病毒防护和Windows防火墙


• 将安装目录更改为Program Files目录之外的其他目录。


• 将数据目录更改为某些目录除了postgres的安装目录

• Always installed as administrator
• Turned off all virus protection and windows firewall
• Changed the installation directory to something other than the Program Files directory.
• Changed the data directory to something other than the installation directory of postgres

以上操作均无济于事，我总是收到错误。

None of the actions above have helped and I always receive the error. Any help that someone can provide would be greatly appreciated!

推荐答案

我在尝试安装PostgreSQL v9.4.4时遇到了同样的错误。在Windows 10专业版上。从托管在Stack Exchange上的解决方案开始，我想到了以下步骤使安装程序成功运行：

I was getting this same error when trying to install PostgreSQL v9.4.4 on Windows 10 Pro. Starting with a solution hosted on Stack Exchange, I came up with the following steps that allowed the installer to run successfully:

1）创建一个名为 postgres < br>
2）将新帐户添加到 Administrators 和 Power Users 组中

3）重新启动计算机

   注意：我添加了步骤＃3，因为没有它，步骤＃4就无法工作

4）使用以下命令以postgres用户身份运行命令提示符：

   ;  runas / user：postgres cmd.exe

5）从 postgres 命令窗口运行安装程序

6）删除 postgres 用户帐户以及用户目录

   注意：我添加了步骤＃6，因为安装后不需要postgres帐户

1) Create a new user account, called postgres
2) Add the new account to the Administrators and Power Users groups
3) Restart the computer
    NOTE: I added step #3, since step #4 didn't work without it
4) Run a command prompt as the postgres user, using the command:
    runas /user:postgres cmd.exe
5) Run the installer from the postgres command window
6) Delete the postgres user account, as well as the user directory
    NOTE: I added step #6, since the postgres account is not required after installation

这篇关于PostgreSQL安装期间无法将sql模块加载到数据库集群中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！