On 15/05/28 17:55, arnaud gaboury wrote:
(...)
> I can't log from the phppgadmin. I have login failed.
> First, I am not sure if I shall log with my unix account or postgres
> role (I guess the latter one).
>
> Log:
> LOG: database system is ready to accept connections
> LOG: connection received: host=[local]
> LOG: connection received: host=::1 port=39999
> FATAL: no pg_hba.conf entry for host "::1", user "mediawiki",
> database "postgres", SSL off
>
> I see there is a problem in my pg_hba.conf, but can't see how to set
> up it correctly.
> pg_hba.conf
> ----------------------
> # TYPE DATABASE USER ADDRESS METHOD
>
> # "local" is for Unix domain socket connections only
> local all all md5
> # IPv4 local connections:
> host all all 127.0.0.1/32 md5
> # IPv6 local connections:
> --------------------------------------
Looks like you're missing an entry for IPv6 in pg_hba.conf; something
like this:
host all all ::1/128 md5
Regards
Ian Barwick
--
Ian Barwick http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services