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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
