Skip site navigation (1) Skip section navigation (2)

Re: Understanding the behaviour of hostname in psql

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: (view raw or whole thread)
Lists: pgsql-novice

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 ip address in
>> pg_hba.conf as well as the actual ip address (say 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
> (*not* --- 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: 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>

In response to


pgsql-novice by date

Next:From: Vaduvoiu TiberiuDate: 2010-12-10 10:20:43
Subject: Infinite/Huge loop in query
Previous:From: Eugene DorofeyevDate: 2010-12-08 15:45:25
Subject: Re: Usage of RETURN QUERY

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group