From: | "Walker, Jed S" <Jed_Walker(at)cable(dot)comcast(dot)com> |
---|---|
To: | 'Michael Fuhr' <mike(at)fuhr(dot)org> |
Cc: | "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: .pgpass file |
Date: | 2005-03-21 21:58:27 |
Message-ID: | 41669DC6FE3B80449A33A4DD46DB370A09E7E844@entcoexch15.broadband.att.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Then it works!! Thanks.
Now, how do I verify from within psql what the username I'm logged in as is?
-----Original Message-----
From: Michael Fuhr [mailto:mike(at)fuhr(dot)org]
Sent: Monday, March 21, 2005 2:24 PM
To: Walker, Jed S
Cc: 'pgsql-novice(at)postgresql(dot)org'
Subject: Re: [NOVICE] .pgpass file
On Mon, Mar 21, 2005 at 01:47:43PM -0700, Walker, Jed S wrote:
> I have configured a .pgpass file, but am having trouble with the hostname
> portion.
>
> If I have
>
> robux:*:JED:jed:jed
> or
> local:*:JED:jed:jed
>
> and I do "psql -U jed" I get the password prompt.
What happens if you put "localhost" instead of "local" in .pgpass?
Or if you run "psql -h robux -U jed"?
See also the comments about environment variables in the psql
documentation and the "Environment Variables" section of the libpq
documentation. You can set up your environment so all you have to
type is "psql".
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
From | Date | Subject | |
---|---|---|---|
Next Message | John DeSoi | 2005-03-22 00:31:07 | Re: .pgpass file |
Previous Message | Michael Fuhr | 2005-03-21 21:23:59 | Re: .pgpass file |