topic Re: I want to install two separate thingworx instances on a single Postgres server in ThingWorx Developers

I want to install two separate thingworx instances on a single Postgres server

soumya-hcl — Mon, 15 Jul 2019 08:31:31 GMT

I want to install two separate thingworx instances on a single Postgres server by creating different tablespaces, DB and User names. For these I will change the postgres scripts for creating tablespaces. My platformsettings.json will look like below: Is it possible or ThingWorx will throw errors. If it doesn't throw errors will it be OK as per TWX modelling, data structure.

TWX1:

PersistenceProviderPackageConfigs": {
"PostgresPersistenceProviderPackage": {
"ConnectionInformation": {
"jdbcUrl": "jdbc:postgresql://localhost:5432/thingworx1",
"password": "password",
"username": "twadmin1"

TWX2:

Re: I want to install two separate thingworx instances on a single Postgres server

posipova — Mon, 15 Jul 2019 18:57:31 GMT

Would it be a prod server or dev? Do you mean 2 instances and postgres all on the same server or just two separate thingworx servers using the same db? If the latter, yes you can do that as long as the resources allow -- not for production.

If the former, that is not a supported scenario and you'll likely run into two fighting tomcat instances.

Re: I want to install two separate thingworx instances on a single Postgres server

soumya-hcl — Tue, 16 Jul 2019 05:09:10 GMT

It will be the latter where two different thingworx instances connected with the same db server with two different table spaces like thingworx1 and thingworx2