Failed to load sql modules into the database cluster during PostgreSQL Installation

Question

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.

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".

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:

• 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!

question from:https://stackoverflow.com/questions/30689251/failed-to-load-sql-modules-into-the-database-cluster-during-postgresql-installat

Answer 1

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) 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