Thread: pg_dump is ignoring my pgpass file

Hi all,
I'm running 8.2.9, and I've got a curious problem on a database of my cluster.
I've got my pgpass file:

backup@backup:~$ cat ~/.pgpass
192.168.1.2:5432:raydb:ray:xxxxxxx
192.168.1.2:5432:hrpmdb:hrpm:xxxxx
192.168.1.2:5432:vatcontrollerdb:vatcontroller:xxxxxx

and if I connect from the command line to any database I'm not prompted for a
password. But if I try to execute the following:

pg_dump --create --column-inserts -v -f raydb_ott_20_08.sql  -U ray -h
sedeldap  raydb

I'm prompted for a password immediatly. But if I execute the same command with
another database (and another user) I'm not prompted for a password at all.
I've checked and the ray user is also owner of the raydb.....any idea on what
I'm missing?

Thanks,
Luca

Luca Ferrari <fluca1978@infinito.it> writes:
> I've got my pgpass file:

> backup@backup:~$ cat ~/.pgpass
> 192.168.1.2:5432:raydb:ray:xxxxxxx
> 192.168.1.2:5432:hrpmdb:hrpm:xxxxx
> 192.168.1.2:5432:vatcontrollerdb:vatcontroller:xxxxxx

> ... But if I try to execute the following:

> pg_dump --create --column-inserts -v -f raydb_ott_20_08.sql  -U ray -h
> sedeldap  raydb

AFAICT the matching of .pgpass entries to a connection attempt is
strictly textual.  "sedeldap" != "192.168.1.2" therefore none of
these entries apply.  The question is not so much why ray isn't
getting let in, as why anyone else is ...

            regards, tom lane

On Tuesday 21 October 2008 Tom Lane's cat, walking on the keyboard, wrote:

> AFAICT the matching of .pgpass entries to a connection attempt is
> strictly textual.  "sedeldap" != "192.168.1.2" therefore none of
> these entries apply.

Thanks, I'm able to make entries work only with the ip address, and not a
hostname. I guess this is a lookup problem, however with ip addresses it
works.

Luca