postgres遠(yuǎn)程連接方式配置

配置pg_hba.conf文件 目錄C:Program FilesPostgreSQL9.5data

(QXY)主機(jī)
[postgres@qxy data]$ pwd
/spark/pgsql/data
[postgres@qxy data]$ cat pg_hba.conf
# TYPE DATABASE USER ADDRESS METHOD
# “l(fā)ocal” is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust