Skip to main content
15-Moonstone
September 27, 2017
Solved

Problem running thingworxPostgresDBSetup.bat for setting up PostgreSQL for Thingworx.

  • September 27, 2017
  • 1 reply
  • 7234 views

Hello Team,

I have installed Thingworx 8.0 version. After the thingworx installation i am trying to configure PostgreSQL 9.5.

Downloaded the batch files required to configure thingworx DB.

Created folders in the root directory as per the document and provided necessary privileges.

Configured the batch file and running it, i am getting the below error.

Thanks

Sunay

Best answer by supandey

Hi Sunay, PostgreSQL 9.5 is currently not supported, please see system requirements guide for ThingWorx 8.0 You will need 9.4


Plus it appears you might not have created the twadmin role for the PostgreSQL server prior to running this batch file.

1 reply

supandey5-Regular MemberAnswer
5-Regular Member
September 27, 2017

Hi Sunay, PostgreSQL 9.5 is currently not supported, please see system requirements guide for ThingWorx 8.0 You will need 9.4


Plus it appears you might not have created the twadmin role for the PostgreSQL server prior to running this batch file.

sbt15-MoonstoneAuthor
15-Moonstone
September 27, 2017

Alright sushant,

Do i need to installed postgresql and run all the batch files before installing thingworx 8.0 in my system..?

5-Regular Member
September 27, 2017

Yes, as also highlighted in the setup guide for ThingWorx, you will need to have user role read + the ThingWorx DB and it's schema setup prior to deploying and starting ThingWorx's war file in Tomcat.