Skip to main content
Ctrl+K
Trusted Postgres Architect TPA 23.34.0 documentation - Home
  • Introduction
    • Introduction
    • Trusted Postgres Architect 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
    • Installing TPA from source
  • Creating a cluster
    • A First Cluster Deployment
    • Cluster configuration
    • tpaexec provision
    • tpaexec deploy
    • tpaexec test
  • Architecture
    • PGD-Always-ON
    • BDR-Always-ON
    • M1
  • Platform
    • aws
    • bare(-metal servers)
    • Docker
  • Customization
    • 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
    • Reference
      • Installation
        • Running TPA in a Docker container
        • Managing clusters in a disconnected or air-gapped environment
        • Distribution support
        • TPA capabilities and supported software
      • Administration
        • Reconciling changes made outside of TPA
      • Services
        • EDB Postgres Distributed configuration
        • Barman
        • Configuring EFM
        • Configuring haproxy
        • Configuring HARP
        • Configuring Postgres Enterprise Manager (PEM)
        • Configuring pgbouncer
        • Configuring pgd-proxy
        • pglogical configuration
        • Configuring repmgr
      • Configuration
        • 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
        • SSL Certificates
        • Setting sysctl values
      • Postgres Configuration
        • Creating Postgres databases
        • Creating Postgres tablespaces
        • postgresql.conf
        • pg_hba.conf
        • pg_ident.conf
        • Configuring .pgpass
        • The postgres Unix user
        • Creating Postgres users
      • Commands
        • tpaexec archive-logs
        • tpaexec download-packages
        • TPA custom commands
        • TPA custom tests
        • Configuring the beacon agent
        • Locale
        • Patroni cluster management commands
        • Adding Postgres extensions
        • tpaexec deprovision
        • tpaexec info
        • tpaexec reconfigure
    • Selective task execution
  • .rst

Postgres Configuration

Postgres Configuration#

  • Creating Postgres databases
  • Creating Postgres tablespaces
  • postgresql.conf
    • postgres_conf_settings
    • shared_buffers
    • effective_cache_size
    • shared_preload_libraries
    • Postgres log
    • Making changes by hand
    • Generating postgresql.conf from scratch
  • pg_hba.conf
  • pg_ident.conf
  • Configuring .pgpass
  • The postgres Unix user
    • Shell configuration
    • SSH keys
    • TLS certificates
    • Username
  • Creating Postgres users
    • Password generation

previous

Setting sysctl values

next

Creating Postgres databases

By EnterpriseDB Corporation.

© Copyright EnterpriseDB Corporation..