SEC - 安全

安全功能扩展：强制密码强度，阉割超级用户，密钥管理，商密算法，PII匿名处理，扩展白名单，审计日志，变更追溯，反病毒等等

安全功能扩展：强制密码强度，阉割超级用户，密钥管理，商密算法，PII匿名处理，扩展白名单，审计日志，变更追溯，反病毒等等

共有 28 个扩展包，包含 28 个扩展。

扩展 包 版本 许可证 语言 描述
passwordcheck_cracklib passwordcheck_cracklib 3.1.0 LGPL-2.1 C 使用cracklib加固PG用户密码
supautils supautils 3.1.0 Apache-2.0 C 用于在云环境中确保数据库集群的安全
pgsodium pgsodium 3.1.9 BSD 3-Clause C 表数据加密存储 TDE
supabase_vault pg_vault 0.3.1 Apache-2.0 C 在 Vault 中存储加密凭证的扩展 (supabase)
pg_session_jwt pg_session_jwt 0.4.0 Apache-2.0 Rust 使用JWT进行会话认证
anon pg_anon 3.0.1 PostgreSQL Rust 数据匿名化处理工具
pgsmcrypto pgsmcrypto 0.1.1 MIT Rust 为PostgreSQL提供商密算法支持：SM2,SM3,SM4
pg_enigma pg_enigma 0.5.0 MIT Rust PostgreSQL 加密数据类型
pgaudit pgaudit 18.0 PostgreSQL C 提供审计功能
pgauditlogtofile pgauditlogtofile 1.8.0 PostgreSQL C pgAudit 子扩展，将审计日志写入单独的文件中
pg_auditor pg_auditor 0.2 BSD 3-Clause SQL 审计数据变更并提供闪回能力
logerrors logerrors 2.1.5 BSD 3-Clause C 用于收集日志文件中消息统计信息的函数
pg_auth_mon pg_auth_mon 3.0 MIT C 监控每个用户的连接尝试
pg_jobmon pg_jobmon 1.4.1 PostgreSQL SQL 记录和监控函数
credcheck credcheck 4.6 MIT C 明文凭证检查器
pgcryptokey pgcryptokey 0.85 PostgreSQL C PG密钥管理
pg_pwhash pg_pwhash 1.0 MIT C PostgreSQL 高级密码哈希扩展（Argon2/scrypt/yescrypt）
login_hook login_hook 1.7 GPL-3.0 C 在用户登陆时执行login_hook.login()函数
set_user set_user 4.2.0 PostgreSQL C 增加了日志记录的 SET ROLE
pg_snakeoil pg_snakeoil 1.4 PostgreSQL C PostgreSQL动态链接库反病毒功能
pgextwlist pgextwlist 1.19 PostgreSQL C PostgreSQL扩展白名单功能
sslutils sslutils 1.4 PostgreSQL C 使用SQL管理SSL证书
noset pg_noset 0.3.0 AGPL-3.0 C 阻止非超级用户使用SET/RESET设置变量
pg_tde pg_tde 2.1 MIT C Percona加密存储引擎
sepgsql sepgsql - PostgreSQL C 基于SELinux标签的强制访问控制
auth_delay auth_delay - PostgreSQL C 在返回认证失败前暂停一会，避免爆破
pgcrypto pgcrypto 1.3 PostgreSQL C 实用加解密函数
passwordcheck passwordcheck - PostgreSQL C 用于强制拒绝修改弱密码的扩展

passwordcheck_cracklib - 3.1.0

使用cracklib加固PG用户密码

Extension Website Attributes
Package passwordcheck_cracklib
RPM passwordcheck_cracklib_$v
DEB postgresql-$v-passwordcheck-cracklib LIB
Language C
License LGPL-2.1
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

supautils - 3.1.0

用于在云环境中确保数据库集群的安全

Extension Website Attributes
Package supautils
RPM supautils_$v
DEB postgresql-$v-supautils LIB
Language C
License Apache-2.0
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pgsodium - 3.1.9

表数据加密存储 TDE

Extension Website Attributes
Package pgsodium
RPM pgsodium_$v DDL
DEB postgresql-$v-pgsodium LIB
Language C
License BSD 3-Clause
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

supabase_vault - 0.3.1

在 Vault 中存储加密凭证的扩展 (supabase)

Extension Website Attributes
Package pg_vault
RPM vault_$v DDL
DEB postgresql-$v-vault LIB
Language C
License Apache-2.0
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_session_jwt - 0.4.0

使用JWT进行会话认证

Extension Website Attributes
Package pg_session_jwt
RPM pg_session_jwt_$v DDL
DEB postgresql-$v-pg-session-jwt LIB
Language Rust TRUST
License Apache-2.0
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

anon - 3.0.1

数据匿名化处理工具

Extension Website Attributes
Package pg_anon
RPM pg_anon_$v DDL
DEB postgresql-$v-pg-anon LIB
Language Rust
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pgsmcrypto - 0.1.1

为PostgreSQL提供商密算法支持：SM2,SM3,SM4

Extension Website Attributes
Package pgsmcrypto
RPM pgsmcrypto_$v DDL
DEB postgresql-$v-pgsmcrypto LIB
Language Rust
License MIT
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_enigma - 0.5.0

PostgreSQL 加密数据类型

Extension Website Attributes
Package pg_enigma
RPM pg_enigma_$v DDL
DEB postgresql-$v-enigma LIB
Language Rust
License MIT
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pgaudit - 18.0

提供审计功能

Extension Website Attributes
Package pgaudit
RPM pgaudit_$v DDL
DEB postgresql-$v-pgaudit LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pgauditlogtofile - 1.8.0

pgAudit 子扩展，将审计日志写入单独的文件中

Extension Website Attributes
Package pgauditlogtofile
RPM pgauditlogtofile_$v DDL
DEB postgresql-$v-pgauditlogtofile LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_auditor - 0.2

审计数据变更并提供闪回能力

Extension Website Attributes
Package pg_auditor
RPM pg_auditor_$v DDL
DEB postgresql-$v-pg-auditor
Language SQL
License BSD 3-Clause
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

logerrors - 2.1.5

用于收集日志文件中消息统计信息的函数

Extension Website Attributes
Package logerrors
RPM logerrors_$v DDL
DEB postgresql-$v-logerrors LIB
Language C
License BSD 3-Clause
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_auth_mon - 3.0

监控每个用户的连接尝试

Extension Website Attributes
Package pg_auth_mon
RPM pg_auth_mon_$v DDL
DEB postgresql-$v-pg-auth-mon LIB
Language C
License MIT
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_jobmon - 1.4.1

记录和监控函数

Extension Website Attributes
Package pg_jobmon
RPM pg_jobmon_$v DDL
DEB postgresql-$v-pg-jobmon LIB
Language SQL
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

credcheck - 4.6

明文凭证检查器

Extension Website Attributes
Package credcheck
RPM credcheck_$v DDL
DEB postgresql-$v-credcheck LIB
Language C
License MIT
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pgcryptokey - 0.85

PG密钥管理

Extension Website Attributes
Package pgcryptokey
RPM pgcryptokey_$v DDL
DEB postgresql-$v-pgcryptokey LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_pwhash - 1.0

PostgreSQL 高级密码哈希扩展（Argon2/scrypt/yescrypt）

Extension Website Attributes
Package pg_pwhash
RPM pg_pwhash_$v DDL
DEB postgresql-$v-pg-pwhash LIB
Language C
License MIT
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

login_hook - 1.7

在用户登陆时执行login_hook.login()函数

Extension Website Attributes
Package login_hook
RPM login_hook_$v DDL
DEB postgresql-$v-login-hook LIB
Language C
License GPL-3.0
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

set_user - 4.2.0

增加了日志记录的 SET ROLE

Extension Website Attributes
Package set_user
RPM set_user_$v DDL
DEB postgresql-$v-set-user LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_snakeoil - 1.4

PostgreSQL动态链接库反病毒功能

Extension Website Attributes
Package pg_snakeoil
RPM pg_snakeoil_$v
DEB postgresql-$v-snakeoil LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pgextwlist - 1.19

PostgreSQL扩展白名单功能

Extension Website Attributes
Package pgextwlist
RPM pgextwlist_$v
DEB postgresql-$v-pgextwlist LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

sslutils - 1.4

使用SQL管理SSL证书

Extension Website Attributes
Package sslutils
RPM sslutils_$v DDL
DEB postgresql-$v-sslutils LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

noset - 0.3.0

阻止非超级用户使用SET/RESET设置变量

Extension Website Attributes
Package pg_noset
RPM noset_$v DDL
DEB postgresql-$v-noset LIB
Language C
License AGPL-3.0
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_tde - 2.1

Percona加密存储引擎

Extension Website Attributes
Package pg_tde
RPM percona-postgresql$v DDL
DEB percona-postgresql-$v LIB
Language C
License MIT
OS/Archx86_64aarch64
el8
el9
el10
d12
d13
u22
u24

sepgsql - -

基于SELinux标签的强制访问控制

Extension Website Attributes
Package sepgsql
RPM postgresql$v-contrib
DEB postgresql-$v LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el8
el9
el10
d12
d13
u22
u24

auth_delay - -

在返回认证失败前暂停一会，避免爆破

Extension Website Attributes
Package auth_delay
RPM postgresql$v-contrib
DEB postgresql-$v LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el8
el9
el10
d12
d13
u22
u24

pgcrypto - 1.3

实用加解密函数

Extension Website Attributes
Package pgcrypto
RPM postgresql$v-contrib DDL
DEB postgresql-$v LIB
Language C TRUST
License PostgreSQL
OS/Archx86_64aarch64
el8
el9
el10
d12
d13
u22
u24

passwordcheck - -

用于强制拒绝修改弱密码的扩展

Extension Website Attributes
Package passwordcheck
RPM postgresql$v-contrib
DEB postgresql-$v LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el8
el9
el10
d12
d13
u22
u24