Skip to content

Instantly share code, notes, and snippets.

@danielnc

danielnc/pgbouncer.ini

Created August 4, 2016 11:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save danielnc/3ce76c8a8957e8a52f65c9224839e670 to your computer and use it in GitHub Desktop.
Save danielnc/3ce76c8a8957e8a52f65c9224839e670 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
pgbouncer.ini
[databases]
dev_master = host=127.0.0.1 port=5432 dbname=caremessage_dev_master pool_size=1 timezone=UTC client_encoding=UNICODE
[pgbouncer]
listen_addr = 127.0.0.1
listen_port = 6432
auth_type = trust
auth_file = /etc/pgbouncer/userlist.txt
logfile = /var/log/pgbouncer/pgbouncer.log
pidfile = /var/run/pgbouncer/pgbouncer.pid
pool_mode = transaction
max_client_conn = 50000
default_pool_size = 75
min_pool_size = 5
reserve_pool_timeout = 1
reserve_pool_size = 0
admin_users = root
application_name_add_host = 0
server_idle_timeout = 600
server_lifetime = 3600
log_connections = 1
log_disconnections = 1
log_pooler_errors = 1
verbose=2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment