databases 配置
[databases] main = host=localhost port=5432 dbname=mydb user=myuser password=mypass connect_query='SELECT 1'
pgbouncer
[pgbouncer] logfile = /var/log/pgbouncer.log pidfile = /var/run/pgbouncer/pgbouncer.pid listen_addr = 127.0.0.1 listen_port = 6432 auth_type = trust auth_file = /etc/pgbouncer/userlist.txt admin_users = postgres stats_users = stats, postgres pool_mode = session server_reset_query = DISCARD ALL max_client_conn = 100 default_pool_size = 20
例 11.1. /etc/pgbouncer/pgbouncer.ini
# grep -v '^;' /etc/pgbouncer/pgbouncer.ini | grep -v '^$'
[databases] main = host=localhost port=5432 dbname=test user=test password=test connect_query='SELECT 1' [pgbouncer] logfile = /var/log/pgbouncer.log pidfile = /var/run/pgbouncer/pgbouncer.pid listen_addr = 127.0.0.1 listen_port = 1521 auth_type = trust auth_file = /etc/pgbouncer/userlist.txt admin_users = postgres stats_users = stats, postgres pool_mode = session server_reset_query = DISCARD ALL max_client_conn = 100 default_pool_size = 20