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@xxxxxxxxxxxxxxxxxxxxxx>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
