Using pg_auto_failover with POSTGRES DB in HA

[JH_10228157]

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?

[geva]

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.