PostgreSQL身份验证MD5升级SCRAM-SHA-256

1.查看当前认证方式及所有用户
postgres=# show password_encryption;
password_encryption
---------------------
md5
(1 row)

postgres=# select rolname,rolpassword from pg_authid where rolcanlogin;
rolname | rolpassword
------------+-------------------------------------
postgres | md53175bce1d3201d16594cebf9d7eb3f9d
(1 rows)

2.修改password_encryption参数
vi /pgdb/pgdata/postgresql.conf
password_encryption = scram-sha-256 # md5 or scram-sha-256

3.重新加载数据库配置文件
pg_ctl -D /pgdb/pgdata

4.检查是否加载成功
postgres=# show password_encryption;
password_encryption
---------------------
scram-sha-256
(1 row)

5.再次设置所有密码
postgres=# \password postgres
Enter new password:
Enter it again:

6.配置用户身份映射配置文件 

vi /pgdb/