> 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