.pgpass file

From: "Walker, Jed S" <Jed_Walker(at)cable(dot)comcast(dot)com>
To: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: .pgpass file
Date: 2005-03-21 20:47:43
Message-ID: 41669DC6FE3B80449A33A4DD46DB370A09E7E841@entcoexch15.broadband.att.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Fuhr 2005-03-21 21:23:59 Re: .pgpass file
Previous Message Tom Lane 2005-03-21 17:56:52 Re: timestamp group by bug???