| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tim | 2010-12-05 17:52:14 | C Function returning a tuple with a float4 array as column |
| Previous Message | Tim | 2010-12-05 17:20:55 | C Function returning a tuple with a float4 array as column |