Trusted Postgres Architect
enterprisedb.com
- Free plan
- Linux
- Self-hosted
What Trusted Postgres Architect is
Trusted Postgres Architect (TPA) is an Ansible-based tool for deploying and managing Postgres clusters using EDB recommendations. A declarative YAML configuration describes a cluster’s topology and settings. TPA can provision AWS EC2 instances or Docker containers, or work with existing servers and virtual machines when connection details are supplied. It installs and configures Postgres and related components, including replication and backups; the architecture may also include PGD, Barman, PgBouncer, repmgr and extensions. The tool can test a deployed cluster for its architecture and platform, apply configuration changes, perform switchovers and carry out minor-version upgrades described as zero-downtime. Its configuration documentation lists PostgreSQL, EDB Postgres Extended and EDB Postgres Advanced Server versions 13 through 18. STIG and CIS configuration options are available, but EDB does not guarantee that they ensure compliance. TPA is free and open source for self-hosted Linux deployments. It does not support major-version Postgres upgrades through `tpaexec upgrade`.
Who it suits
TPA is aimed at teams deploying Postgres clusters, from testbeds to production environments, who can work with Ansible and YAML. Its deployment options suit teams using cloud instances, containers or existing servers.
Good to know, and what to watch
- Can provision EC2 instances or Docker containers.
- Can deploy to existing servers and virtual machines.
- Supports configuration changes and switchovers.
- Includes architecture- and platform-specific cluster tests.
- Encrypts sensitive variables with a cluster-specific Ansible Vault password.
- Major-version upgrades are not supported through `tpaexec upgrade`.
- STIG and CIS options do not guarantee compliance.
- Automation Platform deployment support is limited to bare metal.
Plans
Every plan and priceTrusted Postgres Architect
Open source
Getting started
- Open the Trusted Postgres Architect documentation website
- Use a Linux self-hosted environment
- Describe the cluster topology and settings in declarative YAML
- Choose AWS EC2, Docker containers, or provide existing server connection details
- Deploy Postgres and associated components with TPA
Limits to check
TPA does not perform major-version Postgres upgrades through the tpaexec upgrade command. Red Hat Ansible Automation Platform deployment and upgrade support is limited to bare-metal platforms.
The verdict
TPA covers cluster deployment and ongoing changes, including minor-version upgrades, with flexible infrastructure options. Plan major-version upgrades separately, and treat its STIG and CIS settings as options rather than a compliance guarantee.
Questions people ask
Is Trusted Postgres Architect free?
Yes. The listed Trusted Postgres Architect plan costs nothing, and the project is open source.
Which platforms does TPA support?
It targets Linux and self-hosted deployments, with a hybrid deployment model. It can provision AWS EC2 instances and Docker containers or use existing servers and virtual machines.
Which database versions are supported?
The configuration documentation lists PostgreSQL, EDB Postgres Extended and EDB Postgres Advanced Server versions 13 through 18.
Can TPA manage high availability and replication?
Yes. It installs and configures replication and backups, supports high-availability management, and can perform switchovers.
Does TPA support security configuration?
It offers STIG and CIS configuration options and generates a cluster-specific Ansible Vault password for sensitive variables.
What the maker publishes
- Automation Platform integration
- TPA supports deploy and upgrade steps through Red Hat Ansible Automation Platform, with support limited to bare-metal platforms. source
- Cluster management
- TPA supports configuration changes, switchovers, and minor-version upgrades described as zero-downtime. source
- Components
- Depending on the architecture, associated components include PGD, Barman, PgBouncer, repmgr, and Postgres extensions. source
- Configuration
- It uses declarative YAML configuration to describe a cluster from its topology through configuration details. source
- Credential protection
- TPA generates a cluster-specific Ansible Vault password to encrypt sensitive variables, and the documented system keyring option stores that password in a system keyring backend. source
- Deployment
- TPA installs and configures Postgres and associated components, including replication and backups. source
- Extensibility
- Users can add custom Ansible commands, tests, and deployment hook scripts. source
- Founded
- 2004 source
- Headquarters
- Wilmington, Delaware, United States source
- Intended users
- EDB describes TPA recommendations as suitable for both quick testbed setups and production environments. source
- Maker
- EDB's 2025 blog says the company was founded in 2004 and gives its mailing address as Wilmington, Delaware. source
- Platforms
- The documentation lists AWS, bare metal, and Docker as TPA platforms and says clusters can span multiple platforms. source
- Provisioning
- TPA can provision AWS EC2 instances and Docker containers or use existing servers and virtual machines when connection details are supplied. source
- Purpose
- TPA is an Ansible-based orchestration tool that deploys Postgres clusters according to EDB recommendations. source
- Security
- TPA offers STIG and CIS configuration options, but EDB says these do not guarantee that a cluster fulfils the relevant standard. source
- Supported database versions
- The configure documentation lists PostgreSQL, EDB Postgres Extended, and EDB Postgres Advanced Server versions 13 through 18. source
- Testing
- TPA runs architecture and platform-specific tests against a deployed cluster. source
- Upgrade limitation
- The upgrade documentation says TPA does not support major-version upgrades of Postgres through the `tpaexec upgrade` command. source
Checked against the maker's pages on 30 Sept 2026.