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
Is possible using pg_auto_failover in a solution Postgres DB (TWX version: 9.3.7). New connection string is plane as: postgresql://{primary server name}:port,{primary server name}:port/{nameDB}?target_session_attrs=primary&sslmode=require Do you know somebody then this solutions is possible/ impossible?
It's likely never been tried, but you should look to the JDBC driver class.
Frankly it sounds dangerous as the switchover moment seems uncertain and this could lead to data integrity issues with the ThingWorx model data.
You might try it on a data persistence provider or a DB Thing for data ingestion only to see if you can get it working, but a load balanced highly available database should be used to ensuring ThingWorx availability and integrity.