HGDB确认数据库采用了sm3的连接认证方式

最新推荐文章于 2024-08-22 17:06:54 发布

原创最新推荐文章于 2024-08-22 17:06:54 发布 · 710 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #运维

Highgo DB 专栏收录该内容

171 篇文章

订阅专栏

本文档详细介绍了PostgreSQL数据库中sysdba、syssso、syssao等用户的角色，pg_user和pg_shadow表的内容，以及密码加密方式。探讨了系统管理员、超级用户和其他角色的权限设置，以及数据库密码的安全策略。

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