Skip to content

Instantly share code, notes, and snippets.

@grahamb
Created August 19, 2020 17:15
Show Gist options
  • Save grahamb/1dcca40865602b36f7ab28408a5c3e05 to your computer and use it in GitHub Desktop.
Save grahamb/1dcca40865602b36f7ab28408a5c3e05 to your computer and use it in GitHub Desktop.
[databases]
; canvas_production via haproxy
canvas_production_haproxy = .........
[pgbouncer]
logfile = /var/log/pgbouncer/pgbouncer.log
pidfile = /var/run/pgbouncer/pgbouncer.pid
listen_addr = *
listen_port = 5432
auth_type = hba
auth_file = /etc/pgbouncer/users.txt
auth_hba_file = /etc/pgbouncer/pg_hba.conf
pool_mode = transaction
max_client_conn = 1000
admin_users = pgbouncer_admin
stats_users = pgbouncer_stats
user = pgbouncer
application_name_add_host = 1
default_pool_size=50
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment