Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: security question
- From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
- To: Dave Lazar <hunkybill(at)gmail(dot)com>
- Cc: pgsql-admin(at)postgresql(dot)org
- Subject: Re: security question
- Date: Wed, 4 Apr 2007 14:44:36 -0700 (PDT)
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(at)frostconsultingllc(dot)com> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954
- References:
- security question
- From: Dave Lazar
- Re: security question
- From: Jeff Frost
- security question
- Prev by Date: How to compile with different MAXALIGN?
- Next by Date: Re: How to compile with different MAXALIGN?
- Previous by thread: Re: security question
- Next by thread: How to compile with different MAXALIGN?
- Indexes: