failed to load sql modules into the database cluster

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

up vote 5 down vote favorite

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. "failed to load sql modules into the database cluster". "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! postgresql

show 2

share improve this question

Jun 7 '15 at 1:42 John Theuerkauf 28 1 4

5 Answers

active oldest votes

up vote 5 down vote accepted

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

add a comment

share improve this answer

Aug 4 '15 at 17:49 Jeff G 625 3 15

up vote 1 down vote	Changed the data directory to something other than the installation directory of postgres NETWORK SERVICE
	add a comment

share improve this answer

Aug 10 '15 at 9:48 DanB 815 5 11

up vote 1 down vote

What worked for me is, during the install, specifying a Postgre SQL data folder that's outside of any Windows user profile directory (C:\Users), such as C:\postgres-data. My setup: Win 10 Pro PostgreSQL 9.5 RC1 I ran into this issue when I tried setting PostgreSQL's data directory somewhere under my user profile's directory, such us somewhere under "My Documents". I tried Jeff G's solution and it didn't work at first. It worked only when I kept the data directory as the default (C:\Program Files\PostgreSQL\9.5\data). So then I tested further and tried setting the data directory to somewhere outside of any user profile directories (i.e. somewhere that isn't under C:\Users). For example, C:\postgres-data and this worked. I then just tried using that directory with my default user, and not bothering with the postgres temp user as outlined in Jeff G's solution and that also worked. So in the end, it had to do with my data directory being somewhere under C:\Users. As long as it was outside of that, it worked.

add a comment

share improve this answer

Dec 28 '15 at 16:04 gomisha 11 1

up vote 0 down vote	I had the same problem before. I solved this by installing Visual Studio C++ Express first.
	add a comment

share improve this answer

Jul 9 '15 at 2:22 Zhiyong Cai 60 5

up vote 0 down vote

Encountered a very similar problem that OP is reporting today while installing Postgres 9.4. It turns out that the password generator I was using has made a password that contains non-alphanumeric characters. ("^") I believe was the culprit in this case. Removing that allowed the installation of Postgres 9.4 (Windows 64 bit) to complete. Very easy fix once you've found it, but the error message that comes up is not descriptive, so in this case I didn't notice at first what I was doing wrong.

add a comment

share improve this answer

Aug 21 '15 at 17:55 Slave 1