From: | Luca Ferrari <fluca1978(at)infinito(dot)it> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_dump is ignoring my pgpass file |
Date: | 2008-10-20 15:40:57 |
Message-ID: | 200810201740.58028.fluca1978@infinito.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)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
From | Date | Subject | |
---|---|---|---|
Next Message | Teodor Sigaev | 2008-10-20 15:42:30 | Re: index scan leads to result that is different from sec scan after upgrading to 8.3.4 |
Previous Message | Martin Gainty | 2008-10-20 14:56:10 | Re: Annoying Reply-To |