ADMIN - 管理

管理工具扩展：膨胀治理，脏读，检视缓冲区，数据目录，校验和，腐败检查，优先级管理，权限管理，语句准备，限制批量更新等

管理工具扩展：膨胀治理，脏读，检视缓冲区，数据目录，校验和，腐败检查，优先级管理，权限管理，语句准备，限制批量更新等

共有 38 个扩展包，包含 40 个扩展。

扩展 包 版本 许可证 语言 描述
pg_repack pg_repack 1.5.3 PostgreSQL C 在线垃圾清理与表膨胀治理
pg_rewrite pg_rewrite 2.1.0 BSD 3-Clause C 在线重写整表，不阻塞读写
pg_squeeze pg_squeeze 1.9.1 BSD 2-Clause C 从关系中删除未使用空间
pg_dirtyread pg_dirtyread 2.7 BSD 3-Clause C 从表中读取尚未垃圾回收的行
pgfincore pgfincore 1.3.1 BSD 3-Clause C 检查和管理操作系统缓冲区缓存
pg_cooldown pg_cooldown 0.1 Apache-2.0 C 从缓冲区中移除特定关系的页面
ddlx pg_ddlx 0.30 PostgreSQL SQL 提取数据库对象的DDL
pglinter pglinter 1.1.1 PostgreSQL Rust PG数据库规则检查插件
prioritize pg_prioritize 1.0.4 PostgreSQL C 获取和设置 PostgreSQL 后端的优先级
pg_checksums pg_checksums 1.3 BSD 2-Clause C 在离线模式下激活/启用/禁用数据库集群的校验和功能
pg_readonly pg_readonly 1.0.4 PostgreSQL C 将集群设置为只读
pgdd pgdd 0.6.1 MIT Rust 提供通过标准SQL查询数据库目录集簇的能力
pg_permissions pg_permissions 1.4 BSD 2-Clause SQL 查看对象权限并将其与期望状态进行比较
pgautofailover pgautofailover 2.2 PostgreSQL C PG 自动故障迁移
pg_catcheck pg_catcheck 1.6.0 BSD 3-Clause C 用于诊断系统目录是否损坏的工具
pre_prepare preprepare 0.9 PostgreSQL C 在服务端预先准备好PreparedStatement备用
pg_upless pg_upless 0.0.3 PostgreSQL SQL 检测表上的无用UPDATE
pgcozy pgcozy 1.0 PostgreSQL SQL 根据先前的pg_buffercache快照预热内存缓冲区
pg_orphaned pg_orphaned 1.0 PostgreSQL C 处理孤儿文件的扩展插件
pg_crash pg_crash 1.0 BSD 3-Clause C 向数据库进程随机发送信号模拟故障
pg_cheat_funcs pg_cheat_funcs 1.0 PostgreSQL C 一些超级实用的作弊函数
fio pg_fio 1.0 BSD 3-Clause C PostgreSQL文件IO函数包
qos pg_qos 1.0 GPL-3.0 C PostgreSQL QoS 资源治理扩展（会话与查询限流/隔离）
pg_savior pg_savior 0.0.1 Apache-2.0 C 阻止不带条件的全表更新以避免意外事故
safeupdate safeupdate 1.5 ISC C 强制在 UPDATE 和 DELETE 时提供 Where 条件
pg_strict pg_strict 1.0.2 MIT Rust 防止不带WHERE条件的危险UPDATE和DELETE操作
pg_drop_events pg_drop_events 0.1.0 PostgreSQL SQL 记录删表删列删视图的事务号，辅助PITR确定时间点
table_log table_log 0.6.4 PostgreSQL C 记录某张表的修改日志并做表/行级时间点恢复
pgagent pgagent 4.2.3 PostgreSQL C PostgreSQL任务调度工具，与PGADMIN配合使用
pg_prewarm pg_prewarm 1.2 PostgreSQL C 预热关系数据
pgpool_adm pgpool 4.7.1 PostgreSQL C PGPool 管理函数
pgpool_recovery pgpool 4.7.1 PostgreSQL C PGPool辅助扩展，从v4.3提供的恢复函数
pgpool_regclass pgpool 4.7.1 PostgreSQL C PGPool辅助扩展，RegClass替代
lo lo 1.1 PostgreSQL C 大对象维护
basic_archive basic_archive - PostgreSQL C 归档模块样例
basebackup_to_shell basebackup_to_shell - PostgreSQL C 添加一种备份到Shell终端到基础备份方式
old_snapshot old_snapshot 1.0 PostgreSQL C 支持 old_snapshot_threshold 的实用程序
adminpack adminpack 2.1 PostgreSQL C PostgreSQL 管理函数集合
amcheck amcheck 1.4 PostgreSQL C 校验关系完整性
pg_surgery pg_surgery 1.0 PostgreSQL C 对损坏的关系进行手术

pg_repack - 1.5.3

在线垃圾清理与表膨胀治理

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

pg_rewrite - 2.1.0

在线重写整表，不阻塞读写

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

pg_squeeze - 1.9.1

从关系中删除未使用空间

Extension Website Attributes
Package pg_squeeze
RPM pg_squeeze_$v DDL
DEB postgresql-$v-squeeze LIB
Language C
License BSD 2-Clause
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_dirtyread - 2.7

从表中读取尚未垃圾回收的行

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

pgfincore - 1.3.1

检查和管理操作系统缓冲区缓存

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

pg_cooldown - 0.1

从缓冲区中移除特定关系的页面

Extension Website Attributes
Package pg_cooldown
RPM pg_cooldown_$v DDL
DEB postgresql-$v-pg-cooldown LIB
Language C
License Apache-2.0
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

ddlx - 0.30

提取数据库对象的DDL

Extension Website Attributes
Package pg_ddlx
RPM ddlx_$v DDL
DEB postgresql-$v-ddlx LIB
Language SQL
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pglinter - 1.1.1

PG数据库规则检查插件

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

prioritize - 1.0.4

获取和设置 PostgreSQL 后端的优先级

Extension Website Attributes
Package pg_prioritize
RPM pg_prioritize_$v DDL
DEB postgresql-$v-prioritize LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el9181716151817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_checksums - 1.3

在离线模式下激活/启用/禁用数据库集群的校验和功能

Extension Website Attributes
Package pg_checksums
RPM pg_checksums_$v
DEB postgresql-$v-pg-checksums LIB
Language C
License BSD 2-Clause
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_readonly - 1.0.4

将集群设置为只读

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

pgdd - 0.6.1

提供通过标准SQL查询数据库目录集簇的能力

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

pg_permissions - 1.4

查看对象权限并将其与期望状态进行比较

Extension Website Attributes
Package pg_permissions
RPM pg_permissions_$v DDL
DEB postgresql-$v-pg-permissions LIB
Language SQL TRUST
License BSD 2-Clause
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pgautofailover - 2.2

PG 自动故障迁移

Extension Website Attributes
Package pgautofailover
RPM pg_auto_failover_$v DDL
DEB postgresql-$v-auto-failover LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el81716151417161514
el91716151417161514
el101716151417161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_catcheck - 1.6.0

用于诊断系统目录是否损坏的工具

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

pre_prepare - 0.9

在服务端预先准备好PreparedStatement备用

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

pg_upless - 0.0.3

检测表上的无用UPDATE

Extension Website Attributes
Package pg_upless
RPM pg_upless_$v DDL
DEB postgresql-$v-pg-upless
Language SQL TRUST
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pgcozy - 1.0

根据先前的pg_buffercache快照预热内存缓冲区

Extension Website Attributes
Package pgcozy
RPM pgcozy_$v DDL
DEB postgresql-$v-pgcozy
Language SQL
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_orphaned - 1.0

处理孤儿文件的扩展插件

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

pg_crash - 1.0

向数据库进程随机发送信号模拟故障

Extension Website Attributes
Package pg_crash
RPM pg_crash_$v
DEB postgresql-$v-pg-crash LIB
Language C
License BSD 3-Clause
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_cheat_funcs - 1.0

一些超级实用的作弊函数

Extension Website Attributes
Package pg_cheat_funcs
RPM pg_cheat_funcs_$v DDL
DEB postgresql-$v-pg-cheat-funcs LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

fio - 1.0

PostgreSQL文件IO函数包

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

qos - 1.0

PostgreSQL QoS 资源治理扩展（会话与查询限流/隔离）

Extension Website Attributes
Package pg_qos
RPM pg_qos_$v DDL
DEB postgresql-$v-qos LIB
Language C
License GPL-3.0
OS/Archx86_64aarch64
el81817161518171615
el91817161518171615
el101817161518171615
d121817161518171615
d131817161518171615
u221817161518171615
u241817161518171615

pg_savior - 0.0.1

阻止不带条件的全表更新以避免意外事故

Extension Website Attributes
Package pg_savior
RPM pg_savior_$v DDL
DEB postgresql-$v-pg-savior LIB
Language C
License Apache-2.0
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

safeupdate - 1.5

强制在 UPDATE 和 DELETE 时提供 Where 条件

Extension Website Attributes
Package safeupdate
RPM safeupdate_$v
DEB postgresql-$v-pg-safeupdate LIB
Language C
License ISC
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_strict - 1.0.2

防止不带WHERE条件的危险UPDATE和DELETE操作

Extension Website Attributes
Package pg_strict
RPM pg_strict_$v DDL
DEB pg_strict_$v LIB
Language Rust
License MIT
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d12
d13
u22
u24

pg_drop_events - 0.1.0

记录删表删列删视图的事务号，辅助PITR确定时间点

Extension Website Attributes
Package pg_drop_events
RPM pg_drop_events_$v DDL
DEB postgresql-$v-pg-drop-events
Language SQL
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

table_log - 0.6.4

记录某张表的修改日志并做表/行级时间点恢复

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

pgagent - 4.2.3

PostgreSQL任务调度工具，与PGADMIN配合使用

Extension Website Attributes
Package pgagent
RPM pgagent_$v DDL
DEB pgagent LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d12
d13
u22
u24

pg_prewarm - 1.2

预热关系数据

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

pgpool_adm - 4.7.1

PGPool 管理函数

Extension Website Attributes
Package pgpool
RPM pgpool-II-pg$v-extensions DDL
DEB postgresql-$v-pgpool2
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

lo - 1.1

大对象维护

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

basic_archive - -

归档模块样例

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

basebackup_to_shell - -

添加一种备份到Shell终端到基础备份方式

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

old_snapshot - 1.0

支持 old_snapshot_threshold 的实用程序

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

adminpack - 2.1

PostgreSQL 管理函数集合

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

amcheck - 1.4

校验关系完整性

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

pg_surgery - 1.0

对损坏的关系进行手术

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