Install and Configure Single DB Postgres SQL

Forum|Forum|10 years ago
November 29, 2015
2 replies
6130 views

I am having a problem making the Postgres SQL works with Thingworx. I want to install a fresh Thingworx server with PostgresSQL. I followed the instructions from https://support.ptc.com/appserver/cs/doc/refdoc.jsp?p=browse_results&Product=ThingWorx&Release=&DocType=&Role= to create the database in ThingworxPostgresqlStorage folder and create another folder-ThingworxPlatform to put the modelproviderconfig.Json file. I can see that the database is created in pgAdmin III.

I deployed the Thingworx.war for Postgres but could not connect to Thingworx server. I got the error page as shown below. It seems like the database is not connected.

Can somebody help?

Thank you.

Install-Upgrade

Best answer by pcheah

I know where is the problem, the problem is with the directory created to store the database.

In the manual, it is written "thingworxpostgresDBSetup –a postgres –u thingworx –l C:\ThingworxPostgresqlStorage", but by default, Thingworx is link to C:\ThingworxStorage. To solve this, I just changed the cmd script to "thingworxPostgresDBSetup –d thingworx –LC:\ThingworxStorage", it works!

note: Remember to set permission to modify this folder (C:\ThingworxStorage) or you will encounter Permission Denied error.

P

pcheah

AuthorAnswer

10-Marble

I know where is the problem, the problem is with the directory created to store the database.

In the manual, it is written "thingworxpostgresDBSetup –a postgres –u thingworx –l C:\ThingworxPostgresqlStorage", but by default, Thingworx is link to C:\ThingworxStorage. To solve this, I just changed the cmd script to "thingworxPostgresDBSetup –d thingworx –LC:\ThingworxStorage", it works!

note: Remember to set permission to modify this folder (C:\ThingworxStorage) or you will encounter Permission Denied error.