Skip to main content
S
soumya-hcl1-Visitor
1-Visitor
July 15, 2019
Solved

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

  • July 15, 2019
  • 2 replies
  • 1346 views

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:

PersistenceProviderPackageConfigs": {
"PostgresPersistenceProviderPackage": {
"ConnectionInformation": {
"jdbcUrl": "jdbc:postgresql://localhost:5432/thingworx2",
"password": "password",
"username": "twadmin2"

 

Best answer by posipova

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.

2 replies

P
posipova20-TurquoiseAnswer
20-Turquoise
July 15, 2019

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.

S
soumya-hcl1-VisitorAuthor
1-Visitor
July 16, 2019
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
Terms & ConditionsAccessibility statement