Connection rejected: FATAL: no pg_hba.conf entry for host
If you get this message in a PostgreSQL connection:
If you get this message in a PostgreSQL connection:
org.postgresql.util.PSQLException:
Connection rejected: FATAL: no pg_hba.conf entry for host
"192.168.1.1", user "userdb", database
"exampledb", SSL off.
Just put your
IP address in the pg_hba.conf file, Windows path C:\Program Files\PostgreSQL\9.0\data\
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# IPv4 local
connections:
host all all 127.0.0.1/32 md5
host all all 192.168.1.1/32 md5
No comments:
Post a Comment