Re: Installed. Now what?

On Sun, Nov 20, 2011 at 8:08 AM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> 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?