Re: psql connection via localhost or 127.0.0.1 - Mailing list pgsql-general

From Edoardo Panfili
Subject Re: psql connection via localhost or 127.0.0.1
Date
Msg-id 545B995F.2030909@aspix.it
Whole thread Raw
In response to Re: psql connection via localhost or 127.0.0.1  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Il 06/11/14 16:18, Adrian Klaver ha scritto:
> On 11/06/2014 07:00 AM, John R Pierce wrote:
>> On 11/6/2014 6:34 AM, Edoardo Panfili wrote:
>>>
>>> Why localhost is not an alias for 127.0.0.1 ?
>>
>> grep localhost /etc/hosts
>>
>> I've seen some weird stuff on some systems.
>
> I have localhost/127.0.0.1  set up correctly on my machine and I see
> the same behavior as the OP. I'm pretty sure it is an interaction
> between the libpq host/hostaddr code and a .pgpass file. I suspect the
> OP has a .pgpass entry for localhost but not 127.0.0.1.

------ .pgpass --------------
localhost:5432:*:postgres:postgres_pwd
----------------------------

removing this file localhost behaves like 127.0.0.1

maybe that the debian installer creates this file during installation
(is useful but I didn't know this file).

this explains the situation, thank you again to all
Edoardo




pgsql-general by date:

Previous
From: Edoardo Panfili
Date:
Subject: Re: psql connection via localhost or 127.0.0.1
Next
From: Adrian Klaver
Date:
Subject: Re: psql connection via localhost or 127.0.0.1