I have pgbouncer running locally with config:
[databases]
* = host=myremoteIP port=5432 user=postgres
listen_addr = *
listen_port = 6432
When I connect using pgsql using:
psql -h 127.0.0.1 -p 6432 -U postgres -W
I receive an error:
psql: ERROR: pgbouncer cannot connect to server
/var/log/pgbouncer/pgbouncer.log contains the following:
WARNING Cannot listen on unix:/var/run/postgresql/.s.PGSQL.6432: bind(): Permission denied
Disabling the firewall on the local and remote machines still results in the same error.
What configuration am I missing?
/var/run/postgresql/
.psql
client in your machine. Then, checkpidfile
param in/etc/pgbouncer/pgbouncer.ini