Choosing your deployment method#
You can deploy and install EDB Postgres Distributed products using the following methods:
Installing Trusted Postgres Architect (TPA) (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 <Deploying EDB Postgres Distributed using Trusted Postgres Architect> for more information.
BigAnimal is a fully managed database-as-a-service with built-in Oracle compatibility that runs in your cloud account or BigAnimal’s cloud account where it’s operated by our Postgres experts. EDB BigAnimal 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 and multi-region Always On Gold clusters. See Distributed high availability in the BigAnimal 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. This offering is currently in preview.
TPA |
BigAnimal |
Kubernetes (preview) |
|
|---|---|---|---|
Single region |
OK |
OK |
OK |
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 |
OK |
Roadmap |
Roadmap |
Subscriber-only nodes<br/> (read replicas) |
OK |
TBD |
TBD |
Logical standby nodes |
OK |
TBD |
TBD |
PgBouncer |
OK |
TBD |
TBD |
Selective data replication |
OK |
OK |
OK |
Maintenance windows per region |
OK |
OK |
OK |
Target availability |
99.999% SLO |
99.99 SLA (single)<br/>99.995% SLA (multi) |
99.999% SLO |