ADMIN - 管理

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

扩展列表

共有 40 个扩展,位于 38 个扩展包中。

扩展版本许可证语言描述
pg_repackpg_repack1.5.3PostgreSQLC在线垃圾清理与表膨胀治理
pg_rewritepg_rewrite2.1.0BSD 3-ClauseC在线重写整表,不阻塞读写
pg_squeezepg_squeeze1.9.1BSD 2-ClauseC从关系中删除未使用空间
pg_dirtyreadpg_dirtyread2.7BSD 3-ClauseC从表中读取尚未垃圾回收的行
pgfincorepgfincore1.3.1BSD 3-ClauseC检查和管理操作系统缓冲区缓存
pg_cooldownpg_cooldown0.1Apache-2.0C从缓冲区中移除特定关系的页面
ddlxpg_ddlx0.30PostgreSQLSQL提取数据库对象的DDL
pglinterpglinter1.1.1PostgreSQLRustPG数据库规则检查插件
prioritizepg_prioritize1.0.4PostgreSQLC获取和设置 PostgreSQL 后端的优先级
pg_checksumspg_checksums1.3BSD 2-ClauseC在离线模式下激活/启用/禁用数据库集群的校验和功能
pg_readonlypg_readonly1.0.4PostgreSQLC将集群设置为只读
pgddpgdd0.6.1MITRust提供通过标准SQL查询数据库目录集簇的能力
pg_permissionspg_permissions1.4BSD 2-ClauseSQL查看对象权限并将其与期望状态进行比较
pgautofailoverpgautofailover2.2PostgreSQLCPG 自动故障迁移
pg_catcheckpg_catcheck1.6.0BSD 3-ClauseC用于诊断系统目录是否损坏的工具
pre_preparepreprepare0.9PostgreSQLC在服务端预先准备好PreparedStatement备用
pg_uplesspg_upless0.0.3PostgreSQLSQL检测表上的无用UPDATE
pgcozypgcozy1.0PostgreSQLSQL根据先前的pg_buffercache快照预热内存缓冲区
pg_orphanedpg_orphaned1.0PostgreSQLC处理孤儿文件的扩展插件
pg_crashpg_crash1.0BSD 3-ClauseC向数据库进程随机发送信号模拟故障
pg_cheat_funcspg_cheat_funcs1.0PostgreSQLC一些超级实用的作弊函数
fiopg_fio1.0BSD 3-ClauseCPostgreSQL文件IO函数包
qospg_qos1.0GPL-3.0CPostgreSQL QoS 资源治理扩展(会话与查询限流/隔离)
pg_saviorpg_savior0.0.1Apache-2.0C阻止不带条件的全表更新以避免意外事故
safeupdatesafeupdate1.5ISCC强制在 UPDATE 和 DELETE 时提供 Where 条件
pg_strictpg_strict1.0.2MITRust防止不带WHERE条件的危险UPDATE和DELETE操作
pg_drop_eventspg_drop_events0.1.0PostgreSQLSQL记录删表删列删视图的事务号,辅助PITR确定时间点
table_logtable_log0.6.4PostgreSQLC记录某张表的修改日志并做表/行级时间点恢复
pgagentpgagent4.2.3PostgreSQLCPostgreSQL任务调度工具,与PGADMIN配合使用
pg_prewarmpg_prewarm1.2PostgreSQLC预热关系数据
pgpool_admpgpool4.7.1PostgreSQLCPGPool 管理函数
pgpool_recoverypgpool4.7.1PostgreSQLCPGPool辅助扩展,从v4.3提供的恢复函数
pgpool_regclasspgpool4.7.1PostgreSQLCPGPool辅助扩展,RegClass替代
lolo1.1PostgreSQLC大对象维护
basic_archivebasic_archive-PostgreSQLC归档模块样例
basebackup_to_shellbasebackup_to_shell-PostgreSQLC添加一种备份到Shell终端到基础备份方式
old_snapshotold_snapshot1.0PostgreSQLC支持 old_snapshot_threshold 的实用程序
adminpackadminpack2.1PostgreSQLCPostgreSQL 管理函数集合
amcheckamcheck1.4PostgreSQLC校验关系完整性
pg_surgerypg_surgery1.0PostgreSQLC对损坏的关系进行手术

pg_repack

pg_repack - 1.5.3 : 在线垃圾清理与表膨胀治理

条目属性OSx86_64aarch64
扩展名pg_repackel818171615141817161514
扩展包pg_repackel918171615141817161514
RPMpg_repack_$vel1018171615141817161514
DEBpostgresql-$v-repackd1218171615141817161514
语言Cd1318171615141817161514
仓库PGDGu2218171615141817161514
协议PostgreSQLu2418171615141817161514

pg_rewrite

pg_rewrite - 2.1.0 : 在线重写整表,不阻塞读写

条目属性OSx86_64aarch64
扩展名pg_rewriteel818171615141817161514
扩展包pg_rewriteel918171615141817161514
RPMpg_rewrite_$vel1018171615141817161514
DEBpostgresql-$v-pg-rewrited1218171615141817161514
语言Cd1318171615141817161514
仓库PGDGu2218171615141817161514
协议BSD 3-Clauseu2418171615141817161514

pg_squeeze

pg_squeeze - 1.9.1 : 从关系中删除未使用空间

条目属性OSx86_64aarch64
扩展名pg_squeezeel818171615141817161514
扩展包pg_squeezeel918171615141817161514
RPMpg_squeeze_$vel1018171615141817161514
DEBpostgresql-$v-squeezed1218171615141817161514
语言Cd1318171615141817161514
仓库PGDGu2218171615141817161514
协议BSD 2-Clauseu2418171615141817161514

pg_dirtyread

pg_dirtyread - 2.7 : 从表中读取尚未垃圾回收的行

条目属性OSx86_64aarch64
扩展名pg_dirtyreadel818171615141817161514
扩展包pg_dirtyreadel918171615141817161514
RPMpg_dirtyread_$vel1018171615141817161514
DEBpostgresql-$v-dirtyreadd1218171615141817161514
语言Cd1318171615141817161514
仓库PGDGu2218171615141817161514
协议BSD 3-Clauseu2418171615141817161514

pgfincore

pgfincore - 1.3.1 : 检查和管理操作系统缓冲区缓存

条目属性OSx86_64aarch64
扩展名pgfincoreel818171615141817161514
扩展包pgfincoreel918171615141817161514
RPMpgfincore_$vel1018171615141817161514
DEBpostgresql-$v-pgfincored1218171615141817161514
语言Cd1318171615141817161514
仓库PGDGu2218171615141817161514
协议BSD 3-Clauseu2418171615141817161514

pg_cooldown

pg_cooldown - 0.1 : 从缓冲区中移除特定关系的页面

条目属性OSx86_64aarch64
扩展名pg_cooldownel818171615141817161514
扩展包pg_cooldownel918171615141817161514
RPMpg_cooldown_$vel1018171615141817161514
DEBpostgresql-$v-pg-cooldownd1218171615141817161514
语言Cd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议Apache-2.0u2418171615141817161514

ddlx

pg_ddlx - 0.30 : 提取数据库对象的DDL

条目属性OSx86_64aarch64
扩展名ddlxel818171615141817161514
扩展包pg_ddlxel918171615141817161514
RPMddlx_$vel1018171615141817161514
DEBpostgresql-$v-ddlxd1218171615141817161514
语言SQLd1318171615141817161514
仓库MIXEDu2218171615141817161514
协议PostgreSQLu2418171615141817161514

pglinter

pglinter - 1.1.1 : PG数据库规则检查插件

条目属性OSx86_64aarch64
扩展名pglinterel818171615141817161514
扩展包pglinterel918171615141817161514
RPMpglinter_$vel1018171615141817161514
DEBpostgresql-$v-pglinterd1218171615141817161514
语言Rustd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议PostgreSQLu2418171615141817161514

prioritize

pg_prioritize - 1.0.4 : 获取和设置 PostgreSQL 后端的优先级

条目属性OSx86_64aarch64
扩展名prioritizeel818171615141817161514
扩展包pg_prioritizeel918171615141817161514
RPMpg_prioritize_$vel1018171615141817161514
DEBpostgresql-$v-prioritized1218171615141817161514
语言Cd1318171615141817161514
仓库PGDGu2218171615141817161514
协议PostgreSQLu2418171615141817161514

pg_checksums

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

条目属性OSx86_64aarch64
扩展名pg_checksumsel818171615141817161514
扩展包pg_checksumsel918171615141817161514
RPMpg_checksums_$vel1018171615141817161514
DEBpostgresql-$v-pg-checksumsd1218171615141817161514
语言Cd1318171615141817161514
仓库PGDGu2218171615141817161514
协议BSD 2-Clauseu2418171615141817161514

pg_readonly

pg_readonly - 1.0.4 : 将集群设置为只读

条目属性OSx86_64aarch64
扩展名pg_readonlyel818171615141817161514
扩展包pg_readonlyel918171615141817161514
RPMpg_readonly_$vel1018171615141817161514
DEBpostgresql-$v-pg-readonlyd1218171615141817161514
语言Cd1318171615141817161514
仓库MIXEDu2218171615141817161514
协议PostgreSQLu2418171615141817161514

pgdd

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

条目属性OSx86_64aarch64
扩展名pgddel818171615141817161514
扩展包pgddel918171615141817161514
RPMpgdd_$vel1018171615141817161514
DEBpostgresql-$v-pgddd1218171615141817161514
语言Rustd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议MITu2418171615141817161514

pg_permissions

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

条目属性OSx86_64aarch64
扩展名pg_permissionsel818171615141817161514
扩展包pg_permissionsel918171615141817161514
RPMpg_permissions_$vel1018171615141817161514
DEBpostgresql-$v-pg-permissionsd1218171615141817161514
语言SQLd1318171615141817161514
仓库MIXEDu2218171615141817161514
协议BSD 2-Clauseu2418171615141817161514

pgautofailover

pgautofailover - 2.2 : PG 自动故障迁移

条目属性OSx86_64aarch64
扩展名pgautofailoverel818171615141817161514
扩展包pgautofailoverel918171615141817161514
RPMpg_auto_failover_$vel1018171615141817161514
DEBpostgresql-$v-auto-failoverd1218171615141817161514
语言Cd1318171615141817161514
仓库PGDGu2218171615141817161514
协议PostgreSQLu2418171615141817161514

pg_catcheck

pg_catcheck - 1.6.0 : 用于诊断系统目录是否损坏的工具

条目属性OSx86_64aarch64
扩展名pg_catcheckel818171615141817161514
扩展包pg_catcheckel918171615141817161514
RPMpg_catcheck_$vel1018171615141817161514
DEBpostgresql-$v-pg-catcheckd1218171615141817161514
语言Cd1318171615141817161514
仓库PGDGu2218171615141817161514
协议BSD 3-Clauseu2418171615141817161514

pre_prepare

preprepare - 0.9 : 在服务端预先准备好PreparedStatement备用

条目属性OSx86_64aarch64
扩展名pre_prepareel818171615141817161514
扩展包preprepareel918171615141817161514
RPMpreprepare_$vel1018171615141817161514
DEBpostgresql-$v-preprepared1218171615141817161514
语言Cd1318171615141817161514
仓库MIXEDu2218171615141817161514
协议PostgreSQLu2418171615141817161514

pg_upless

pg_upless - 0.0.3 : 检测表上的无用UPDATE

条目属性OSx86_64aarch64
扩展名pg_uplessel818171615141817161514
扩展包pg_uplessel918171615141817161514
RPMpg_upless_$vel1018171615141817161514
DEBpostgresql-$v-pg-uplessd1218171615141817161514
语言SQLd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议PostgreSQLu2418171615141817161514

pgcozy

pgcozy - 1.0 : 根据先前的pg_buffercache快照预热内存缓冲区

条目属性OSx86_64aarch64
扩展名pgcozyel818171615141817161514
扩展包pgcozyel918171615141817161514
RPMpgcozy_$vel1018171615141817161514
DEBpostgresql-$v-pgcozyd1218171615141817161514
语言SQLd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议PostgreSQLu2418171615141817161514

pg_orphaned

pg_orphaned - 1.0 : 处理孤儿文件的扩展插件

条目属性OSx86_64aarch64
扩展名pg_orphanedel818171615141817161514
扩展包pg_orphanedel918171615141817161514
RPMpg_orphaned_$vel1018171615141817161514
DEBpostgresql-$v-pg-orphanedd1218171615141817161514
语言Cd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议PostgreSQLu2418171615141817161514

pg_crash

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

条目属性OSx86_64aarch64
扩展名pg_crashel818171615141817161514
扩展包pg_crashel918171615141817161514
RPMpg_crash_$vel1018171615141817161514
DEBpostgresql-$v-pg-crashd1218171615141817161514
语言Cd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议BSD 3-Clauseu2418171615141817161514

pg_cheat_funcs

pg_cheat_funcs - 1.0 : 一些超级实用的作弊函数

条目属性OSx86_64aarch64
扩展名pg_cheat_funcsel818171615141817161514
扩展包pg_cheat_funcsel918171615141817161514
RPMpg_cheat_funcs_$vel1018171615141817161514
DEBpostgresql-$v-pg-cheat-funcsd1218171615141817161514
语言Cd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议PostgreSQLu2418171615141817161514

fio

pg_fio - 1.0 : PostgreSQL文件IO函数包

条目属性OSx86_64aarch64
扩展名fioel818171615141817161514
扩展包pg_fioel918171615141817161514
RPMpg_fio_$vel1018171615141817161514
DEBpostgresql-$v-pg-fiod1218171615141817161514
语言Cd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议BSD 3-Clauseu2418171615141817161514

qos

pg_qos - 1.0 : PostgreSQL QoS 资源治理扩展(会话与查询限流/隔离)

条目属性OSx86_64aarch64
扩展名qosel818171615141817161514
扩展包pg_qosel918171615141817161514
RPMpg_qos_$vel1018171615141817161514
DEBpostgresql-$v-qosd1218171615141817161514
语言Cd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议GPL-3.0u2418171615141817161514

pg_savior

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

条目属性OSx86_64aarch64
扩展名pg_saviorel818171615141817161514
扩展包pg_saviorel918171615141817161514
RPMpg_savior_$vel1018171615141817161514
DEBpostgresql-$v-pg-saviord1218171615141817161514
语言Cd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议Apache-2.0u2418171615141817161514

safeupdate

safeupdate - 1.5 : 强制在 UPDATE 和 DELETE 时提供 Where 条件

条目属性OSx86_64aarch64
扩展名safeupdateel818171615141817161514
扩展包safeupdateel918171615141817161514
RPMsafeupdate_$vel1018171615141817161514
DEBpostgresql-$v-pg-safeupdated1218171615141817161514
语言Cd1318171615141817161514
仓库PGDGu2218171615141817161514
协议ISCu2418171615141817161514

pg_strict

pg_strict - 1.0.2 : 防止不带WHERE条件的危险UPDATE和DELETE操作

条目属性OSx86_64aarch64
扩展名pg_strictel818171615141817161514
扩展包pg_strictel918171615141817161514
RPMpg_strict_$vel1018171615141817161514
DEBpg_strict_$vd12--
语言Rustd13--
仓库PIGSTYu22--
协议MITu24--

pg_drop_events

pg_drop_events - 0.1.0 : 记录删表删列删视图的事务号,辅助PITR确定时间点

条目属性OSx86_64aarch64
扩展名pg_drop_eventsel818171615141817161514
扩展包pg_drop_eventsel918171615141817161514
RPMpg_drop_events_$vel1018171615141817161514
DEBpostgresql-$v-pg-drop-eventsd1218171615141817161514
语言SQLd1318171615141817161514
仓库MIXEDu2218171615141817161514
协议PostgreSQLu2418171615141817161514

table_log

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

条目属性OSx86_64aarch64
扩展名table_logel818171615141817161514
扩展包table_logel918171615141817161514
RPMtable_log_$vel1018171615141817161514
DEBpostgresql-$v-tablelogd1218171615141817161514
语言Cd1318171615141817161514
仓库MIXEDu2218171615141817161514
协议PostgreSQLu2418171615141817161514

pgagent

pgagent - 4.2.3 : PostgreSQL任务调度工具,与PGADMIN配合使用

条目属性OSx86_64aarch64
扩展名pgagentel818171615141817161514
扩展包pgagentel918171615141817161514
RPMpgagent_$vel1018171615141817161514
DEBpgagentd12--
语言Cd13--
仓库PGDGu22--
协议PostgreSQLu24--

pg_prewarm

pg_prewarm - 1.2 : 预热关系数据

条目属性OSx86_64aarch64
扩展名pg_prewarmel818171615141817161514
扩展包pg_prewarmel918171615141817161514
RPMpostgresql$v-contribel1018171615141817161514
DEBpostgresql-$vd1218171615141817161514
语言Cd1318171615141817161514
仓库CONTRIBu2218171615141817161514
协议PostgreSQLu2418171615141817161514

pgpool_adm

pgpool - 4.7.1 : PGPool 管理函数

条目属性OSx86_64aarch64
扩展名pgpool_admel818171615141817161514
扩展包pgpoolel918171615141817161514
RPMpgpool-II-pg$v-extensionsel1018171615141817161514
DEBpostgresql-$v-pgpool2d1218171615141817161514
语言Cd1318171615141817161514
仓库PGDGu2218171615141817161514
协议PostgreSQLu2418171615141817161514

pgpool_recovery

pgpool - 4.7.1 : PGPool辅助扩展,从v4.3提供的恢复函数

条目属性OSx86_64aarch64
扩展名pgpool_recoveryel818171615141817161514
扩展包pgpoolel918171615141817161514
RPMpgpool-II-pg$v-extensionsel1018171615141817161514
DEBpostgresql-$v-pgpool2d1218171615141817161514
语言Cd1318171615141817161514
仓库PGDGu2218171615141817161514
协议PostgreSQLu2418171615141817161514

pgpool_regclass

pgpool - 4.7.1 : PGPool辅助扩展,RegClass替代

条目属性OSx86_64aarch64
扩展名pgpool_regclassel818171615141817161514
扩展包pgpoolel918171615141817161514
RPMpgpool-II-pg$v-extensionsel1018171615141817161514
DEBpostgresql-$v-pgpool2d1218171615141817161514
语言Cd1318171615141817161514
仓库PGDGu2218171615141817161514
协议PostgreSQLu2418171615141817161514

lo

lo - 1.1 : 大对象维护

条目属性OSx86_64aarch64
扩展名loel818171615141817161514
扩展包loel918171615141817161514
RPMpostgresql$v-contribel1018171615141817161514
DEBpostgresql-$vd1218171615141817161514
语言Cd1318171615141817161514
仓库CONTRIBu2218171615141817161514
协议PostgreSQLu2418171615141817161514

basic_archive

basic_archive - - : 归档模块样例

条目属性OSx86_64aarch64
扩展名basic_archiveel818171615141817161514
扩展包basic_archiveel918171615141817161514
RPMpostgresql$v-contribel1018171615141817161514
DEBpostgresql-$vd1218171615141817161514
语言Cd1318171615141817161514
仓库CONTRIBu2218171615141817161514
协议PostgreSQLu2418171615141817161514

basebackup_to_shell

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

条目属性OSx86_64aarch64
扩展名basebackup_to_shellel818171615141817161514
扩展包basebackup_to_shellel918171615141817161514
RPMpostgresql$v-contribel1018171615141817161514
DEBpostgresql-$vd1218171615141817161514
语言Cd1318171615141817161514
仓库CONTRIBu2218171615141817161514
协议PostgreSQLu2418171615141817161514

old_snapshot

old_snapshot - 1.0 : 支持 old_snapshot_threshold 的实用程序

条目属性OSx86_64aarch64
扩展名old_snapshotel818171615141817161514
扩展包old_snapshotel918171615141817161514
RPMpostgresql$v-contribel1018171615141817161514
DEBpostgresql-$vd1218171615141817161514
语言Cd1318171615141817161514
仓库CONTRIBu2218171615141817161514
协议PostgreSQLu2418171615141817161514

adminpack

adminpack - 2.1 : PostgreSQL 管理函数集合

条目属性OSx86_64aarch64
扩展名adminpackel818171615141817161514
扩展包adminpackel918171615141817161514
RPMpostgresql$v-contribel1018171615141817161514
DEBpostgresql-$vd1218171615141817161514
语言Cd1318171615141817161514
仓库CONTRIBu2218171615141817161514
协议PostgreSQLu2418171615141817161514

amcheck

amcheck - 1.4 : 校验关系完整性

条目属性OSx86_64aarch64
扩展名amcheckel818171615141817161514
扩展包amcheckel918171615141817161514
RPMpostgresql$v-contribel1018171615141817161514
DEBpostgresql-$vd1218171615141817161514
语言Cd1318171615141817161514
仓库CONTRIBu2218171615141817161514
协议PostgreSQLu2418171615141817161514

pg_surgery

pg_surgery - 1.0 : 对损坏的关系进行手术

条目属性OSx86_64aarch64
扩展名pg_surgeryel818171615141817161514
扩展包pg_surgeryel918171615141817161514
RPMpostgresql$v-contribel1018171615141817161514
DEBpostgresql-$vd1218171615141817161514
语言Cd1318171615141817161514
仓库CONTRIBu2218171615141817161514
协议PostgreSQLu2418171615141817161514

最后修改 2026-03-08: add extension catalog (baacba6)