On Sun, Nov 20, 2011 at 8:08 AM, Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote: > > You have pgbouncer listening on 127.0.0.1. In your psql connection string you > are not specifying a host, so if you are on a Unix platform it is trying to > connect to a socket which would account for the error. I found when working with > new software explicit is better than implicit. Eliminate possible sources of > error by fully qualifying everything. > Thanks for bearing. Specifying the host is not it. > psql -h 127.0.0.1 MYDB -E "MYDB_MYDB" -p 6543 psql: ERROR: no working server connection > ps aux | grep pgbou postgres 5567 0.0 0.0 17096 960 ? S 13:50 0:00 pgbouncer -d /etc/pgbouncer.ini root 24437 0.0 0.0 61192 788 pts/0 S+ 21:31 0:00 grep pgbou In the "/var/log/pgbouncer.log" I see a message about failing password. The pgbouncer password in the "auth_file", does it need to be plain text? Auth_type in my case is "trust". Do I need to md5 the password? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
