Michael Fork <mfork@toledolink.com> writes:
> Actually, to have it wide open, i think it should be this
> #host all 0.0.0.0 0.0.0.0 trust
That *would* be wide open: allow anyone to connect from anywhere.
I think what Dave actually wants is
local all trust
host all 127.0.0.1 255.255.255.255 trust
to allow IP connections from localhost only. Depending on how his
local networking software works, he might also want a host line
mentioning his real IP address.
This is the second report I've seen this week of someone thinking that
host = 0.0.0.0 is the right thing to put in pg_hba.conf. Do we have
some erroneous documentation somewhere that suggests that?
regards, tom lane