Pgbouncer cannot connect to server
I have pgbouncer installation and setup on windows. The pgbouncer service is running, but when I connect it to postgres 9.6 it throws an error "
pgbouncer cannot connect to server
" create a server with pgbouncer port
pgbouncer configurations are: postgres = host=127.0.0.1 port=4851 staging29-6-1016 = host=localhost port=4851 dbname=staging29-6-1016 listen_addr = * listen_port = 6432 auth_type = md5 auth_file = C:\Program Files (x86)\PgBouncer\etc\userlist.txt
userlist.txt also contains md5 encrypted password
Postgresql.conf file contains:
listen_addresses = '*' port = 4851
kindly help me how to remove this error.
2017-08-03 15:23:33.429 2360 LOG C-00EA8FE0: postgres/postgres@[::1]:54985 login attempt: db=postgres user=postgres tls=no
2017-08-03 15:23:33.429 2360 LOG C-00EA8FE0: postgres/postgres@[::1]:54985 closing because: pgbouncer cannot connect to server (age=0)
2017-08-03 15:23:33.430 2360 WARNING C-00EA8FE0: postgres/postgres@[::1]:54985 Pooler Error: pgbouncer cannot connect to server
+3
source to share
No one has answered this question yet
Check out similar questions: