On Thu, May 28, 2015 at 11:04 AM, Ian Barwick <ian@xxxxxxxxxxxxxxx> wrote: > 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 YES. I just uncommented the line a few mn ago and now it is OK. TY > > > Regards > > Ian Barwick > > -- > Ian Barwick http://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services -- google.com/+arnaudgabourygabx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
