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

From Edoardo Panfili
Subject psql connection via localhost or 127.0.0.1
Date
Msg-id 545B8707.6050301@aspix.it
Whole thread Raw
Responses Re: psql connection via localhost or 127.0.0.1  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: psql connection via localhost or 127.0.0.1  (John R Pierce <pierce@hogranch.com>)
Re: psql connection via localhost or 127.0.0.1  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I am using postgres 9.4beta3 (Debian jessie)

this is my pg_hba.conf
----------------------
local    all    postgres    peer
local    all    all    md5
host    all    all    127.0.0.1/32    md5
host    all    all    ::1/128    md5
----------------------

but if I use psql to connect via tcp to the server (on the same machine)
I can see two differente behaviours if I use "localhost" or "127.0.0.1"
If I understand correctly the first two lines are useful only for Unix
sockets and not for tcp-ip connection.

------ with localhost------------
edoardo@host:~$ psql -h localhost -U postgres
psql (9.4beta3)
Connessione SSL (protocollo: TLSv1.2, cifrario:
ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compressione: disattivato)
Digita "help" per avere un aiuto.

postgres=#
------------------------------
no password request

------ with localhost------------
edoardo@happy:~$ psql -h 127.0.0.1 -U postgres
Inserisci la password per l'utente postgres:
------------------------------
with password request.

Why localhost is not an alias for 127.0.0.1 ?

I did some search on Google but with no useful results

thank you
Edoardo


pgsql-general by date:

Previous
From: Shaun Thomas
Date:
Subject: Re: DATA corruption after promoting slave to master
Next
From: Adrian Klaver
Date:
Subject: Re: psql connection via localhost or 127.0.0.1