Choosing your deployment method v5.6
You can deploy and install EDB Postgres Distributed products using the following methods:
Trusted Postgres Architect (TPA) is an orchestration tool that uses Ansible to build Postgres clusters using a set of reference architectures that document how to set up and operate Postgres in various scenarios. TPA represents the best practices followed by EDB, and its recommendations apply to quick testbed setups just as they do to production environments. TPA's flexibility allows deployments to virtual machines, AWS cloud instances, or Linux host hardware. See Deploying with TPA for more information.
EDB Postgres AI Cloud Service is a fully managed database-as-a-service with built-in Oracle compatibility that runs in your cloud account or Cloud Service's cloud account where it's operated by EDB's Postgres experts. EDB Postgres AI Cloud Service makes it easy to set up, manage, and scale your databases. The addition of distributed high-availability support powered by EDB Postgres Distributed (PGD) enables single- and multi-region Always-on clusters. See Distributed high availability in the Cloud Service documentation for more information.
EDB Postgres Distributed for Kubernetes is a Kubernetes operator designed, developed, and supported by EDB. It covers the full lifecycle of highly available Postgres database clusters with a multi-master architecture, using PGD replication. It's based on the open source CloudNativePG operator and provides additional value, such as compatibility with Oracle using EDB Postgres Advanced Server, Transparent Data Encryption (TDE) using EDB Postgres Extended or Advanced Server, and additional supported platforms including IBM Power and OpenShift.
Cloud Service | |||
---|---|---|---|
Single region | ✓ | ✓ | ✓ |
Active-Active support | 2+ regions | 2 regions | 2 regions |
Write/Read routing | Local or global | Local | Local |
Automated failover | AZ or Region | AZ | AZ |
Major version upgrades | ✓ | - | - |
Subscriber-only nodes (read replicas) | ✓ | - | - |
Logical standby nodes | ✓ | - | - |
PgBouncer | ✓ | - | - |
Selective data replication | ✓ | ✓ | ✓ |
Maintenance windows per region | ✓ | ✓ |