Re: [GENERAL] pg_dump is ignoring my pgpass file

2008-10-22 Thread Luca Ferrari
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

Re: [GENERAL] pg_dump is ignoring my pgpass file

2008-10-20 Thread Tom Lane
Luca Ferrari <[EMAIL PROTECTED]> writes: > I've got my pgpass file: > [EMAIL PROTECTED]:~$ cat ~/.pgpass > 192.168.1.2:5432:raydb:ray:xxx > 192.168.1.2:5432:hrpmdb:hrpm:x > 192.168.1.2:5432:vatcontrollerdb:vatcontroller:xx > ... But if I try to execute the following: > pg_dump --crea

[GENERAL] pg_dump is ignoring my pgpass file

2008-10-20 Thread Luca Ferrari
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: [EMAIL PROTECTED]:~$ cat ~/.pgpass 192.168.1.2:5432:raydb:ray:xxx 192.168.1.2:5432:hrpmdb:hrpm:x 192.168.1.2:5432:vatcontrollerdb:vatcontroller:xx and if I connect from the