.pgpass file - Mailing list pgsql-novice

From Walker, Jed S
Subject .pgpass file
Date
Msg-id 41669DC6FE3B80449A33A4DD46DB370A09E7E841@entcoexch15.broadband.att.com
Whole thread Raw
Responses Re: .pgpass file
List pgsql-novice
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. If I use

*:*:JED:jed:jed

then I do not and it logs in correctly (which is what I want).

I would prefer not to have the hostname as * and only allow use of the
password file if it's a local connection, but how do I get it to recognize
the hostname?

(FYI - on my linux box  "uname -n" and "echo $HOSTNAME" are both robux)

Thanks,


        Jed S. Walker



pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: timestamp group by bug???
Next
From: Michael Fuhr
Date:
Subject: Re: .pgpass file