Reference

• Installation
  • 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
  • Distribution support
    • Debian ARM64
    • Debian x86
    • Ubuntu x86
    • Oracle Linux x86
    • RedHat x86
    • SLES x86
    • Platform-specific considerations
  • Running TPA in a Docker container
    • Quickstart
    • Installing Docker
  • TPA capabilities and supported software
    • Supported software
• Administration
  • 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
• Services
  • Barman
    • Barman package version
    • Barman configuration
    • Backup scheduling
    • SSH keys
    • barman and barman_role Postgres users
    • Shared Barman server
  • EDB Postgres Distributed configuration
    • Introduction
    • Installation
    • Overview of cluster setup
    • Instance roles
    • Configuration settings
    • Miscellaneous notes
    • Older versions of PGD
  • Configuring EFM
    • EFM configuration
    • efm_user_password_encryption
    • efm_conf_settings
    • 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 on PGD instances
    • Minor update for repmgr using tpaexec upgrade
• Configuration
  • 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
  • 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
  • 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
• Postgres configuration
  • Creating Postgres databases
  • Creating Postgres tablespaces
  • Configuring .pgpass
  • The postgres Unix user
    • Shell configuration
    • SSH keys
    • TLS certificates
    • Username
  • Creating Postgres users
    • Password generation
• Commands
  • 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 recognized extensions
  • postgresql.conf
    • postgres_port
    • postgres_conf_settings
    • shared_buffers
    • effective_cache_size
    • 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