Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Im getting this error with postgre in my centos vps

Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "::1", user "xxx", database "xxx_xxx", SSL off in

Here is my pg_hba.conf

local all all md5 
host all all 127.0.0.1/32 md5

Everything seems right, but always get this error, no matter what user i create and set.

share|improve this question
add comment

1 Answer

Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "::1", user "xxx", database "xxx_xxx", SSL off in

"::1" means that you're connecting via IPv6.

Either specify -h 127.0.0.1 or add/uncomment an entry to/in pg_hba.conf:

host all all ::1/128 md5 
share|improve this answer
    
No, still not working with host all all ::1/128 md5 Wha do you mean with Either specify -h 127.0.0.1 ? –  Andre Aug 21 '12 at 19:50
1  
I mean psql -h 127.0.0.1 -U.... –  quanta Aug 21 '12 at 19:57
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.