Skip to main content
Ctrl+K
Logo image
  • Introduction
  • Trusted Postgres Architect 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
  • Architectures
    • PGD-Always-ON
    • 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 Controller
    • 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
    • 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
      • How TPA uses 2ndQuadrant and EDB repositories
      • Configuring EDB Repos 2.0 repositories
      • Configuring 2ndQuadrant 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
      • Shared instances
      • Locale
      • Patroni cluster management commands
      • tpaexec info
      • tpaexec reconfigure
  • .rst

Postgres configuration

Postgres configuration#

  • Creating Postgres databases
  • Creating Postgres tablespaces
  • postgresql.conf
    • postgres_conf_settings
    • shared_buffers
    • effective_cache_size
    • shared_preload_libraries
    • 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 UK Limited

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