pg数据库开启远程连接_Postgresql开启远程访问

vi /var/lib/pgsql/12/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 ident

host all all 192.168.1.0/24 md5 #加入此行，允许192.168.1.0全网段访问数据库，md5密码验证，ident身份文件验证

# 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

vi /var/lib/pgsql/12/data/postgresql.conf

#listen_addresses='localhost' #取消该行注释，并修改为

listen_addresses = '*' #监听来自任何主机的连接请求

修改密码

su - postgres

psql -d postgres -U postgres

alter user postgres with password '112233';