| 1 | key | value | default | changeable |
| 2 | ---------------------------+--------------------------------------------------------+--------------------------------------------------------+------------ |
| 3 | admin_users | postgres | | yes |
| 4 | application_name_add_host | 0 | 0 | yes |
| 5 | auth_file | /etc/pgbouncer/userlist.txt | | yes |
| 6 | auth_hba_file | | | yes |
| 7 | auth_query | SELECT usename, passwd FROM pg_shadow WHERE usename=$1 | SELECT usename, passwd FROM pg_shadow WHERE usename=$1 | yes |
| 8 | auth_type | md5 | md5 | yes |
| 9 | auth_user | | | yes |
| 10 | autodb_idle_timeout | 3600 | 3600 | yes |
| 11 | client_idle_timeout | 0 | 0 | yes |
| 12 | client_login_timeout | 60 | 60 | yes |
| 13 | client_tls_ca_file | | | yes |
| 14 | client_tls_cert_file | | | yes |
| 15 | client_tls_ciphers | fast | fast | yes |
| 16 | client_tls_dheparams | auto | auto | yes |
| 17 | client_tls_ecdhcurve | auto | auto | yes |
| 18 | client_tls_key_file | | | yes |
| 19 | client_tls_protocols | secure | secure | yes |
| 20 | client_tls_sslmode | disable | disable | yes |
| 21 | conffile | /etc/pgbouncer/pgbouncer.ini | | yes |
| 22 | default_pool_size | 20 | 20 | yes |
| 23 | disable_pqexec | 0 | 0 | no |
| 24 | dns_max_ttl | 15 | 15 | yes |
| 25 | dns_nxdomain_ttl | 15 | 15 | yes |
| 26 | dns_zone_check_period | 0 | 0 | yes |
| 27 | idle_transaction_timeout | 0 | 0 | yes |
| 28 | ignore_startup_parameters | extra_float_digits | | yes |
| 29 | job_name | pgbouncer | pgbouncer | no |
| 30 | listen_addr | 0.0.0.0 | | no |
| 31 | listen_backlog | 128 | 128 | no |
| 32 | listen_port | 6432 | 6432 | no |
| 33 | log_connections | 1 | 1 | yes |
| 34 | log_disconnections | 1 | 1 | yes |
| 35 | log_pooler_errors | 1 | 1 | yes |
| 36 | log_stats | 1 | 1 | yes |
| 37 | logfile | | | yes |
| 38 | max_client_conn | 100 | 100 | yes |
| 39 | max_db_connections | 0 | 0 | yes |
| 40 | max_packet_size | 2147483647 | 2147483647 | yes |
| 41 | max_user_connections | 0 | 0 | yes |
| 42 | min_pool_size | 0 | 0 | yes |
| 43 | pidfile | | | no |
| 44 | pkt_buf | 4096 | 4096 | no |
| 45 | pool_mode | session | session | yes |
| 46 | query_timeout | 0 | 0 | yes |
| 47 | query_wait_timeout | 120 | 120 | yes |
| 48 | reserve_pool_size | 0 | 0 | yes |
| 49 | reserve_pool_timeout | 5 | 5 | yes |
| 50 | resolv_conf | | | no |
| 51 | sbuf_loopcnt | 5 | 5 | yes |
| 52 | server_check_delay | 30 | 30 | yes |
| 53 | server_check_query | select 1 | select 1 | yes |
| 54 | server_connect_timeout | 15 | 15 | yes |
| 55 | server_fast_close | 0 | 0 | yes |
| 56 | server_idle_timeout | 600 | 600 | yes |
| 57 | server_lifetime | 3600 | 3600 | yes |
| 58 | server_login_retry | 15 | 15 | yes |
| 59 | server_reset_query | DISCARD ALL | DISCARD ALL | yes |
| 60 | server_reset_query_always | 0 | 0 | yes |
| 61 | server_round_robin | 0 | 0 | yes |
| 62 | server_tls_ca_file | | | yes |
| 63 | server_tls_cert_file | | | yes |
| 64 | server_tls_ciphers | fast | fast | yes |
| 65 | server_tls_key_file | | | yes |
| 66 | server_tls_protocols | secure | secure | yes |
| 67 | server_tls_sslmode | disable | disable | yes |
| 68 | so_reuseport | 0 | 0 | no |
| 69 | stats_period | 60 | 60 | yes |
| 70 | stats_users | | | yes |
| 71 | suspend_timeout | 10 | 10 | yes |
| 72 | syslog | 0 | 0 | yes |
| 73 | syslog_facility | daemon | daemon | yes |
| 74 | syslog_ident | pgbouncer | pgbouncer | yes |
| 75 | tcp_defer_accept | 1 | 1 | yes |
| 76 | tcp_keepalive | 1 | 1 | yes |
| 77 | tcp_keepcnt | 0 | 0 | yes |
| 78 | tcp_keepidle | 0 | 0 | yes |
| 79 | tcp_keepintvl | 0 | 0 | yes |
| 80 | tcp_socket_buffer | 0 | 0 | yes |
| 81 | tcp_user_timeout | 0 | 0 | yes |
| 82 | unix_socket_dir | | /tmp | no |
| 83 | unix_socket_group | | | no |
| 84 | unix_socket_mode | 511 | 0777 | no |
| 85 | user | postgres | | no |
| 86 | verbose | 0 | | yes |