Dne 20.11.2011 04:21, Phoenix Kiula napsal(a): >> 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" My guess is that you actually require a password when connecting to the database, but you haven't specified a password in the pgbouncer.ini file. You have to specify it in the MYDB line, i.e. something like [databases] MYDB = host=127.0.0.1 dbname=MYDB user=MYUSER client_encoding=utf8 port=5432 password='mypassword' The auth_file is used only for connecting to the pgbouncer, it's not forwarded to the database server - the pgbouncer opens the connection on behalf of the users, and you may actually have a completely different users on the connection pooler. Tomas -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
