Re: security question

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