Trusted Postgres Architect

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

• Introduction
  • 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.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
    • Add repository and install TPA on Debian or Ubuntu
    • Add repository and install TPA on RHEL, Rocky, AlmaLinux or Oracle Linux
    • Install additional dependencies
    • Verify installation (run as a normal user)
  • Where to install TPA
  • Installing TPA packages
    • Add repository on Debian or Ubuntu
    • Add repository on RHEL, Rocky, AlmaLinux or Oracle Linux
    • Install on Debian or Ubuntu
    • Install on RHEL, Rocky, AlmaLinux or Oracle Linux
  • 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 community support
• 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?
• Installing TPA from source
  • Quickstart
  • Clone and setup
  • Dependencies
    • Python 3.6+
    • Virtual environment options
• Creating a cluster
  • A First Cluster Deployment
    • Installing TPA
    • Installing Docker
    • CgroupVersion
    • Creating a configuration with TPA
  • 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
• Architectures
  • PGD-Always-ON
    • Cluster configuration
  • BDR-Always-ON
    • Cluster configuration
  • M1
    • Default layout
    • Application and backup failover
    • Cluster configuration
• Platforms
  • 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
  • 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
• 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
    • Configure PuTTY
  • Troubleshooting
    • Recreate python virtual environment
    • Strange AWS errors regarding credentials
    • Logging
    • Cluster test
    • TPA server test
    • Skipping or including specific tags
• Reference
  • How TPA uses 2ndQuadrant and EDB repositories
    • Package sources used by TPA
    • Authenticating with package sources
    • How sources are selected by default
    • Specifying EDB 2.0 repositories
    • Specifying 2ndQuadrant repositories
  • Managing clusters in a disconnected or air-gapped environment
    • Preparation
    • Downloading packages
    • Copying packages to the target environment
    • Deploying in a disconnected environment
    • Updating in a disconnected environment
  • Configuring APT repositories
  • Uploading artifacts
  • Barman
    • Barman configuration
    • Backup scheduling
    • SSH keys
  • EDB Postgres Distributed configuration
    • Introduction
    • Installation
    • Overview of cluster setup
    • Instance roles
    • Configuration settings
    • Miscellaneous notes
    • Older versions of PGD
  • Distribution support
    • Debian x86
    • Ubuntu x86
    • RedHat x86
    • SLES
    • Platform-specific considerations
  • Configuring EDB Repos 2.0 repositories
  • Configuring EFM
    • EFM configuration
    • efm_conf_settings
  • Git credentials
    • SSH key authentication
    • HTTPS username/password authentication
  • Configuring haproxy
    • Read-Only load-balancer
    • Server options
    • Example
  • Configuring HARP
    • Installing HARP
    • Configuring HARP
    • Consensus layer
    • Configuring a separate user for harp proxy
    • Custom SSL password command
    • Configuring the harp service
    • Configuring harp http(s) health probes
  • Configuring /etc/hosts
  • Running initdb
    • Separate configuration directory
  • Installing from source
    • Build dependencies
  • Running TPA in a Docker container
    • Quickstart
    • Installing Docker
  • Creating and using a local repository
    • Creating a local repository with TPA
    • Creating a local repository manually
    • Local repo layout
    • Populating the repository and generating metadata
    • How TPA uses the local repository
  • Locale
  • Managing SSH host keys
    • known_hosts
  • Installing packages
    • Optional packages
    • Removing packages
  • Patroni cluster management commands
    • Patroni configuration file settings
    • Status
    • Switchover
  • Configuring Postgres Enterprise Manager (PEM)
    • Supported architectures
    • PEM configuration
    • Shared PEM server
    • Connecting to the PEM UI
  • pg_hba.conf
  • pg_ident.conf
  • SSL Certificates
  • Configuring pgbouncer
    • Databases
    • Authentication
    • Example
  • Configuring pgd-proxy
    • Configuration
  • pglogical configuration
    • Introduction
    • Publications
    • Subscriptions
    • Configuration changes
    • Interaction with PGD
    • Limitations
  • Configuring .pgpass
  • Creating Postgres databases
  • Installing Postgres-related packages
  • Postgres source installation
    • Git repository
    • Additional components
    • Package installation
  • Creating Postgres tablespaces
  • The postgres Unix user
    • Shell configuration
    • SSH keys
    • TLS certificates
    • Username
  • Creating Postgres users
    • Password generation
  • postgresql.conf
    • postgres_conf_settings
    • shared_buffers
    • effective_cache_size
    • shared_preload_libraries
    • Making changes by hand
    • Generating postgresql.conf from scratch
  • leaPython environment
    • Backwards compatibility
  • Reconciling changes made outside of TPA
    • Why might I need to make manual configuration changes?
    • What can happen if changes are not reconciled?
    • How to reconcile configuration changes
  • Configuring repmgr
    • repmgr configuration
    • repmgr on PGD instances
  • ssh_key_file
  • Setting sysctl values
  • Environment
  • Configuring 2ndQuadrant repositories
  • tpaexec archive-logs
    • Prerequisites
    • Quickstart
    • Generated files
  • TPA custom commands
    • Quickstart
    • Example
  • tpaexec download-packages
    • Usage
    • Using the result
    • Cleaning up failed downloader container
  • tpaexec info
    • Usage
    • Example Output
  • tpaexec reconfigure
    • Arguments
    • Sample invocation
  • TPA capabilities and supported software
    • Supported software
  • TPA custom tests
    • Quickstart
    • Example
    • Destructive tests
  • Filesystem configuration
    • default_volumes
    • Platform AWS
    • Platform bare
    • Platform Docker
    • RAID arrays
    • LUKS encryption
    • Filesystem creation and mounting
  • Configuring YUM repositories