PostgreSQL 11.3 and 10.8

Re:PostgreSQL 11.3 and 10.8 by throw0101a on Thursday May 09, 2019 @12:35PM (#19869743)

What do you use? Are there some instructions/articles that you'd recommend reading? Is it anything like Galera?

I know of BDR, but there hasn't much news about it lately, especially with more recent versions of Pg.

We like Galera for our simple needs: we use keepalived to do health checks, and if they pass the node participates in the VRRP cluster. If one node goes down/bad, another takes over.

[ Parent | on HN ]

Re:PostgreSQL 11.3 and 10.8 by duckehlabs on Thursday May 09, 2019 @01:09PM (#19870077)

If you want multi master in Postgres, I think BDR is going to be your best option, but the version for PG 10+ isn't open source so you'll have to pay for it. We're using the open source version on PG 9.4 currently in production, it's worked fine so far.

If you're just looking for a hot standby and dont need a multi master setup, you can set those up just with pg. https://www.postgresql.org/docs/9.4/hot-standby.html

[ Parent | on HN ]