CYBERTEC endorses a mix of Patroni and vipmanager In relation to failover and significant availability on your PostgreSQL database.
Permits the use of dynamic SQL in processes to permit purposes to run SQL statements https://www.ralantech.com/postgresql-database-support-and-services/