Re: Installed. Now what?

On Sun, Nov 20, 2011 at 1:57 PM, Amitabh Kant <amitabhkant(at)gmail(dot)com> wrote:
>
> On Sun, Nov 20, 2011 at 12:12 PM, Tomas Vondra <tv(at)fuzzy(dot)cz> 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.