Skip to main content
S
sabharees15-Moonstone
15-Moonstone
September 27, 2022
Solved

Can we use RDS as complete DB for thingworx foundation?

  • September 27, 2022
  • 1 reply
  • 1478 views

I have a few applications which have heavy queries to read and write the stream data also complex services/mashups as well. Now, We have DB and TWX foundation both in the same EC2 instance. 

 

To reduce the load I would like to move my entire DB to AWS RDS PSQL.  It is good to proceed with this approach or should I create a separate EC2 instance to host my Postgres?

Also, We have manufacturing apps in the instance it has custom tables in the main DB. 

 

Changing the stream data to another DB is not helping I tried to use an external DB as ThingworxPersistenceProvider, it is reducing the load but still, due to a load of services and application model postgres service consumes high cpu utilization. 

Best answer by sabharees

I have received information from platform support team like AWS RDS is not officially supported by the support matrix of thingworx.

1 reply

P
PaiChung22-Sapphire I
22-Sapphire I
September 28, 2022

AWS RDS should be fine, Just make sure you have a compatible version of Postgres provided.

S
sabharees15-MoonstoneAuthorAnswer
15-Moonstone
September 28, 2022

I have received information from platform support team like AWS RDS is not officially supported by the support matrix of thingworx.

P
PaiChung22-Sapphire I
22-Sapphire I
September 28, 2022

That is unfortunate, I do know it works (I've done some projects with AWS RDS) but if it is not officially supported, it would make it hard to get official technical support from PTC.

    Terms & ConditionsCookie settingsAccessibility statement