Skip to main content
Ctrl+K
Trusted Postgres Architect 23.44.0 documentation - Home
  • Introduction
  • Trusted Postgres Architect release notes
    • Trusted Postgres Architect 23.44.0 release notes
    • Trusted Postgres Architect 23.43.0 release notes
    • Trusted Postgres Architect 23.42.0 release notes
    • Trusted Postgres Architect 23.41.0 release notes
    • Trusted Postgres Architect 23.40.1 release notes
    • Trusted Postgres Architect 23.40.0 release notes
    • Trusted Postgres Architect 23.39.0 release notes
    • Trusted Postgres Architect 23.38.1 release notes
    • Trusted Postgres Architect 23.38.0 release notes
    • Trusted Postgres Architect 23.37.0 release notes
    • Trusted Postgres Architect 23.36.0 release notes
    • Trusted Postgres Architect 23.35.0 release notes
    • Trusted Postgres Architect 23.34.1 release notes
    • Trusted Postgres Architect 23.34 release notes
    • Trusted Postgres Architect 23.33 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
  • Open source TPA
  • Known issues
  • Installing TPA from source
  • CREATING A CLUSTER
    • A First Cluster Deployment
    • Cluster configuration
    • tpaexec provision
    • tpaexec deploy
    • tpaexec test
  • ARCHITECTURES
    • PGD-S
    • PGD-X
    • PGD-Always-ON
    • PGD Lightweight
    • BDR-Always-ON
    • M1
  • PLATFORMS
    • aws
    • bare(-metal servers)
    • Docker
  • CUSTOMIZATIONS
    • Cluster configuration
    • Instance configuration
    • Building from source
    • TPA hooks
  • CLUSTER MANAGEMENT
    • Upgrading your cluster
    • tpaexec switchover
    • BDR/HAProxy server pool management
    • tpaexec rehydrate
  • MISCELLANEOUS
    • TPA and Ansible Tower/Ansible Automation Platform
    • TPA, Ansible, and sudo
    • TPA - PuTTY Configuration guide
    • Troubleshooting
    • Selective task execution
    • Reference
      • Running TPA in a Docker container
      • Managing clusters in a disconnected or air-gapped environment
      • Distribution support
      • TPA capabilities and supported software
      • Reconciling changes made outside of TPA
      • EDB Postgres Distributed configuration
      • Barman
      • Configuring EFM
      • Configuring haproxy
      • Configuring HARP
      • Configuring Postgres Enterprise Manager (PEM)
      • PgBouncer
      • pgd-proxy
      • pglogical
      • repmgr
      • Configuring EDB Repos 2.0 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
      • PG Backup API
      • Setting sysctl values
      • Creating Postgres databases
      • Creating Postgres tablespaces
      • Configuring .pgpass
      • The postgres Unix user
      • Creating Postgres users
      • tpaexec archive-logs
      • tpaexec download-packages
      • TPA custom commands
      • TPA custom tests
      • Configuring the PGAI agent
      • Compliance
      • etcd
      • Locale
      • Patroni cluster management commands
      • pg_hba.conf
      • pg_ident.conf
      • pgd-cli
      • Adding Postgres extensions
      • postgresql.conf
      • tpaexec deprovision
      • tpaexec info
      • tpaexec reconfigure
    • tpaexec eval
  • .rst

  • EDB Postgres Distributed configuration
    • Introduction
    • Installation
    • Overview of cluster setup
    • Instance roles
    • Configuration settings
      • bdr_database
      • bdr_client_dsn_attributes
      • bdr_node_groups
      • bdr_child_group
      • bdr_commit_scopes
      • preferred_first_bdr_primary
    • Miscellaneous notes
      • Hooks
      • Database collations
    • 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
      • Air-gapped clusters
      • Special considerations for shared Barman servers
  • Configuring EFM
    • EFM configuration
    • efm_user_password_encryption
    • efm_conf_settings
    • efm_user_is_superuser
      • EFM witness
      • Repmgr
      • Node Promotability
    • 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
      • etcd
      • bdr
    • 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
      • bdr_node_groups
      • bdr_node_options
      • pgd_proxy_options
      • PGD proxy http(s) health probes
    • 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

previous

Reconciling changes made outside of TPA

next

EDB Postgres Distributed configuration

By EnterpriseDB Corporation

© Copyright EnterpriseDB Corporation.