3 ms·

I'm curious what you do for Postgres to get an HA, as the last time I worked with Postgres it was a nightmare to get even a bare bones HA working. I swore I'd n

I'm curious what you do for Postgres to get an HA, as the last time I worked with Postgres it was a nightmare to get even a bare bones HA working. I swore I'd never touch it again until they had a real HA solution. I ask ever year or so and keep being told it still doesn't have one.

SteveNuts 9y ago
Patroni is very good and what we use in our environment since it works out of the box with our existing tools (consul, haproxy).
daurnimator 9y ago
Use barman http://www.pgbarman.org/ http://www.pgbarman.org/
- keypusher 9y ago
  Barman appears to be a solution for backups, not HA. If your master fails, you need to restore from the backup, which means downtime.
  - daurnimator 9y ago
    Barman can keep a hot-standby for you. You still need a mechanism to swap over to the standby on failure. However with libpq from postgres 10 you can provide multiple servers. This isn't true HA, but for most people it fits the requirements.
- mkesper 9y ago
  From their FAQ (http://www.pgbarman.org/faq/ http://www.pgbarman.org/faq/): Does barman manage replication and high availability as well? How does it compare with repmgr, OmniPITR, walmgr and similar tools? No. barman aims to be a pure disaster recovery solution. It is responsible for the sole backup of a cluster of PostgreSQL servers. If high availability is what you are looking for, we encourage you to use repmgr. barman specifically targets the DR case only
asah 9y ago
FYI Amazon hosted Postgres (RDS) supports HA - one click during config, and you can add it afterwards in minutes.