Trusted Postgres Architect

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

• Introduction
  • Introduction
    • What can TPA do?
    • How do I use it?
    • It’s just Postgres
    • Versioning in TPA
    • Getting started
  • Trusted Postgres Architect release notes
    • Trusted Postgres Architect 23.43.0 release notes
    • Trusted Postgres Architect 23.42.0 release notes
    • Trusted Postgres Architect 23.41.0 release notes
    • Trusted Postgres Architect 23.40.1 release notes
    • Trusted Postgres Architect 23.40.0 release notes
    • Trusted Postgres Architect 23.39.0 release notes
    • Trusted Postgres Architect 23.38.1 release notes
    • Trusted Postgres Architect 23.38.0 release notes
    • Trusted Postgres Architect 23.37.0 release notes
    • Trusted Postgres Architect 23.36.0 release notes
    • Trusted Postgres Architect 23.35.0 release notes
    • 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 installation
    • Quickstart
    • Where to install TPA
    • Installing TPA packages
    • Setting up the TPA Python environment
    • Installing TPA without internet or network access (air-gapped)
    • Verifying your TPA installation
    • Upgrading TPA
    • Ansible versions
  • Open source TPA
    • What is Trusted Postgres Architect (TPA)?
    • Next Steps
    • TPA Open Source FAQs
  • Known issues
    • The Barman user cannot connect to the database after running deploy (TPA-1218)
    • EFM clusters with more than one location are missing inter-location HBA rules (TPA-1247)
    • Deploy fails on Debian-like instances when a non-current pem_server_package_version is specified (TPA-1178)
    • PGD clusters deployed with TPA 23.34 or earlier have primary_slot_name set preventing bdr_init_physical from working (TPA-1229)
  • Installing TPA from source
    • Prerequisites
    • Clone and setup
    • Dependencies
• 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
    • Security standards compliance
    • Examples
  • tpaexec deploy
    • Prerequisites
    • Quickstart
    • Selective deployment
    • deploy.yml
  • tpaexec provision
    • Prerequisites
    • Quickstart
    • Options
    • Accessing the instances
    • Generated files
  • tpaexec test
    • Quickstart
• Architectures
  • PGD-Always-ON
    • Cluster configuration
  • PGD Lightweight
    • Cluster configuration
  • BDR-Always-ON
    • Cluster configuration
  • M1
    • Failover management
    • Cluster configuration
  • PGD-S
    • Cluster configuration
  • PGD-X
    • 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
    • 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
    • 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
  • Reference
    • Installation
    • Administration
    • Services
    • Configuration
    • Postgres configuration
    • Commands
  • Selective task execution
    • Using task selectors
    • Examples
    • Supported selectors for tpaexec deploy
    • Supported selectors for tpaexec test