• TPA and Ansible Tower/Ansible Automation Platform
  • AAP initial setup
    • Add TPA Execution Environment image (admin)
    • Create the EDB_SUBSCRIPTION_TOKEN credential type (admin)
  • Setting up a cluster
    • On the TPA workstation
    • Configure
    • config.yml modification
    • On the AAP UI
    • Project
    • Inventory
    • Credentials
    • Template creation
  • Use one project for multiple inventory
    • Set Allow branch override option
    • Define multiple inventories
    • Define credentials per inventory
  • Update TPA on AAP
    • Update TPA workstation package
    • Use EE image with same version tag
    • Run tpaexec relink on your cluster directory
    • Sync project and inventories
  • Build an EE for TPA
    • Prerequisites
    • Environment file
    • EE build command
• TPA, Ansible, and sudo
  • Ansible sudo invocations
  • Recommendations
  • SSH and sudo passwords
  • sudo options
  • 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
    • Running TPA in a Docker container
    • Managing clusters in a disconnected or air-gapped environment
    • Distribution support
    • TPA capabilities and supported software
  • Services
    • EDB Postgres Distributed configuration
    • Barman
    • Configuring EFM
    • Configuring haproxy
    • Configuring HARP
    • Configuring Postgres Enterprise Manager (PEM)
    • Configuring pgbouncer
    • Configuring pgd-proxy
    • pglogical configuration
    • Configuring repmgr
  • Configuration
    • How TPA uses 2ndQuadrant and EDB repositories
    • Configuring EDB Repos 2.0 repositories
    • Configuring 2ndQuadrant 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
    • SSL Certificates
    • Setting sysctl values
  • Postgres Configuration
    • Creating Postgres databases
    • Creating Postgres tablespaces
    • postgresql.conf
    • pg_hba.conf
    • pg_ident.conf
    • Configuring .pgpass
    • The postgres Unix user
    • Creating Postgres users
  • Commands
    • tpaexec archive-logs
    • tpaexec download-packages
    • TPA custom commands
    • TPA custom tests
    • Locale
    • Patroni cluster management commands
    • Adding Postgres extensions
    • tpaexec deprovision
    • tpaexec info
    • tpaexec reconfigure
  • Administration
    • Reconciling changes made outside of TPA
• Selective task execution
  • Using task selectors
  • Examples
  • Supported selectors for tpaexec deploy
  • Supported selectors for tpaexec test