EDB Postgres Distributed
PGD is a project aiming to provide multi-master replication with PostgreSQL. There is a range of possible architectures. The first use case we support is all-nodes-to-all-nodes. PGD will eventually support a range of complex architectures, which will be discussed later.
With PGD, the nodes in a cluster can be distributed physically, allowing worldwide access to data, as well as DR. Each PGD primary node runs individual transactions; there is no globally distributed transaction manager. PGD includes replication of data changes such as DML, as well as DDL changes. New tables are added automatically to replication, ensuring that managing PGD is a low-maintenance overhead for applications.
PGD also provides global sequences, if you wish to have a sequence that works across a distributed system where each node can generate new IDs. The usual local sequences are not replicated.
One key advantage of PGD is that you can segregate your write workload across...
