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