EDB Postgres Distributed (PGD)¶
EDB Postgres Distributed (PGD) provides multi-master replication and data distribution with advanced conflict management, data-loss protection, and throughput up to 5X faster than native logical replication. It enables distributed Postgres clusters with high availability up to five 9s.
By default, EDB Postgres Distributed uses asynchronous replication, applying changes on the peer nodes only after the local commit. You can configure additional levels of synchronicity between different nodes, groups of nodes, or all nodes by configuring Group Commit ,
pgbench with CAMO/failover options , or Eager conflict resolution Replication.
- Compatibility matrix
- EDB Postgres Distributed Release notes
- Known issues
- Introducing PGD quick starts
- Quick start
- Introducing PGD and TPA
- Selecting Docker, Linux hosts, or AWS quick starts
- Further explorations with your cluster
- Deploying an EDB Postgres Distributed example cluster on Docker
- Deploying an EDB Postgres Distributed example cluster on Linux hosts
- Deploying an EDB Postgres Distributed example cluster on AWS
- Deploying an EDB Postgres Distributed example cluster on Azure and Google cloud platforms
- Connecting to your database
- Exploring failover handling with PGD
- Exploring conflict handling with PGD
- Next Steps with PGD
- Concepts
- Terminology
- Asynchronous replication
- Availability
- CAMO or commit-at-most-once
- Clustering
- Data sharding
- Eager Replication for PGD
- Eventual consistency
- Failover
- Horizontal scaling or scale out
- Logical replication
- Nines
- Node
- Physical replication
- Read scalability
- Recovery point objective (RPO)
- Recovery time objective (RTO)
- Single point of failure (SPOF)
- Switchover
- Synchronous replication
- Two-phase commit (2PC)
- Vertical scaling or scale up
- Write scalability
- Write leader
- PGD overview
- Terminology
- Planning
- Installing
- Using
- Application use
- Application behavior
- Nonreplicated statements
- DML and DDL replication
- Replicating between different release levels
- Replicating between nodes with differences
- Comparison between nodes with differences
- General rules for applications
- Timing considerations and synchronous replication
- Application testing
- Performance testing and tuning
- Use of table access methods (TAMs) in PGD
- Postgres configuration
- Node management
- DDL replication
- Security and roles
- Sequences
- Durability and performance options
- Consistency
- Parallel Apply
- Replication sets
- Application connection management
- Backup and recovery
- Monitoring
- EDB Postgres Distributed Command Line Interface
- Transaction streaming
- Stream triggers
- AutoPartition
- Explicit two-phase commit (2PC)
- Timestamp-based snapshots
- Application use
- Reference
