I have configured PgBouncer with PostgreSQL 9.6 on windows 7 machine. Here are the pgbouncer configuration settings;


test = host= port=5432 dbname=master_db user=postgres password=test123


logfile = C:\Program Files (x86)\PgBouncer\log\pgbouncer.log
pidfile = C:\Program Files (x86)\PgBouncer\log\pgbouncer.pid
listen_addr = *
listen_port = 6432
auth_type = md5
auth_file = C:\Program Files (x86)\PgBouncer\etc\userlist.txt
admin_users = postgres
stats_users = postgres
max_client_conn = 100
default_pool_size = 20

user list file

"test_user" "bacha"

When i try to connect to a database using pgbouncer, through this command;

psql -h -p 6432 -U test_user master_db

i get this error

psql: ERROR:  client_login_timeout (server down)
psql: ERROR:  pgbouncer cannot connect to server

How can i solve this Problem ?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.