ETL - 数据集成

数据复制扩展：逻辑复制，逻辑解码，DDL复制，JSON/BSON/Protobuf 变更抽取，数据迁移，数据导入，数据比对等

扩展列表

共有 19 个扩展，位于 18 个扩展包中。

扩展包版本许可证语言描述
pglogicalpglogical2.4.6PostgreSQLCPostgreSQL逻辑复制：三方扩展实现
pglogical_originpglogical2.4.6PostgreSQLC用于从 Postgres 9.4 升级时的兼容性虚拟扩展
pglogical_tickerpglogical_ticker1.4.1PostgreSQLCpglogical复制延迟以秒计的精确视图
pgl_ddl_deploypgl_ddl_deploy2.2.1MITC使用 pglogical 执行自动 DDL 部署
pg_failover_slotspg_failover_slots1.2.0PostgreSQLC在Failover过程中保留复制槽
db_migratordb_migrator1.0.0BSD 3-ClauseSQL使用FDW从其他DBMS迁移到PostgreSQL
pgactivepgactive2.1.7Apache-2.0CPostgreSQL多主逻辑复制
spockspock5.0.5PostgreSQLCPostgreSQL 多主逻辑复制扩展
lolorlolor1.2.2PostgreSQLC让 PostgreSQL 大对象兼容逻辑复制的扩展
wal2jsonwal2json2.6BSD 3-ClauseC用逻辑解码捕获 JSON 格式的 CDC 变更
wal2mongowal2mongo1.0.7Apache-2.0C使用逻辑解码捕获MongoDB JSON格式的CDC变更
decoderbufsdecoderbufs3.4.1MITC将WAL逻辑解码为ProtocolBuffer协议的消息
decoder_rawdecoder_raw1.0PostgreSQLC逻辑复制解码输出插件：RAW SQL格式
mimeomimeo1.5.1PostgreSQLSQL在PostgreSQL实例间进行表级复制
repmgrrepmgr5.5.0GPL-3.0CPostgreSQL复制管理组件
pg_fact_loaderpg_fact_loader2.0.1MITC在 Postgres 中构建事实表
pg_bulkloadpg_bulkload3.1.23BSD 3-ClauseC向 PostgreSQL 中高速加载数据
test_decodingtest_decoding-PostgreSQLC基于SQL的WAL逻辑解码样例
pgoutputpgoutput-PostgreSQLCPG内置的逻辑解码输出插件

pglogical

pglogical - 2.4.6 : PostgreSQL逻辑复制：三方扩展实现

条目属性OSx86_64aarch64
扩展名pglogicalel818171615141817161514
扩展包pglogicalel918171615141817161514
RPMpglogical_$vel1018171615141817161514
DEBpostgresql-$v-pglogicald1218171615141817161514
语言Cd1318171615141817161514
仓库PGDGu2218171615141817161514
协议PostgreSQLu2418171615141817161514

pglogical_origin

pglogical - 2.4.6 : 用于从 Postgres 9.4 升级时的兼容性虚拟扩展

条目属性OSx86_64aarch64
扩展名pglogical_originel818171615141817161514
扩展包pglogicalel918171615141817161514
RPMpglogical_$vel1018171615141817161514
DEBpostgresql-$v-pglogicald1218171615141817161514
语言Cd1318171615141817161514
仓库PGDGu2218171615141817161514
协议PostgreSQLu2418171615141817161514

pglogical_ticker

pglogical_ticker - 1.4.1 : pglogical复制延迟以秒计的精确视图

条目属性OSx86_64aarch64
扩展名pglogical_tickerel818171615141817161514
扩展包pglogical_tickerel918171615141817161514
RPMpglogical_ticker_$vel1018171615141817161514
DEBpostgresql-$v-pglogical-tickerd1218171615141817161514
语言Cd1318171615141817161514
仓库PGDGu2218171615141817161514
协议PostgreSQLu2418171615141817161514

pgl_ddl_deploy

pgl_ddl_deploy - 2.2.1 : 使用 pglogical 执行自动 DDL 部署

条目属性OSx86_64aarch64
扩展名pgl_ddl_deployel818171615141817161514
扩展包pgl_ddl_deployel918171615141817161514
RPMpgl_ddl_deploy_$vel1018171615141817161514
DEBpostgresql-$v-pgl-ddl-deployd1218171615141817161514
语言Cd1318171615141817161514
仓库PGDGu2218171615141817161514
协议MITu2418171615141817161514

pg_failover_slots

pg_failover_slots - 1.2.0 : 在Failover过程中保留复制槽

条目属性OSx86_64aarch64
扩展名pg_failover_slotsel818171615141817161514
扩展包pg_failover_slotsel918171615141817161514
RPMpg_failover_slots_$vel1018171615141817161514
DEBpostgresql-$v-pg-failover-slotsd1218171615141817161514
语言Cd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议PostgreSQLu2418171615141817161514

db_migrator

db_migrator - 1.0.0 : 使用FDW从其他DBMS迁移到PostgreSQL

条目属性OSx86_64aarch64
扩展名db_migratorel818171615141817161514
扩展包db_migratorel918171615141817161514
RPMdb_migrator_$vel1018171615141817161514
DEBpostgresql-$v-db-migratord1218171615141817161514
语言SQLd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议BSD 3-Clauseu2418171615141817161514

pgactive

pgactive - 2.1.7 : PostgreSQL多主逻辑复制

条目属性OSx86_64aarch64
扩展名pgactiveel818171615141817161514
扩展包pgactiveel918171615141817161514
RPMpgactive_$vel1018171615141817161514
DEBpostgresql-$v-pgactived1218171615141817161514
语言Cd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议Apache-2.0u2418171615141817161514

spock

spock - 5.0.5 : PostgreSQL 多主逻辑复制扩展

条目属性OSx86_64aarch64
扩展名spockel818171615141817161514
扩展包spockel918171615141817161514
RPMspock_$vel1018171615141817161514
DEBpgedge-$v-spockd1218171615141817161514
语言Cd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议PostgreSQLu2418171615141817161514

lolor

lolor - 1.2.2 : 让 PostgreSQL 大对象兼容逻辑复制的扩展

条目属性OSx86_64aarch64
扩展名lolorel818171615141817161514
扩展包lolorel918171615141817161514
RPMlolor_$vel1018171615141817161514
DEBpgedge-$v-lolord1218171615141817161514
语言Cd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议PostgreSQLu2418171615141817161514

wal2json

wal2json - 2.6 : 用逻辑解码捕获 JSON 格式的 CDC 变更

条目属性OSx86_64aarch64
扩展名wal2jsonel818171615141817161514
扩展包wal2jsonel918171615141817161514
RPMwal2json_$vel1018171615141817161514
DEBpostgresql-$v-wal2jsond1218171615141817161514
语言Cd1318171615141817161514
仓库PGDGu2218171615141817161514
协议BSD 3-Clauseu2418171615141817161514

wal2mongo

wal2mongo - 1.0.7 : 使用逻辑解码捕获MongoDB JSON格式的CDC变更

条目属性OSx86_64aarch64
扩展名wal2mongoel818171615141817161514
扩展包wal2mongoel918171615141817161514
RPMwal2mongo_$vel1018171615141817161514
DEBpostgresql-$v-wal2mongod1218171615141817161514
语言Cd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议Apache-2.0u2418171615141817161514

decoderbufs

decoderbufs - 3.4.1 : 将WAL逻辑解码为ProtocolBuffer协议的消息

条目属性OSx86_64aarch64
扩展名decoderbufsel818171615141817161514
扩展包decoderbufsel918171615141817161514
RPMpostgres-decoderbufs_$vel1018171615141817161514
DEBpostgresql-$v-decoderbufsd1218171615141817161514
语言Cd1318171615141817161514
仓库PGDGu2218171615141817161514
协议MITu2418171615141817161514

decoder_raw

decoder_raw - 1.0 : 逻辑复制解码输出插件：RAW SQL格式

条目属性OSx86_64aarch64
扩展名decoder_rawel818171615141817161514
扩展包decoder_rawel918171615141817161514
RPMdecoder_raw_$vel1018171615141817161514
DEBpostgresql-$v-decoder-rawd1218171615141817161514
语言Cd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议PostgreSQLu2418171615141817161514

mimeo

mimeo - 1.5.1 : 在PostgreSQL实例间进行表级复制

条目属性OSx86_64aarch64
扩展名mimeoel818171615141817161514
扩展包mimeoel918171615141817161514
RPMmimeo_$vel1018171615141817161514
DEBpostgresql-$v-mimeod1218171615141817161514
语言SQLd1318171615141817161514
仓库MIXEDu2218171615141817161514
协议PostgreSQLu2418171615141817161514

repmgr

repmgr - 5.5.0 : PostgreSQL复制管理组件

条目属性OSx86_64aarch64
扩展名repmgrel818171615141817161514
扩展包repmgrel918171615141817161514
RPMrepmgr_$vel1018171615141817161514
DEBpostgresql-$v-repmgrd1218171615141817161514
语言Cd1318171615141817161514
仓库PGDGu2218171615141817161514
协议GPL-3.0u2418171615141817161514

pg_fact_loader

pg_fact_loader - 2.0.1 : 在 Postgres 中构建事实表

条目属性OSx86_64aarch64
扩展名pg_fact_loaderel818171615141817161514
扩展包pg_fact_loaderel918171615141817161514
RPMpg_fact_loader_$vel1018171615141817161514
DEBpostgresql-$v-pg-fact-loaderd1218171615141817161514
语言Cd1318171615141817161514
仓库PGDGu2218171615141817161514
协议MITu2418171615141817161514

pg_bulkload

pg_bulkload - 3.1.23 : 向 PostgreSQL 中高速加载数据

条目属性OSx86_64aarch64
扩展名pg_bulkloadel818171615141817161514
扩展包pg_bulkloadel918171615141817161514
RPMpg_bulkload_$vel1018171615141817161514
DEBpostgresql-$v-pg-bulkloadd1218171615141817161514
语言Cd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议BSD 3-Clauseu2418171615141817161514

test_decoding

test_decoding - - : 基于SQL的WAL逻辑解码样例

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

pgoutput

pgoutput - - : PG内置的逻辑解码输出插件

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

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