|
I think there is no gold-standard HA solution. Some commercial PostgreSQL offer HA as an add-on or standalone product, and they tackle different
SPOFs with varying components. If you got the open source way, a good starting point is
https://www.postgresql.org/docs/current/high-availability.html Depending on your requirements you may go one route or another. For exemple, it may be ok for you a single pgpool-2 instance, without front Haproxy
tier. We tested some of them, and we don’t use any of them so far. In our scenario we can assume some out of office downtime for maintenance tasks. Good luck, Gabriel |
