CYBERTEC recommends a combination of Patroni and vipmanager In regards to failover and substantial availability for your personal PostgreSQL database. relationship pooling optimizes PostgreSQL substantial availability https://www.ralantech.com/postgresql-database-support-and-services/