pglogical_origin

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

概览

扩展包名版本分类许可证语言
pglogical2.4.6ETLPostgreSQLC
ID扩展名BinLibLoadCreateTrustReloc模式
9500pglogicalpglogical
9501pglogical_originpglogical_origin
相关扩展pglogical_ticker pgl_ddl_deploy pg_failover_slots pgactive wal2json decoderbufs repmgr decoder_raw

版本

类型仓库版本PG 大版本包名依赖
EXTPGDG2.4.61817161514pglogical-
RPMPGDG2.4.61817161514pglogical_$v-
DEBPGDG2.4.61817161514postgresql-$v-pglogical-
OS / PGPG18PG17PG16PG15PG14
el8.x86_64PGDG 2.4.6PGDG 2.4.5PGDG 2.4.4PGDG 2.4.3PGDG 2.4.3
el8.aarch64PGDG 2.4.6PGDG 2.4.5PGDG 2.4.4PGDG 2.4.3PGDG 2.4.3
el9.x86_64PGDG 2.4.6PGDG 2.4.5PGDG 2.4.4PGDG 2.4.3PGDG 2.4.3
el9.aarch64PGDG 2.4.6PGDG 2.4.5PGDG 2.4.4PGDG 2.4.3PGDG 2.4.3
el10.x86_64PGDG 2.4.6PGDG 2.4.5PGDG 2.4.5PGDG 2.4.5PGDG 2.4.5
el10.aarch64PGDG 2.4.6PGDG 2.4.5PGDG 2.4.5PGDG 2.4.5PGDG 2.4.5
d12.x86_64PGDG 2.4.6PGDG 2.4.6PGDG 2.4.6PGDG 2.4.6PGDG 2.4.6
d12.aarch64PGDG 2.4.6PGDG 2.4.6PGDG 2.4.6PGDG 2.4.6PGDG 2.4.6
d13.x86_64PGDG 2.4.6PGDG 2.4.6PGDG 2.4.6PGDG 2.4.6PGDG 2.4.6
d13.aarch64PGDG 2.4.6PGDG 2.4.6PGDG 2.4.6PGDG 2.4.6PGDG 2.4.6
u22.x86_64PGDG 2.4.6PGDG 2.4.6PGDG 2.4.6PGDG 2.4.6PGDG 2.4.6
u22.aarch64PGDG 2.4.6PGDG 2.4.6PGDG 2.4.6PGDG 2.4.6PGDG 2.4.6
u24.x86_64PGDG 2.4.6PGDG 2.4.6PGDG 2.4.6PGDG 2.4.6PGDG 2.4.6
u24.aarch64PGDG 2.4.6PGDG 2.4.6PGDG 2.4.6PGDG 2.4.6PGDG 2.4.6

安装

您可以直接安装 pglogical 扩展包的预置二进制包,首先确保 PGDG 仓库已经添加并启用:

pig repo add pgdg -u          # 添加 PGDG 仓库并更新缓存

使用 pig 或者是 apt/yum/dnf 安装扩展:

pig install pglogical;          # 当前活跃 PG 版本安装
pig ext install -y pglogical -v 18  # PG 18
pig ext install -y pglogical -v 17  # PG 17
pig ext install -y pglogical -v 16  # PG 16
pig ext install -y pglogical -v 15  # PG 15
pig ext install -y pglogical -v 14  # PG 14
dnf install -y pglogical_18       # PG 18
dnf install -y pglogical_17       # PG 17
dnf install -y pglogical_16       # PG 16
dnf install -y pglogical_15       # PG 15
dnf install -y pglogical_14       # PG 14
apt install -y postgresql-18-pglogical   # PG 18
apt install -y postgresql-17-pglogical   # PG 17
apt install -y postgresql-16-pglogical   # PG 16
apt install -y postgresql-15-pglogical   # PG 15
apt install -y postgresql-14-pglogical   # PG 14

创建扩展

CREATE EXTENSION pglogical_origin;

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