Skip to main content
J
JH_102281571-Visitor
1-Visitor
September 6, 2023
Question

Using pg_auto_failover with POSTGRES DB in HA

  • September 6, 2023
  • 1 reply
  • 828 views

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?

 

 

 

 

 

1 reply

G
geva15-Moonstone
15-Moonstone
November 7, 2023

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.

Terms & ConditionsAccessibility statement