CYBERTEC suggests a mix of Patroni and vipmanager With regards to failover and significant availability in your PostgreSQL database. though preserving a PostgreSQL qualified on personnel may also help to perform this, https://www.ralantech.com/postgresql-database-support-and-services/