Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

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.