From: | Michael Wood <esiotrot(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Marco Craveiro <marco(dot)craveiro(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Understanding the behaviour of hostname in psql |
Date: | 2010-12-09 09:18:06 |
Message-ID: | AANLkTinXg9n8yvk77CvGq=D4hm7oA=y6fteXqG3d0i4j@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi
On 4 December 2010 23:52, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Marco Craveiro <marco(dot)craveiro(at)gmail(dot)com> writes:
>> i'm looking for some help in understanding the behaviour of hostname
>> in postgres 8.4. apologies if this has been asked before; i googled
>> but to no avail.
>> basically: do i need to supply both the 127.0.1.1 ip address in
>> pg_hba.conf as well as the actual ip address (say 192.168.0.5) in
>> order to be able
>> to always have trusted local connections? and if yes, whats the best
>> way of dealing with DHCP?
>
> Well, a connection to "localhost" will generally go to 127.0.0.1
> (*not* 127.0.1.1 --- that's just a typo from some hand hacking
> of your hosts file, I bet). [...]
Actually, no. Some Linux distributions add a line like this to the
hosts file on install:
127.0.1.1 yourhost
I'm not entirely sure what the reason is, but it might involve
allowing for machines with no ethernet etc. interfaces.
--
Michael Wood <esiotrot(at)gmail(dot)com>
From | Date | Subject | |
---|---|---|---|
Next Message | Vaduvoiu Tiberiu | 2010-12-10 10:20:43 | Infinite/Huge loop in query |
Previous Message | Eugene Dorofeyev | 2010-12-08 15:45:25 | Re: Usage of RETURN QUERY |