Re: Explanantion on pgbouncer please

Does any of this help this is the config file i get when I type in show
config in the pgbouncer admin console:

pgbouncer=# show config;
key | value
| changeable
---------------------------+-------------------------------------------------+------------
job_name | pgbouncer
| no
service_name | pgbouncer
| no
conffile | C:\Program Files\PostgreSQL\share\pgbouncer.ini
| yes
logfile | C:\Program Files\PostgreSQL\log\pgbouncer.log
| yes
pidfile | C:\Program Files\PostgreSQL\log\pgbouncer.pid
| no
listen_addr | *
| no
listen_port | 5432
| no
listen_backlog | 128
| no
auth_type | md5
| yes
auth_file | C:\Program Files\PostgreSQL\etc\userlist.txt
| yes
pool_mode | transaction
| yes
max_client_conn | 400
| yes
default_pool_size | 100
| yes
min_pool_size | 0
| yes
reserve_pool_size | 0
| yes
reserve_pool_timeout | 5
| yes
syslog | 0
| yes
syslog_facility | daemon
| yes
syslog_ident | pgbouncer
| yes
autodb_idle_timeout | 3600
| yes
server_reset_query | DISCARD ALL
| yes
server_check_query | select 1
| yes
server_check_delay | 30
| yes
query_timeout | 0
| yes
query_wait_timeout | 0
| yes
client_idle_timeout | 0
| yes
client_login_timeout | 60
| yes
idle_transaction_timeout | 0
| yes
server_lifetime | 1200
| yes
server_idle_timeout | 60
| yes
server_connect_timeout | 15
| yes
server_login_retry | 15
| yes
server_round_robin | 0
| yes
suspend_timeout | 10
| yes
ignore_startup_parameters | application_name,extra_float_digits
| yes
disable_pqexec | 0
| no
dns_max_ttl | 15
| yes
dns_zone_check_period | 0
| yes
max_packet_size | 2147483647
| yes
pkt_buf | 2048
| no
sbuf_loopcnt | 5
| yes
tcp_defer_accept | 0
| yes
tcp_socket_buffer | 0
| yes
tcp_keepalive | 1
| yes
tcp_keepcnt | 0
| yes
tcp_keepidle | 0
| yes
tcp_keepintvl | 0
| yes
verbose | 0
| yes
admin_users | postgres
| yes
stats_users | postgres
| yes
stats_period | 60
| yes
log_connections | 1
| yes
log_disconnections | 1
| yes
log_pooler_errors | 1
| yes
(54 rows)

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Explanantion-on-pgbouncer-please-tp5776515p5777452.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.