cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X

PostgreSQL Version Compatibility

pnash
1-Newbie

PostgreSQL Version Compatibility

Hi

We just thought we would share this..

If you are using an older LTS version of Ubuntu, such as 14.4 or 14.10, you will find Postgres 9.3 in the apt repositories.

This will not work with ThingWorx!

We didn't find any mention of Postgres supported versions in the install guides from 6.5.0 to 7.0.0 onwards, nor in the System Requirements documents. However, we have been answered by PTC Support directly that Postgres 9.3 is not supported​. In fact, in Linux the two *.sg scripts used to create the ThingWorx database and default schemas will not execute properly.

Postges 9.4 and later will be supported now and in the future.

A few useful things...

To update your Ubuntu apt repository to add postgres-9.4, check out this link:

PostgreSQL: Linux downloads (Ubuntu)

Install syntax:

sudo apt-get install postgres-9.4

Install the GUI admin tools:

sudo apt-get install pgadmin3

To connect to Postgres, change the default password and create the "twadmin" user, do the following:

$ sudo -u postgres psql

     postgres=> alter user postgres password 'somePassword';

     postgres=> create user twadmin createdb createuser password 'otherPassword';

     postgres=> \q

$ ...

PS. Don't forget the ";" for the postgres commands

Good luck!

1 REPLY 1
Aanjan
9-Granite
(To:pnash)

Pat, yes, the 9.3 version of Postgres is not supported. PostgreSQL 9.4.4 is mentioned in the ThingWorx6.5PostgreSQL Administrator’s Guide and Installing ThingWorx 6.6 in the 'Prerequisites' and the 'Installing for the first time' sections respectively. The 7.0 installation document references the 9.4.4 version in the installation steps and not anywhere else. I'll reach out to the documentation team to get this sorted out. Thanks!

Top Tags