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

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        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 "", user "myuser", database "db_name", SSL off

I also tried to put the host in the pg_hba.conf file without success.

share|improve this question

Your Answer


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

Browse other questions tagged or ask your own question.