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';