| From: | Edoardo Panfili <edoardo(at)aspix(dot)it> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: psql connection via localhost or 127.0.0.1 |
| Date: | 2014-11-06 15:53:03 |
| Message-ID: | 545B995F.2030909@aspix.it |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2014-11-06 15:54:11 | Re: psql connection via localhost or 127.0.0.1 |
| Previous Message | Edoardo Panfili | 2014-11-06 15:48:15 | Re: psql connection via localhost or 127.0.0.1 |