On Wed, 4 Apr 2007, Dave Lazar wrote:
>> Most likely psql is picking up the password from ~/.pgpass when run as
>> your
>> user. Pgadmin3 stores passwords in .pgpass, so it's likely been put in
>> there
>> by pgadmin. As a test - move .pgpass to .pgpass.old and try to connect
>> via
>> psql -U postgres -d myDataBase again.
>>
>>
> BINGO... thanks... first time I see .pgpass in action.. works like a
> charm... used to not work for me.. this is good :)
If it didn't work in the past, it was likely because of permissions problems.
Pgadmin probably helpfully set the permissions properly for you when it
created the file.
--
Jeff Frost, Owner <jeff@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954