开启Postgresql得远程访问
开启Postgresql得远程访问,分别需要编辑以下两个配置文件:
配置文件一(pg_hba.conf
)
vi /var/lib/pgsql/10/data/pg_hba.conf
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 127.0.0.1/32 trust
############################在此位置加入一行##########################
# IPv6 local connections:
host all all ::1/128 ident
# Allow replication connections from localhost, by a user with the
# replication privilege.
local replication all peer
host replication all 127.0.0.1/32 ident
host replication all ::1/128 ident
开放远程访问,但需ident
身份文件验证:
host all all 192.168.1.0/24 ident
开放远程访问,但需md5
密码验证:
host all all 192.168.1.0/24 md5
开放远程访问,无需密码
就能连接:
host all all 192.168.1.0/24 trust
配置文件二(postgresql.conf
)
vi /var/lib/pgsql/10/data/postgresql.conf
#listen_addresses='localhost' # 取消此行注释,将'localhost'修改为'*'
listen_addresses = '*' # '*'意思是监听来自任何主机的连接请求,'localhost'是只监听来自本地的连接请求