Error: Failed to load SQL Modules into database Cluster.
This error is usually seen during initializing the database cluster phase (in the setup as shown below).
To resolve this issue, follow below steps:
After the successful installation, you can follow the remaining procedure for configuring it with ThingWorx from the respective installation document.
I had also this problem but the solution was not so easy as described above - always got the error.
Solution required for my machine the following steps:
2.)Delete the postgres user if it still exists :
net user postgres /delete
3.) Create the postgres user with a password you can remember:
net user /add postgres <password>
4.) Add the postgres user to the Administrators group:
net localgroup administrators postgres /add
5.) Add the postgres user to the Power Users group
net localgroup "power users" postgres /add
6.) Run a command window as the postgres user:
runas /user:postgres cmd.exe
7.) Run the install file from within the command window.
->his should run the installation successfully.
8.)Remove the postgres user from the Administrators group.
net localgroup administrators postgres /delete
I solved this problem by creating the folder before the installation (C:\PostgreSQL\data) and giving it full access for the group "Users".
I am running Windows 10 enterprise, version 1709, OS Build 16299.371.
This seems to be problem with security.
There is another solution if you want to use the default data folder,
I had a similar problem recently when installing Thingworx 8.1
The solution that worked for me
a) used 9.4.x zip binary (https://www.enterprisedb.com/download-postgresql-binaries)
b) unzip the binary to a folder (this will be your postgres folder)
c) create a database cluster folder (data) and a log folder in the above directory. Give full permission to the user
d) initialize the database cluster
initdb -U postgres -A password -E utf8 -W -D <postgresroot>\data
e) If the above command runs successfully,it will end with the command to start the database.
(next continue with the installation document)