Trusted Postgres Architect

© Copyright EnterpriseDB UK Limited 2015-2026 - All rights reserved.

• Introduction
  • What can TPA do?
  • How do I use it?
    • Configuration
    • Provisioning
    • Deployment
    • Testing
    • Incremental changes
    • Cluster management
    • Extensible through Ansible
  • It’s just Postgres
  • Versioning in TPA
    • Backwards compatibility
  • Getting started
• Trusted Postgres Architect release notes
  • Trusted Postgres Architect 23.44.0 release notes
    • Highlights
    • Enhancements
    • Changes
    • Bug Fixes
    • Deprecations
  • Trusted Postgres Architect 23.43.0 release notes
    • Highlights
    • Enhancements
    • Changes
    • Bug Fixes
  • Trusted Postgres Architect 23.42.0 release notes
    • Highlights
    • Enhancements
    • Changes
    • Bug Fixes
  • Trusted Postgres Architect 23.41.0 release notes
    • Highlights
    • Enhancements
    • Changes
    • Bug Fixes
  • Trusted Postgres Architect 23.40.1 release notes
    • Bug Fixes
  • Trusted Postgres Architect 23.40.0 release notes
    • Enhancements
    • Changes
    • Bug Fixes
  • Trusted Postgres Architect 23.39.0 release notes
    • Highlights
    • Enhancements
    • Changes
    • Bug Fixes
  • Trusted Postgres Architect 23.38.1 release notes
    • Bug Fixes
  • Trusted Postgres Architect 23.38.0 release notes
    • Highlights
    • Enhancements
    • Changes
    • Bug Fixes
  • Trusted Postgres Architect 23.37.0 release notes
    • Highlights
    • Enhancements
    • Changes
    • Bug Fixes
  • Trusted Postgres Architect 23.36.0 release notes
    • Highlights
    • Enhancements
    • Changes
    • Bug Fixes
  • Trusted Postgres Architect 23.35.0 release notes
    • Highlights
    • Enhancements
    • Changes
    • Bug Fixes
  • Trusted Postgres Architect 23.34.1 release notes
  • Trusted Postgres Architect 23.34 release notes
  • Trusted Postgres Architect 23.33 release notes
  • Trusted Postgres Architect 23.32 release notes
  • Trusted Postgres Architect 23.31 release notes
  • Trusted Postgres Architect 23.30 release notes
  • Trusted Postgres Architect 23.29 release notes
  • Trusted Postgres Architect 23.28 release notes
  • Trusted Postgres Architect 23.27 release notes
  • Trusted Postgres Architect 23.26 release notes
  • Trusted Postgres Architect 23.25 release notes
  • Trusted Postgres Architect 23.24 release notes
  • Trusted Postgres Architect 23.23 release notes
  • Trusted Postgres Architect 23.22 release notes
  • Trusted Postgres Architect 23.21 release notes
  • Trusted Postgres Architect 23.20 release notes
  • Trusted Postgres Architect 23.19 release notes
  • Trusted Postgres Architect 23.18 release notes
  • Trusted Postgres Architect 23.17 release notes
  • Trusted Postgres Architect 23.16 release notes
  • Trusted Postgres Architect 23.15 release notes
  • Trusted Postgres Architect 23.14 release notes
  • Trusted Postgres Architect 23.13 release notes
  • Trusted Postgres Architect 23.12 release notes
  • Trusted Postgres Architect 23.1 to 23.11 release notes
    • TPA 23.11
    • TPA 23.10
    • TPA 23.9
    • TPA 23.8
    • TPA 23.7
    • TPA 23.6
    • TPA 23.5
    • TPA 23.4
    • TPA 23.3
    • TPA 23.2
    • TPA 23.1
• TPA installation
  • Quickstart
    • Install TPA
    • Install additional dependencies
    • Verify installation (run as a normal user)
  • Where to install TPA
  • Installing TPA packages
    • Install on Debian or Ubuntu
    • Install on RHEL, Rocky, AlmaLinux or Oracle Linux
    • SLES
  • Setting up the TPA Python environment
  • Installing TPA without internet or network access (air-gapped)
    • Downloading TPA packages
    • Installing without access to a Python package index
  • Verifying your TPA installation
  • Upgrading TPA
  • Ansible versions
• Open source TPA
  • What is Trusted Postgres Architect (TPA)?
  • Next Steps
  • TPA Open Source FAQs
    • Can I use this if I’m not an EDB customer?
    • Can I report an issue?
    • Can I contribute?
• Known issues
  • EFM clusters with more than one location are missing inter-location HBA rules (TPA-1247)
    • Details
    • Workaround
  • PGD clusters deployed with TPA 23.34 or earlier have primary_slot_name set preventing bdr_init_physical from working (TPA-1229)
    • Details
    • Workaround
  • SSH configuration templating error in clusters using forward_ssh_agent: true
    • Details
    • Workaround
  • PEM agent registration options provided by pemagent_registration_opts are not reflected in agent.cfg and therefore do not take effect (TPA-1376)
    • Details
    • Workaround
  • PEM 10.4.x web application shows “Internal Server Error” when deployed using TPA (TPA-1415)
    • Details
    • Workaround
• Installing TPA from source
  • Prerequisites
  • Clone and setup
  • Dependencies
    • Python 3.12+
    • Virtual environment options
• CREATING A CLUSTER
  • A First Cluster Deployment
    • Installing TPA
    • Installing Docker
    • Creating a configuration with TPA
  • Cluster configuration
    • Quickstart
    • Configuration options
    • Software selection
    • Overrides
    • Ansible Tower
    • PGAI agent
    • Git repository
    • Keyring backend for vault password
    • Examples
  • tpaexec provision
    • Prerequisites
    • Quickstart
    • Options
    • Accessing the instances
    • Generated files
  • tpaexec deploy
    • Prerequisites
    • Quickstart
    • Selective deployment
    • deploy.yml
  • tpaexec test
    • Quickstart
• ARCHITECTURES
  • PGD-S
    • Cluster configuration
  • PGD-X
    • Cluster configuration
  • PGD-Always-ON
    • Cluster configuration
  • PGD Lightweight
    • Cluster configuration
  • BDR-Always-ON
    • Cluster configuration
  • M1
    • Failover management
    • Cluster configuration
• PLATFORMS
  • aws
    • API access setup
    • Introduction
    • Configuration
  • bare(-metal servers)
    • SSH access
    • Distribution support
    • IP addresses
    • Starting afresh
  • Docker
    • Synopsis
    • Operating system selection
    • Installing Docker
    • Docker container management
• CUSTOMIZATIONS
  • Cluster configuration
    • config.yml
    • Variables
    • Cluster variables
    • Instance variables
    • instance_defaults
    • Locations
  • Instance configuration
    • System-level configuration
    • Postgres
    • Other components
    • After starting Postgres
  • Building from source
    • Quickstart
    • Configuration
    • Local source directories
    • Rebuilding
  • TPA hooks
    • Summary
    • General-purpose hooks
    • PGD hooks
    • Other hooks
    • New hooks
• CLUSTER MANAGEMENT
  • Upgrading your cluster
    • Before you upgrade
    • During the upgrade
    • After the upgrade
    • Recovering from a failed upgrade
    • Common pitfalls
    • Component selection
    • Package version selection
    • Configuration
    • Upgrading from BDR-Always-ON to PGD-Always-ON
    • Upgrading from PGD-Always-ON to PGD-X
    • PGD-S or PGD-X
    • PGD-Always-ON
    • BDR-Always-ON
    • M1
    • Controlling the upgrade process
    • Upgrading a Subset of Nodes
  • tpaexec switchover
    • Example
    • Architecture options
    • Repmgr redirect pgbouncer
  • BDR/HAProxy server pool management
    • Example
  • tpaexec rehydrate
    • Prerequisites
    • Example
    • Rehydrate in phases
    • Appendix
• MISCELLANEOUS
  • TPA and Ansible Tower/Ansible Automation Platform
    • AAP initial setup
    • Setting up a cluster
    • Running custom playbooks
    • Use one project for multiple inventory
    • Update TPA on AAP
    • Build an EE for TPA
  • TPA, Ansible, and sudo
    • Ansible sudo invocations
    • Recommendations
    • SSH and sudo passwords
    • sudo options
    • Managing privilege escalation configuration
    • Logging
    • Local privileges
  • TPA - PuTTY Configuration guide
    • Key conversion
    • Configure PuTTY
  • Troubleshooting
    • Recreate python virtual environment
    • Strange AWS errors regarding credentials
    • Logging
    • Cluster test
    • TPA server test
    • Including or excluding specific tasks
  • Selective task execution
    • Using task selectors
    • Examples
    • Supported selectors for tpaexec deploy
    • Supported selectors for tpaexec test
  • Reference
    • Running TPA in a Docker container
    • Managing clusters in a disconnected or air-gapped environment
    • Distribution support
    • TPA capabilities and supported software
    • Reconciling changes made outside of TPA
    • EDB Postgres Distributed configuration
    • Barman
    • Configuring EFM
    • Configuring haproxy
    • Configuring HARP
    • Configuring Postgres Enterprise Manager (PEM)
    • PgBouncer
    • pgd-proxy
    • pglogical
    • repmgr
    • Configuring EDB Repos 2.0 repositories
    • Configuring APT repositories
    • Configuring YUM repositories
    • Creating and using a local repository
    • Installing from source
    • Git credentials
    • Environment
    • Python environment
    • Configuring /etc/hosts
    • Filesystem configuration
    • Uploading artifacts
    • ssh_key_file
    • Managing SSH host keys
    • Postgres source installation
    • Installing packages
    • Running initdb
    • Installing Postgres-related packages
    • PG Backup API
    • Setting sysctl values
    • Creating Postgres databases
    • Creating Postgres tablespaces
    • Configuring .pgpass
    • The postgres Unix user
    • Creating Postgres users
    • tpaexec archive-logs
    • tpaexec download-packages
    • TPA custom commands
    • TPA custom tests
    • Configuring the PGAI agent
    • Compliance
    • etcd
    • Locale
    • Patroni cluster management commands
    • pg_hba.conf
    • pg_ident.conf
    • pgd-cli
    • Adding Postgres extensions
    • postgresql.conf
    • tpaexec deprovision
    • tpaexec info
    • tpaexec reconfigure
  • tpaexec eval
    • Usage
    • Example Output