Trusted Postgres Architect

© Copyright EnterpriseDB UK Limited 2015-2023 - 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
• Getting started
• Trusted Postgres Architect 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
• TPA installation
  • Distribution support
  • Quickstart
  • What time is it?
  • Packages
  • Python environment
  • Installing TPA without internet or network access (air-gapped)
    • Downloading TPA packages
    • Installing without access to a Python package index
  • Verification
  • Upgrading
  • Ansible community support
• Creating a cluster
  • Cluster configuration
    • Quickstart
    • Configuration options
    • Software selection
    • Overrides
    • Ansible Tower
    • git repository
    • 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
    • Default layout
    • Cluster configuration
• Platform
  • aws
    • API access setup
    • Introduction
    • Configuration
  • bare(-metal servers)
    • SSH access
    • Distribution support
    • IP addresses
  • 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
  • TPA rolling updates
    • 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
• Miscellaneous
  • TPA and Ansible Tower/Ansible Automation Controller
    • Preparing Tower for working with TPA
    • Setting up a cluster
  • TPA, Ansible, and sudo
    • Ansible sudo invocations
    • Recommendations
    • SSH and sudo passwords
    • sudo options
    • Logging
    • Local privileges
  • TPA - PuTTY Configuration guide
    • Key conversion
    • ConfigurePuTTY
  • Troubleshooting
    • Recreate python virtual environment
    • Strange AWS errors regarding credentials
    • Logging
    • Cluster test
    • TPA server test
    • Skipping or including specific tags
  • Reference
    • Installation
    • Services
    • Configuration
    • Postgres configuration
    • Commands