Choosing a Postgres distribution

EDB Postgres Distributed can be deployed with three different Postgres distributions: PostgreSQL, EDB Postgres Extended Server, or EDB Postgres Advanced Server. The availability of particular EDB Postgres Distributed features depends on the Postgres distribution being used. Therefore, it’s essential to adopt the Postgres distribution best suited to your business needs. For example, if having the Commit At Most Once (CAMO) feature is mission critical to your use case, don’t adopt open source PostgreSQL, which doesn’t have the core capabilities required to handle CAMO.

The following table lists features of EDB Postgres Distributed that are dependent on the Postgres distribution and version.

Feature	PostgreSQL	EDB Postgres Extended	EDB Postgres Advanced
Commit At Most Once	Y	Y	Y
Commit At Most Once	Y	Y	Y
DDL replication filtering	Y	Y	Y
Commit At Most Once	Y	Y	Y
Commit At Most Once	v14+	v13+	v14+
Commit At Most Once	Y	Y	Y
Subscriber-only nodes	Y	Y	Y
Monitoring	Y	Y	Y
Commit At Most Once	Y	Y	Y
Parallel Apply	Y	Y	Y
Conflict-free replicated data types (CRDTs)	Y	Y	Y
Special problems for column-level conflict resolution	Y	Y	Y
Transform triggers	Y	Y	Y
Conflict triggers	Y	Y	Y
Asynchronous replication	Y	Y	Y
Legacy synchronous replication using PGD	Y	Y	Y
Group commit	N	Y	14+
Commit At Most Once	N	Y	14+
Eager conflict resolution	N	Y	14+
Lag Control	N	Y	14+
Decoding worker	N	13+	14+
Commit At Most Once	N	Y	14+
Commit At Most Once	N	Y	14+
Commit At Most Once	N	Y	14+
Commit At Most Once	N	Y	14+
Transparent Data Encryption	N	15+	15+