2

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

[databases]

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

[pgbouncer]

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 127.0.0.1 -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.