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.

i'm stuck in connecting to a PostresSQL database from remote host. The server is accepting incoming connections on port 5432 and i've configured pg_hba.conf like this:

local   all         all                          md5
host    all         all         0.0.0.0/0        md5

and the postgresql.conf like this:

listen_addresses = '*' 
port = 5432
max_connections = 100  

I don't have any problem accessing from local but when i try to connect via psql with something like this:

psql -U myuser -h hostname db_name

I get this error:

psql: FATAL:  no pg_hba.conf entry for host "87.zz.yy.xxx", user "myuser", database "db_name", SSL off

I also tried to put the host 87.zz.yy.xxx in the pg_hba.conf file without success.

share|improve this question

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.