On Sun, Nov 20, 2011 at 1:57 PM, Amitabh Kant <amitabhkant@xxxxxxxxx> wrote: > > On Sun, Nov 20, 2011 at 12:12 PM, Tomas Vondra <tv@xxxxxxxx> wrote: >> >> Dne 20.11.2011 04:21, Phoenix Kiula napsal(a): >> <snip> >> 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. OK. So I specified the password enclosed in double quotes. [databases] MYDB = host=127.0.0.1 dbname=MYDB user=MYUSER client_encoding=utf8 port=5432 password="mypassword" Then restarted pgbouncer: service pgbouncer restart And this shows up as this: > lsof -i | grep pgbouncer pgbouncer 8558 postgres 7u IPv4 26187618 TCP localhost:lds-distrib (LISTEN) Is this normal? Shouldn't the port number be somewhere? What's "lds-distrib"? Thanks for all the help. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
