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:
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';
PS. Don't forget the ";" for the postgres commands
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!