no pg_hba.conf entry for host "[local]", user "postgres", database "template1"

I have this message:
vacuumdb: could not connect to database template1: FATAL:  no pg_hba.conf entry for host "[local]", user "postgres", database "template1", SSL off
Solution is to open file:
/var/lib/pgsql/data/pg_hba.conf
Add these lines:
local all all md5
host all all 127.0.0.1 255.255.255.255 md5
Restart Postgres service:
service postgresql restart
And of course leave a comment if this solve your case ;)

1 comment:

  1. local all all md5
    saved me alot of time. Worked well with me

    ReplyDelete