highgo=# select * from pg_user;
usename | usesysid | usecreatedb | usesuper | userepl | usebypassrls | passwd | valuntil | useconfig
----------------+----------+-------------+----------+---------+--------------+----------+------------------------+-----------
sysdba | 9999 | t | f | t | f | ******** | 2023-03-17 16:33:53+08 |
syssso | 9998 | f | f | f | f | ******** | 2023-03-17 16:33:35+08 |
syssao | 9997 | f | f | f | f | ******** | 2023-03-17 16:34:39+08 |
hg_replication | 16384 | f | f | t | f | ******** | 2022-03-16 14:43:12+08 |
hg_rewind | 16385 | f | f | f | f | ******** | 2022-03-16 14:43:12+08 |
(5 rows)
highgo=# select * from pg_shadow;
usename | usesysid | usecreatedb | usesuper | userepl | usebypassrls | passwd | valuntil | useconfig
----------------+----------+-------------+----------+---------+--------------+---------------------------------------------------------------------+------------------------+-----------
sysdba | 9999 | t | f | t | f | sm3a62e9a53cd338b94b31db1f3fe8609441d17a05763b5346aefad2718c4711697 | 2023-03-17 16:33:53+08 |
syssso | 9998 | f | f | f | f | sm3e7e0296d186aa1c9ab45244db9a3e85ca82d215dba4089062a076e2534547b5b | 2023-03-17 16:33:35+08 |
syssao | 9997 | f | f | f | f | sm376368159947d96a6cf15aa4cea7147b7614413365bdc10dc92da655d2a5ae296 | 2023-03-17 16:34:39+08 |
hg_replication | 16384 | f | f | t | f | sm34db16278b84fa0426921ef3ef7aa7ecdeae6fc793abdd62ec5bf5ac121c2bea7 | 2022-03-16 14:43:12+08 |
hg_rewind | 16385 | f | f | f | f | sm31d9eea98a6c51fcd8489058621c4a289cebe59f8a06b1e18c1b6119e291e0e57 | 2022-03-16 14:43:12+08 |
(5 rows)
highgo=# show password_encryption ;
password_encryption
---------------------
sm3
(1 row)
[root@db2 data]# cat pg_hba.conf
# Do not edit this file manually!
# It will be overwritten by Patroni!
local all all sm3
host all all 0.0.0.0/0 sm3
host all all ::1/128 sm3
local replication all sm3
host replication all 0.0.0.0/0 sm3
host replication all ::1/128 sm3