On Sun, Nov 20, 2011 at 10:51 AM, Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote: > > I don't see a user specified. You sure you are connecting as correct user? > Remember absent a -U the user will be either your system user name or what is > specified in a ENV variable. Adrian, all this is not helping. To be sure, I tried this. Hope this command is MUCH simpler and puts this to rest: > psql --host=127.0.0.1 --dbname=MYDB --username="MYDB_MYDB" --port=6543 psql: ERROR: no working server connection > tail -4 /var/log/pgbouncer.log 2011-11-19 22:16:49.139 26439 WARNING server login failed: FATAL password authentication failed for user "MYDB_MYDB" 2011-11-19 22:16:49.139 26439 LOG S-0x15b61fe0: MYDB/MYDB_MYDB@127.0.0.1:5432 closing because: login failed (age=0) 2011-11-19 22:17:13.490 26439 LOG Stats: 0 req/s, in 0 b/s, out 0 b/s,query 0 us Please note that the word "MYDB" is a replacement of my private actual word. As you can see, the password is failing. I have read the segment of the manual you copy pasted, of course. I have auth_type = any auth_file = /var/lib/pgsql/pgbouncer.txt I have tried "trust" and "md5" too. Same results as previously posted. Just for convenience, here's how the file looks: > cat /var/lib/pgsql/pgbouncer.txt "MYDB_MYDB" "mypassword here" Anything else? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
