pgadmin connecting to postgresql via pgbouncer

Question

I have a postgresql server running on a remote debian box. postgresql is running on unix socket dir /var/run/postgresql. I also have pgbouncer running on port 6432. I also have 6432 open for tcp connections as below ACCEPT tcp -- anywhere anywhere tcp dpt:6432

In spite of this, when i try connecting from pgadmin, i get the following message - could not connect to server: Connection refused (0x0000274D/10061). Is the server running on host "x.x.x.x" and accepting TCP/IP connections on port 6432?

Can you pls help..

I opened up port 5432 using iptables and now i can connect through that port. But dont know why i cannot connect via 6432 through pgbouncer.. — mongle, Jun 18 '13 at 19:06
did you [configure pgbouncer](http://pgbouncer.projects.pgfoundry.org/doc/config.html)? What's in `listen_addr` ? — Daniel Vérité, Jun 18 '13 at 23:08
I can also connect via pgbouncer using the command line like so - psql -p 6432 -U test -d test — mongle, Jun 19 '13 at 10:16
`netstat -tln|grep 6432` would show how it listens. I'd expect it to listen only at `127.0.0.1` — Daniel Vérité, Jun 19 '13 at 12:22

score 4 · Answer 1 · answered Jun 10 '14 at 14:22

Connections to pgbouncer through pgAdmin do not appear to be supported. I was able to get past the error above by changing listen_addr = *. (After changing the listen_addr, RELOAD is not sufficient, you must SHUTDOWN and then restart pgbouncer.) However, I then get a series of errors that basically indicate that system database objects are not exposed when connecting to pgbouncer. pgAdmin cannot function without data from these objects.

pgadmin connecting to postgresql via pgbouncer

1 Answers1