CYBERTEC endorses a mix of Patroni and vipmanager In relation to failover and substantial availability for your personal PostgreSQL database.
when PostgreSQL does Have a very durability-minded synchronous replication, https://www.ralantech.com/postgresql-database-support-and-services/