
首先查看配置文件位置:
[postgres@localhost ~]$ psql
psql (16.3)
Type "help" for help.
postgres=# show config_file;
config_file
----------------------------------------
/var/lib/pgsql/16/data/postgresql.conf
(1 row)然后修改/var/lib/pgsql/16/data/postgresql.conf,修改listen_addresses配置:
listen_addresses = '*' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost'; use '*' for all
# (change requires restart)接下来修改/var/lib/pgsql/16/data/pg_hba.conf,加入以下配置:
host all all 0.0.0.0/0 scram-sha-256然后重启postgresql:
$ sudo systemctl restart postgresql-16.service