EDB Postgres Distributed (PGD) offers advanced functionality beyond day-to-day configuration and management, including DDL replication, replication sets, distributed sequences, stream triggers, and other lower-level protocol details.
DDL replication
How DDL is replicated in PGD and when it isn't
Application use
How to develop an application that uses PGD and how PGD behaves with applications
Decoding worker
Decoding worker in PGD reduces CPU overhead and increases replication throughput by enabling a optimized decoding worker process.
CDC Failover support
CDC Failover support (PGD Logical Slot Failover) with EDB Postgres Advanced Server and EDB Postgres Extended Server
Parallel Apply
A feature of PGD that allows a PGD node to use multiple writers per subscription.
Replication sets
Grouping tables to enable more complex replication topologies.
Security and roles
Security, roles, and access control in EDB Postgres Distributed.
Sequences
Globally distributed sequences in PGD, how they work, and how to use them.
Large objects
How PGD mirrors the PostgreSQL large object interface and replicates large objects across all nodes in the cluster.
Stream triggers
How to trigger additional data processing on a downstream/target node using stream triggers in PGD.
Transaction streaming
Transaction streaming in PGD.
Two-phase commit
Explicit two-phase commit in PGD and how to use it.