PostgreSQL active-active replication, do you really need it? (opens in new tab)

Before we start, what is active-active? Active-active, also referred to as multi-primary, is a setup where multiple database nodes can accept writes at the same time and propagate those changes to the others. In comparison, regular streaming replication in PostgreSQL allows only one node (the primary) to accept writes. All other nodes (replicas) are read-only and follow changes. In an active-active setup: There is no single point of write. Applications can write to any node. The database need...