Re: [INTERFACES] pg_hba.conf - Mailing list pgsql-interfaces

Antonello De Santis <ua01020@flashnet.it> writes:
> My pg_hba.conf file looks like this:
> local        all                    trust
> host         all         192.168.1.0     255.255.255.0    trust

That's OK as far as it goes, and I imagine that connections from your
other machine will work.  But for TCP connections from the same machine
the postmaster is on, you *also* need

host         all         127.0.0.1     255.255.255.255   trust

because local TCP connections usually go via the standard "loopback
address" 127.0.0.1, not via any external IP address your machine may
have.

            regards, tom lane