Re: [INTERFACES] pg_hba.conf

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ua01020(at)flashnet(dot)it
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] pg_hba.conf
Date: 1999-03-29 00:08:08
Message-ID: 24430.922666088@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Antonello De Santis <ua01020(at)flashnet(dot)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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Constantin Teodorescu 1999-03-29 06:25:13 Re: I am facing a difficult problem..
Previous Message Bob VonMoss 1999-03-28 22:55:48 Re: [INTERFACES] pg_hba.conf