Configuration

pgbalancer is configured using a YAML file. Example:

listen: 0.0.0.0:6432
pools:
  - database: appdb
    user: appuser
    pool_mode: session
    max_clients: 100
    max_backends: 10
backends:
  - host: db1.internal
    port: 5432
    role: primary
  - host: db2.internal
    port: 5432
    role: replica

See the Metrics and Internals pages for more advanced topics.