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

Re: Understanding the behaviour of hostname in psql

From: Marco Craveiro <marco(dot)craveiro(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Understanding the behaviour of hostname in psql
Date: 2010-12-05 17:34:47
Message-ID: AANLkTinVGTnCJ8AkjbHues3KeSwg-qTqSkiHaFDpfAuq@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
> It looks to me like "localhost" is getting resolved as the IPv6
> loopback address (::1), which for some reason you've configured
> differently than the IPv4 loopback address in your pg_hba.conf:
>
>>     host    all         all         127.0.0.1/32          trust
>>     host    all         all         ::1/128               md5

ah yes, good point - i was just ignoring IPv6 altogether. school boy error!

> I'm not sure why your "ping" example doesn't reflect that --- maybe you
> have an IPv4-only version of ping?  But if you're unconvinced you could
> turn on log_connections and see where the server sees the connection as
> coming from.

well, setting IPv6 to trust too fixed my problem. i'll keep
log_connections in mind for future problems though.

thanks a lot for your time.

cheers
-- 
The key to Understanding complicated things is to know what not to
look at, and what not to compute, and what not to think. -- Abelson &
Sussman, SICP

blog: http://mcraveiro.blogspot.com

In response to

pgsql-novice by date

Next:From: TimDate: 2010-12-05 17:52:14
Subject: C Function returning a tuple with a float4 array as column
Previous:From: TimDate: 2010-12-05 17:20:55
Subject: C Function returning a tuple with a float4 array as column

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