Remote access to PostgreSQL

2018-06-08 10:13:08

I am using PostgreSQL database which is installed on other system. So I have fulfilled all requirement for remote access on host machine like,

Configured the pg_hba.conf file with host as "host all all 0.0.0.0/0 md5"

added * instead of Localhost in postgresql.conf

Restarted the postgresql services

But now when i tried to establish connection through client machine , I am getting error like,

  Unable to connect to server:
FATAL: no pg_hba.conf entry for host "192.168.1.28", user "postgres", database "JyotiDB", SSL off

Please can anyone suggest me right way to establish remote connection.

链接地址: http://www.djcxy.com/p/25508.html