Trusted Postgres Architect

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

• 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.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
  • Installing TPA from source
    • Quickstart
    • 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
    • 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
• Architecture
  • PGD-Always-ON
    • Cluster configuration
  • BDR-Always-ON
    • Cluster configuration
  • M1
    • Application and backup failover
    • 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
• Customization
  • 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
    • Introduction
    • Configuration
    • Upgrading from BDR-Always-ON to PGD-Always-ON
    • PGD-Always-ON
    • BDR-Always-ON
    • M1
    • Package version selection
  • tpaexec switchover
    • Example
    • Architecture options
  • BDR/HAProxy server pool management
    • Example
  • tpaexec rehydrate
    • Prerequisites
    • Example
    • Rehydrate in phases
    • Appendix
• 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