MISCELLANEOUS

• 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
  • Running custom playbooks
  • 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
  • Managing privilege escalation configuration
    • Default sudo configuration
    • Using an alternative privilege escalation command
    • Ansible’s become method vs. privilege_escalation_command
    • Recommended approach: Using hooks
    • Manual configuration requirements
  • 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
• Selective task execution
  • Using task selectors
  • Examples
  • Supported selectors for tpaexec deploy
  • Supported selectors for tpaexec test
• Reference
  • Running TPA in a Docker container
    • Quickstart
    • Installing Docker
  • 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
    • Cross-version Shared Barman
  • Distribution support
    • Debian ARM64
    • Debian x86
    • Ubuntu x86
    • Oracle Linux x86
    • RedHat x86
    • SLES x86
  • TPA capabilities and supported software
    • Supported software
  • 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
  • EDB Postgres Distributed configuration
    • Introduction
    • Installation
    • Overview of cluster setup
    • Instance roles
    • Configuration settings
    • Miscellaneous notes
    • Older versions of PGD
  • Barman
    • Barman package version
    • WAL restore compression flag
    • Barman configuration
    • Backup scheduling
    • SSH keys
    • barman and barman_role Postgres users
    • Shared Barman server
  • Configuring EFM
    • EFM configuration
    • efm_user_password_encryption
    • efm_conf_settings
    • efm_user_is_superuser
    • Minor update for EFM using tpaexec upgrade
  • Configuring haproxy
    • Read-Only load-balancer
    • Patroni Health Checks
    • Server options
    • Example
  • Configuring HARP
    • Installing HARP
    • Variables for HARP configuration
    • Consensus layer
    • Configuring a separate user for harp proxy
    • Configuring a separate user for harp manager
    • Custom SSL password command
    • Configuring the harp service
    • Configuring harp http(s) health probes
  • Configuring Postgres Enterprise Manager (PEM)
    • Supported architectures
    • PEM component package versions
    • PEM configuration
    • Passing additional options when registering PEM agents
    • Useful extensions for the nodes with pem agent
    • Providing an external certificate for PEM server SSL authentication
    • Organising instances in PEM
    • Shared PEM server
    • Minor update for PEM using tpaexec upgrade
  • PgBouncer
    • PgBouncer package version
    • Configuring PgBouncer
    • Databases
    • Authentication
    • Example
    • Minor update for PgBouncer using tpaexec upgrade
  • pgd-proxy
    • pgd-proxy package version
    • Configuring pgd-proxy
    • Configuration
    • Updating pgd-proxy using tpaexec upgrade
  • pglogical
    • pglogical package version
    • pglogical configuration
    • Introduction
    • Publications
    • Subscriptions
    • Configuration changes
    • Interaction with PGD
    • Limitations
  • repmgr
    • repmgr package version
    • repmgr configuration
    • repmgr service configuration
    • repmgr on PGD instances
    • Minor update for repmgr using tpaexec upgrade
  • Configuring EDB Repos 2.0 repositories
  • Configuring APT repositories
  • Configuring YUM repositories
  • 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
  • Installing from source
    • Build dependencies
  • Git credentials
    • SSH key authentication
    • HTTPS username/password authentication
  • Environment
  • Python environment
    • Backwards compatibility
    • Python interpreter for installed scripts
    • Python version for installed packages
  • Configuring /etc/hosts
  • Filesystem configuration
    • default_volumes
    • Platform AWS
    • Platform bare
    • Platform Docker
    • RAID arrays
    • LUKS encryption
    • Filesystem creation and mounting
  • Uploading artifacts
  • ssh_key_file
    • Skipping authorized_keys management
  • Managing SSH host keys
    • known_hosts
  • Postgres source installation
    • Git repository
    • Additional components
    • Package installation
  • Installing packages
    • Optional packages
    • Removing packages
  • Running initdb
    • Separate configuration directory
  • Installing Postgres-related packages
  • PG Backup API
    • PG Backup API package version
    • Installation Options
    • Verify Setup
    • SSL Certificates
    • Minor update for pg backup api using tpaexec upgrade
  • Setting sysctl values
    • Hugepages
  • Creating Postgres databases
  • Creating Postgres tablespaces
  • Configuring .pgpass
  • The postgres Unix user
    • Shell configuration
    • SSH keys
    • TLS certificates
    • Username
  • Creating Postgres users
    • Password generation
  • tpaexec archive-logs
    • Prerequisites
    • Quickstart
    • Generated files
  • tpaexec download-packages
    • Usage
    • Using the result
    • Regenerate local repository metadata
  • TPA custom commands
    • Quickstart
    • Example
  • TPA custom tests
    • Quickstart
    • Example
    • Destructive tests
  • Configuring the PGAI agent
    • PGAI agent package version
    • PGAI agent configuration
    • Installing the PGAI agent
    • Running the PGAI agent
  • Compliance
    • STIG
    • CIS
  • etcd
    • Installation
    • etcd package version
    • Configuration
    • Security
    • Minor update for etcd using tpaexec upgrade
  • Locale
  • Patroni cluster management commands
    • Patroni package version
    • TLS Encryption
    • Client Authentication
    • API Access Control (Allowlist)
    • Etcd Integration
    • Status
    • Switchover
    • Minor update for patroni using tpaexec upgrade
  • pg_hba.conf
  • pg_ident.conf
  • pgd-cli
    • pgd-cli package version
    • Updating pgd-cli using tpaexec upgrade
  • Adding Postgres extensions
    • Default Postgres extensions
    • User defined extensions
    • TPA recognised extensions
  • postgresql.conf
    • postgres_port
    • postgres_conf_settings
    • shared_buffers
    • huge_page_size
    • effective_cache_size
    • max_active_replication_origins
    • shared_preload_libraries
    • Postgres logging
    • Generating postgresql.conf from scratch
  • tpaexec deprovision
  • tpaexec info
    • Usage
    • Example Output
  • tpaexec reconfigure
    • Arguments
    • Changing a cluster’s architecture
    • Changing a cluster from PGD-Proxy to Connection Manager in PGD-Always-ON
    • Changing a cluster from 2q to EDB repositories
    • Output format
    • Sample invocation
• tpaexec eval
  • Usage
    • Options
  • Example Output