pgactive

PostgreSQL多主逻辑复制

概览

扩展包名	版本	分类	许可证	语言
`pgactive`	`2.1.7`	ETL	Apache-2.0	C

ID	扩展名	Bin	Lib	Load	Create	Trust	Reloc	模式
9560	`pgactive`	是	是	是	是	否	否	`pg_catalog`

相关扩展	`pglogical` `spock` `mimeo` `pgoutput` `postgres_fdw` `repmgr` `pg_failover_slots` `citus` `pgautofailover` `bgw_replstatus`

require libpgfeutils

版本

类型	仓库	版本	PG 大版本	包名	依赖
EXT	PIGSTY	`2.1.7`	1817161514	`pgactive`	-
RPM	PIGSTY	`2.1.7`	1817161514	`pgactive_$v`	-
DEB	PIGSTY	`2.1.7`	1817161514	`postgresql-$v-pgactive`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PIGSTY 2.1.7 el8.x86_64.pg18 : pgactive_18 pgactive_18-2.1.7-1PIGSTY.el8.x86_64.rpm PIGSTY · 2.1.7 · 376.1KiB	PIGSTY 2.1.7 el8.x86_64.pg17 : pgactive_17 pgactive_17-2.1.7-1PIGSTY.el8.x86_64.rpm PIGSTY · 2.1.7 · 367.9KiB	PIGSTY 2.1.7 el8.x86_64.pg16 : pgactive_16 pgactive_16-2.1.7-1PIGSTY.el8.x86_64.rpm PIGSTY · 2.1.7 · 361.5KiB	PIGSTY 2.1.7 el8.x86_64.pg15 : pgactive_15 pgactive_15-2.1.7-1PIGSTY.el8.x86_64.rpm PIGSTY · 2.1.7 · 353.2KiB	PIGSTY 2.1.7 el8.x86_64.pg14 : pgactive_14 pgactive_14-2.1.7-1PIGSTY.el8.x86_64.rpm PIGSTY · 2.1.7 · 352.8KiB
el8.aarch64	PIGSTY 2.1.7 el8.aarch64.pg18 : pgactive_18 pgactive_18-2.1.7-1PIGSTY.el8.aarch64.rpm PIGSTY · 2.1.7 · 360.5KiB	PIGSTY 2.1.7 el8.aarch64.pg17 : pgactive_17 pgactive_17-2.1.7-1PIGSTY.el8.aarch64.rpm PIGSTY · 2.1.7 · 352.8KiB	PIGSTY 2.1.7 el8.aarch64.pg16 : pgactive_16 pgactive_16-2.1.7-1PIGSTY.el8.aarch64.rpm PIGSTY · 2.1.7 · 346.2KiB	PIGSTY 2.1.7 el8.aarch64.pg15 : pgactive_15 pgactive_15-2.1.7-1PIGSTY.el8.aarch64.rpm PIGSTY · 2.1.7 · 338.5KiB	PIGSTY 2.1.7 el8.aarch64.pg14 : pgactive_14 pgactive_14-2.1.7-1PIGSTY.el8.aarch64.rpm PIGSTY · 2.1.7 · 339.0KiB
el9.x86_64	PIGSTY 2.1.7 el9.x86_64.pg18 : pgactive_18 pgactive_18-2.1.7-1PIGSTY.el9.x86_64.rpm PIGSTY · 2.1.7 · 346.6KiB	PIGSTY 2.1.7 el9.x86_64.pg17 : pgactive_17 pgactive_17-2.1.7-1PIGSTY.el9.x86_64.rpm PIGSTY · 2.1.7 · 339.2KiB	PIGSTY 2.1.7 el9.x86_64.pg16 : pgactive_16 pgactive_16-2.1.7-1PIGSTY.el9.x86_64.rpm PIGSTY · 2.1.7 · 333.9KiB	PIGSTY 2.1.7 el9.x86_64.pg15 : pgactive_15 pgactive_15-2.1.7-1PIGSTY.el9.x86_64.rpm PIGSTY · 2.1.7 · 330.2KiB	PIGSTY 2.1.7 el9.x86_64.pg14 : pgactive_14 pgactive_14-2.1.7-1PIGSTY.el9.x86_64.rpm PIGSTY · 2.1.7 · 332.9KiB
el9.aarch64	PIGSTY 2.1.7 el9.aarch64.pg18 : pgactive_18 pgactive_18-2.1.7-1PIGSTY.el9.aarch64.rpm PIGSTY · 2.1.7 · 338.0KiB	PIGSTY 2.1.7 el9.aarch64.pg17 : pgactive_17 pgactive_17-2.1.7-1PIGSTY.el9.aarch64.rpm PIGSTY · 2.1.7 · 330.8KiB	PIGSTY 2.1.7 el9.aarch64.pg16 : pgactive_16 pgactive_16-2.1.7-1PIGSTY.el9.aarch64.rpm PIGSTY · 2.1.7 · 325.5KiB	PIGSTY 2.1.7 el9.aarch64.pg15 : pgactive_15 pgactive_15-2.1.7-1PIGSTY.el9.aarch64.rpm PIGSTY · 2.1.7 · 322.7KiB	PIGSTY 2.1.7 el9.aarch64.pg14 : pgactive_14 pgactive_14-2.1.7-1PIGSTY.el9.aarch64.rpm PIGSTY · 2.1.7 · 325.3KiB
el10.x86_64	PIGSTY 2.1.7 el10.x86_64.pg18 : pgactive_18 pgactive_18-2.1.7-1PIGSTY.el10.x86_64.rpm PIGSTY · 2.1.7 · 350.7KiB	PIGSTY 2.1.7 el10.x86_64.pg17 : pgactive_17 pgactive_17-2.1.7-1PIGSTY.el10.x86_64.rpm PIGSTY · 2.1.7 · 343.0KiB	PIGSTY 2.1.7 el10.x86_64.pg16 : pgactive_16 pgactive_16-2.1.7-1PIGSTY.el10.x86_64.rpm PIGSTY · 2.1.7 · 338.2KiB	PIGSTY 2.1.7 el10.x86_64.pg15 : pgactive_15 pgactive_15-2.1.7-1PIGSTY.el10.x86_64.rpm PIGSTY · 2.1.7 · 333.6KiB	PIGSTY 2.1.7 el10.x86_64.pg14 : pgactive_14 pgactive_14-2.1.7-1PIGSTY.el10.x86_64.rpm PIGSTY · 2.1.7 · 338.2KiB
el10.aarch64	PIGSTY 2.1.7 el10.aarch64.pg18 : pgactive_18 pgactive_18-2.1.7-1PIGSTY.el10.aarch64.rpm PIGSTY · 2.1.7 · 343.5KiB	PIGSTY 2.1.7 el10.aarch64.pg17 : pgactive_17 pgactive_17-2.1.7-1PIGSTY.el10.aarch64.rpm PIGSTY · 2.1.7 · 335.9KiB	PIGSTY 2.1.7 el10.aarch64.pg16 : pgactive_16 pgactive_16-2.1.7-1PIGSTY.el10.aarch64.rpm PIGSTY · 2.1.7 · 329.6KiB	PIGSTY 2.1.7 el10.aarch64.pg15 : pgactive_15 pgactive_15-2.1.7-1PIGSTY.el10.aarch64.rpm PIGSTY · 2.1.7 · 327.7KiB	PIGSTY 2.1.7 el10.aarch64.pg14 : pgactive_14 pgactive_14-2.1.7-1PIGSTY.el10.aarch64.rpm PIGSTY · 2.1.7 · 329.0KiB
d12.x86_64	PIGSTY 2.1.7 d12.x86_64.pg18 : postgresql-18-pgactive postgresql-18-pgactive_2.1.7-1PIGSTY~bookworm_amd64.deb PIGSTY · 2.1.7 · 593.1KiB	PIGSTY 2.1.7 d12.x86_64.pg17 : postgresql-17-pgactive postgresql-17-pgactive_2.1.7-1PIGSTY~bookworm_amd64.deb PIGSTY · 2.1.7 · 586.2KiB	PIGSTY 2.1.7 d12.x86_64.pg16 : postgresql-16-pgactive postgresql-16-pgactive_2.1.7-1PIGSTY~bookworm_amd64.deb PIGSTY · 2.1.7 · 581.1KiB	PIGSTY 2.1.7 d12.x86_64.pg15 : postgresql-15-pgactive postgresql-15-pgactive_2.1.7-1PIGSTY~bookworm_amd64.deb PIGSTY · 2.1.7 · 577.9KiB	PIGSTY 2.1.7 d12.x86_64.pg14 : postgresql-14-pgactive postgresql-14-pgactive_2.1.7-1PIGSTY~bookworm_amd64.deb PIGSTY · 2.1.7 · 581.0KiB
d12.aarch64	PIGSTY 2.1.7 d12.aarch64.pg18 : postgresql-18-pgactive postgresql-18-pgactive_2.1.7-1PIGSTY~bookworm_arm64.deb PIGSTY · 2.1.7 · 567.2KiB	PIGSTY 2.1.7 d12.aarch64.pg17 : postgresql-17-pgactive postgresql-17-pgactive_2.1.7-1PIGSTY~bookworm_arm64.deb PIGSTY · 2.1.7 · 561.1KiB	PIGSTY 2.1.7 d12.aarch64.pg16 : postgresql-16-pgactive postgresql-16-pgactive_2.1.7-1PIGSTY~bookworm_arm64.deb PIGSTY · 2.1.7 · 557.0KiB	PIGSTY 2.1.7 d12.aarch64.pg15 : postgresql-15-pgactive postgresql-15-pgactive_2.1.7-1PIGSTY~bookworm_arm64.deb PIGSTY · 2.1.7 · 551.2KiB	PIGSTY 2.1.7 d12.aarch64.pg14 : postgresql-14-pgactive postgresql-14-pgactive_2.1.7-1PIGSTY~bookworm_arm64.deb PIGSTY · 2.1.7 · 554.4KiB
d13.x86_64	PIGSTY 2.1.7 d13.x86_64.pg18 : postgresql-18-pgactive postgresql-18-pgactive_2.1.7-1PIGSTY~trixie_amd64.deb PIGSTY · 2.1.7 · 594.5KiB	PIGSTY 2.1.7 d13.x86_64.pg17 : postgresql-17-pgactive postgresql-17-pgactive_2.1.7-1PIGSTY~trixie_amd64.deb PIGSTY · 2.1.7 · 588.4KiB	PIGSTY 2.1.7 d13.x86_64.pg16 : postgresql-16-pgactive postgresql-16-pgactive_2.1.7-1PIGSTY~trixie_amd64.deb PIGSTY · 2.1.7 · 583.6KiB	PIGSTY 2.1.7 d13.x86_64.pg15 : postgresql-15-pgactive postgresql-15-pgactive_2.1.7-1PIGSTY~trixie_amd64.deb PIGSTY · 2.1.7 · 580.0KiB	PIGSTY 2.1.7 d13.x86_64.pg14 : postgresql-14-pgactive postgresql-14-pgactive_2.1.7-1PIGSTY~trixie_amd64.deb PIGSTY · 2.1.7 · 582.4KiB
d13.aarch64	PIGSTY 2.1.7 d13.aarch64.pg18 : postgresql-18-pgactive postgresql-18-pgactive_2.1.7-1PIGSTY~trixie_arm64.deb PIGSTY · 2.1.7 · 570.9KiB	PIGSTY 2.1.7 d13.aarch64.pg17 : postgresql-17-pgactive postgresql-17-pgactive_2.1.7-1PIGSTY~trixie_arm64.deb PIGSTY · 2.1.7 · 564.0KiB	PIGSTY 2.1.7 d13.aarch64.pg16 : postgresql-16-pgactive postgresql-16-pgactive_2.1.7-1PIGSTY~trixie_arm64.deb PIGSTY · 2.1.7 · 559.6KiB	PIGSTY 2.1.7 d13.aarch64.pg15 : postgresql-15-pgactive postgresql-15-pgactive_2.1.7-1PIGSTY~trixie_arm64.deb PIGSTY · 2.1.7 · 555.8KiB	PIGSTY 2.1.7 d13.aarch64.pg14 : postgresql-14-pgactive postgresql-14-pgactive_2.1.7-1PIGSTY~trixie_arm64.deb PIGSTY · 2.1.7 · 555.1KiB
u22.x86_64	PIGSTY 2.1.7 u22.x86_64.pg18 : postgresql-18-pgactive postgresql-18-pgactive_2.1.7-1PIGSTY~jammy_amd64.deb PIGSTY · 2.1.7 · 644.8KiB	PIGSTY 2.1.7 u22.x86_64.pg17 : postgresql-17-pgactive postgresql-17-pgactive_2.1.7-1PIGSTY~jammy_amd64.deb PIGSTY · 2.1.7 · 711.7KiB	PIGSTY 2.1.7 u22.x86_64.pg16 : postgresql-16-pgactive postgresql-16-pgactive_2.1.7-1PIGSTY~jammy_amd64.deb PIGSTY · 2.1.7 · 701.0KiB	PIGSTY 2.1.7 u22.x86_64.pg15 : postgresql-15-pgactive postgresql-15-pgactive_2.1.7-1PIGSTY~jammy_amd64.deb PIGSTY · 2.1.7 · 698.4KiB	PIGSTY 2.1.7 u22.x86_64.pg14 : postgresql-14-pgactive postgresql-14-pgactive_2.1.7-1PIGSTY~jammy_amd64.deb PIGSTY · 2.1.7 · 701.5KiB
u22.aarch64	PIGSTY 2.1.7 u22.aarch64.pg18 : postgresql-18-pgactive postgresql-18-pgactive_2.1.7-1PIGSTY~jammy_arm64.deb PIGSTY · 2.1.7 · 634.6KiB	PIGSTY 2.1.7 u22.aarch64.pg17 : postgresql-17-pgactive postgresql-17-pgactive_2.1.7-1PIGSTY~jammy_arm64.deb PIGSTY · 2.1.7 · 702.8KiB	PIGSTY 2.1.7 u22.aarch64.pg16 : postgresql-16-pgactive postgresql-16-pgactive_2.1.7-1PIGSTY~jammy_arm64.deb PIGSTY · 2.1.7 · 692.5KiB	PIGSTY 2.1.7 u22.aarch64.pg15 : postgresql-15-pgactive postgresql-15-pgactive_2.1.7-1PIGSTY~jammy_arm64.deb PIGSTY · 2.1.7 · 690.7KiB	PIGSTY 2.1.7 u22.aarch64.pg14 : postgresql-14-pgactive postgresql-14-pgactive_2.1.7-1PIGSTY~jammy_arm64.deb PIGSTY · 2.1.7 · 693.0KiB
u24.x86_64	PIGSTY 2.1.7 u24.x86_64.pg18 : postgresql-18-pgactive postgresql-18-pgactive_2.1.7-1PIGSTY~noble_amd64.deb PIGSTY · 2.1.7 · 625.7KiB	PIGSTY 2.1.7 u24.x86_64.pg17 : postgresql-17-pgactive postgresql-17-pgactive_2.1.7-1PIGSTY~noble_amd64.deb PIGSTY · 2.1.7 · 618.9KiB	PIGSTY 2.1.7 u24.x86_64.pg16 : postgresql-16-pgactive postgresql-16-pgactive_2.1.7-1PIGSTY~noble_amd64.deb PIGSTY · 2.1.7 · 613.5KiB	PIGSTY 2.1.7 u24.x86_64.pg15 : postgresql-15-pgactive postgresql-15-pgactive_2.1.7-1PIGSTY~noble_amd64.deb PIGSTY · 2.1.7 · 610.4KiB	PIGSTY 2.1.7 u24.x86_64.pg14 : postgresql-14-pgactive postgresql-14-pgactive_2.1.7-1PIGSTY~noble_amd64.deb PIGSTY · 2.1.7 · 613.5KiB
u24.aarch64	PIGSTY 2.1.7 u24.aarch64.pg18 : postgresql-18-pgactive postgresql-18-pgactive_2.1.7-1PIGSTY~noble_arm64.deb PIGSTY · 2.1.7 · 619.6KiB	PIGSTY 2.1.7 u24.aarch64.pg17 : postgresql-17-pgactive postgresql-17-pgactive_2.1.7-1PIGSTY~noble_arm64.deb PIGSTY · 2.1.7 · 613.0KiB	PIGSTY 2.1.7 u24.aarch64.pg16 : postgresql-16-pgactive postgresql-16-pgactive_2.1.7-1PIGSTY~noble_arm64.deb PIGSTY · 2.1.7 · 607.7KiB	PIGSTY 2.1.7 u24.aarch64.pg15 : postgresql-15-pgactive postgresql-15-pgactive_2.1.7-1PIGSTY~noble_arm64.deb PIGSTY · 2.1.7 · 606.0KiB	PIGSTY 2.1.7 u24.aarch64.pg14 : postgresql-14-pgactive postgresql-14-pgactive_2.1.7-1PIGSTY~noble_arm64.deb PIGSTY · 2.1.7 · 607.2KiB
u26.x86_64	PIGSTY 2.1.7 u26.x86_64.pg18 : postgresql-18-pgactive postgresql-18-pgactive_2.1.7-1PIGSTY~resolute_amd64.deb PIGSTY · 2.1.7 · 622.5KiB	PIGSTY 2.1.7 u26.x86_64.pg17 : postgresql-17-pgactive postgresql-17-pgactive_2.1.7-1PIGSTY~resolute_amd64.deb PIGSTY · 2.1.7 · 615.0KiB	PIGSTY 2.1.7 u26.x86_64.pg16 : postgresql-16-pgactive postgresql-16-pgactive_2.1.7-1PIGSTY~resolute_amd64.deb PIGSTY · 2.1.7 · 610.5KiB	PIGSTY 2.1.7 u26.x86_64.pg15 : postgresql-15-pgactive postgresql-15-pgactive_2.1.7-1PIGSTY~resolute_amd64.deb PIGSTY · 2.1.7 · 607.7KiB	PIGSTY 2.1.7 u26.x86_64.pg14 : postgresql-14-pgactive postgresql-14-pgactive_2.1.7-1PIGSTY~resolute_amd64.deb PIGSTY · 2.1.7 · 609.4KiB
u26.aarch64	PIGSTY 2.1.7 u26.aarch64.pg18 : postgresql-18-pgactive postgresql-18-pgactive_2.1.7-1PIGSTY~resolute_arm64.deb PIGSTY · 2.1.7 · 614.0KiB	PIGSTY 2.1.7 u26.aarch64.pg17 : postgresql-17-pgactive postgresql-17-pgactive_2.1.7-1PIGSTY~resolute_arm64.deb PIGSTY · 2.1.7 · 606.5KiB	PIGSTY 2.1.7 u26.aarch64.pg16 : postgresql-16-pgactive postgresql-16-pgactive_2.1.7-1PIGSTY~resolute_arm64.deb PIGSTY · 2.1.7 · 602.1KiB	PIGSTY 2.1.7 u26.aarch64.pg15 : postgresql-15-pgactive postgresql-15-pgactive_2.1.7-1PIGSTY~resolute_arm64.deb PIGSTY · 2.1.7 · 599.6KiB	PIGSTY 2.1.7 u26.aarch64.pg14 : postgresql-14-pgactive postgresql-14-pgactive_2.1.7-1PIGSTY~resolute_arm64.deb PIGSTY · 2.1.7 · 601.5KiB

构建

您可以使用 pig build 命令构建 pgactive 扩展的 RPM / DEB 包：

BASH

pig build pkg pgactive         # 构建 RPM / DEB 包

安装

您可以直接安装 pgactive 扩展包的预置二进制包，首先确保 PGDG 和 PIGSTY 仓库已经添加并启用：

BASH

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

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

安装

BASH

pig install pgactive;          # 当前活跃 PG 版本安装

pig

BASH

pig ext install -y pgactive -v 18  # PG 18
pig ext install -y pgactive -v 17  # PG 17
pig ext install -y pgactive -v 16  # PG 16
pig ext install -y pgactive -v 15  # PG 15
pig ext install -y pgactive -v 14  # PG 14

dnf

BASH

dnf install -y pgactive_18       # PG 18
dnf install -y pgactive_17       # PG 17
dnf install -y pgactive_16       # PG 16
dnf install -y pgactive_15       # PG 15
dnf install -y pgactive_14       # PG 14

apt

BASH

apt install -y postgresql-18-pgactive   # PG 18
apt install -y postgresql-17-pgactive   # PG 17
apt install -y postgresql-16-pgactive   # PG 16
apt install -y postgresql-15-pgactive   # PG 15
apt install -y postgresql-14-pgactive   # PG 14

预加载配置：

BASH

shared_preload_libraries = 'pgactive';

创建扩展：

SQL

CREATE EXTENSION pgactive;

用法

pgactive: PostgreSQL 双活复制扩展

pgactive 扩展为 PostgreSQL 提供双活（多主）复制，多个数据库实例可以同时接受写入并相互复制变更。

启用

SQL

CREATE EXTENSION pgactive;

概述

pgactive 使用逻辑复制作为基础实现双活复制。集群中的多个数据库可以接受变更并双向复制。

关键概念

双活：所有节点同时接受读写
异步：变更在节点之间异步复制
冲突解决：应用程序必须处理来自多个写入者的冲突变更
逻辑复制：使用 PostgreSQL 的逻辑解码来解释和应用变更

使用场景

多区域高可用数据库集群
减少应用程序与数据库之间的写入延迟
蓝绿应用更新
必须保持双方可写的系统间数据迁移

设计注意事项

使用 pgactive 的应用程序必须能够处理：

写冲突：不同节点上对同一行的并发修改
复制延迟：变更可能不会立即在所有节点上可见
功能限制：某些功能如自增序列在跨节点时需要特殊处理

注意事项

基于 PostgreSQL 的原生逻辑复制基础设施构建
需要 PostgreSQL 10+（原生逻辑复制支持）
详细设置和冲突解决策略请参阅项目文档

意见反馈

这个页面对您有帮助吗？

感谢反馈！请告诉我们如何改进。

抱歉给您带来不便。请告诉我们如何改进。