Choosing your deployment method
===============================

You can deploy and install EDB Postgres Distributed products using the
following methods:

-  

   -  :ref:`Trusted Postgres Architect <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 :ref:`Deploying with TPA <Installing PGD CLI with TPA>`  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 EDB’s 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 clusters. See :ref:`Distributed high availability <Overview of durability options>`  in the :ref:`BigAnimal documentation </biganimal/latest>`  for more
   information.

-  :ref:`EDB Postgres Distributed for Kubernetes </postgres_distributed_for_kubernetes/latest/>`  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.

.. csv-table::
  :header: "",<center>TPA</center>,<center>BigAnimal</center>,<center>Kubernetes</center>
  :widths: 15,12,12,20
  :align: left
  :class: longtable

  Single region,"<span style=""color: green;"">x</span>","<span style=""color: green;"">x</span>","<span style=""color: green;"">x</span>"
  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,"<span style=""color: green;"">x</span>",-,-
  Subscriber-only nodes  (read replicas),"<span style=""color: green;"">x</span>",-,-
  Logical standby nodes,"<span style=""color: green;"">x</span>",-,-
  PgBouncer,"<span style=""color: green;"">x</span>",-,-
  Selective data replication,"<span style=""color: green;"">x</span>","<span style=""color: green;"">x</span>","<span style=""color: green;"">x</span>"
  Maintenance windows per region,"<span style=""color: green;"">x</span>","<span style=""color: green;"">x</span>","<span style=""color: green;"">x</span>"
  Target availability,99.999% SLO,99.99 SLA (single) 99.995% SLA (multi),99.999% SLO