Hacker News Reader

Is there a Galera-equivalent system available of Postgres? I.e., multi-master replication.

I know of BDR, but that doesn't seem to be publicly available for recent versions of Pg?

Not sure about master-master, but I've used repmgr[1] to manage a PostgreSQL master-slave setup and it works pretty well though it is by no-means plug and play. There are a variety of steps and manual processes to get it up and running.

[1] https://repmgr.org/

We find it handy to have multi-master, which leans towards being more active-active: we have keepalived doing health checks on two systems, and point our app server(s) at a vIP.

The app server runs Galera's arbd so we don't need three DBs.

It's not a Postgres, but has a some limited Postgres dialect: CockroachDB. It has a range-based master-slave replication with routing and therefore you can use it instead of master-master replicated solutions. Be aware of high latency of distributed databases.

Reply on news.ycombinator.com