News for hackers. Stuff that matters.

A comment on PostgreSQL Is the Database Management System of the Year 2024. Parent comment

Re:PostgreSQL Is the Database Management System of the Year ... by qaq on Tuesday January 14, 2025 @08:35AM (#42696986)
Problem is primary devs of Postgres are consulting shops that make money in this space so making it seamless would affect their revenue
[ Parent | on HN ]
Re:PostgreSQL Is the Database Management System of the Year ... by throw0101c on Tuesday January 14, 2025 @09:52AM (#42697890)
E.g.,

* https://www.enterprisedb.com/docs/pgd/4/bdr/

[ Parent | on HN ]
Re:PostgreSQL Is the Database Management System of the Year ... by eatonphil on Tuesday January 14, 2025 @10:55AM (#42698799)
I work on PGD but I'm pretty sure we actively support open-source options for HA:

https://github.com/EnterpriseDB/repmgr

[ Parent | on HN ]
Re:PostgreSQL Is the Database Management System of the Year ... by throw0101c on Tuesday January 14, 2025 @03:47PM (#42703624)
Repmgr is handy, but it is not a replication system per se, but rather makes managing a bunch of moving other parts easier.

Personally I'd like BDR to be in the main tree, or something else, equivalent to Galera:

* https://galeracluster.com

It's not perfect [1], but it'll get you a good way for many use cases.

[1] https://aphyr.com/posts/327-jepsen-mariadb-galera-cluster

[ Parent | on HN ]