23 ms·
Postgres doesn't have a great solution for any replication, not just master-master. Lots of things are just half-baked and very clumsy in Postgres compared to
by otabdeveloper4 6y ago
Postgres doesn't have a great solution for any replication, not just master-master.
Lots of things are just half-baked and very clumsy in Postgres compared to MySQL (MariaDB).
- Tostino 6y agoStreaming replication works great in Postgres.
- skeletal88 6y agoWould downvote if I could, PostgreSQL has Patroni, for example, the newest replication management tool, which works. They got rid of the requirement for an external DCS with the latest major release, so.. it's easy to set up and manage When PostgreSQL would get a built-in replication tool would increase it's popularity a lot, but I guess the core team wants to focus on the DB, and management tools are left to the others to develop.
- otabdeveloper4 6y agoI think you just proved my point. IMO replication is a core feature of a DBMS (like transactions or SQL support), the fact that you need to install obscure third-party tools to bring Postgres into the modern age is bonkers.