pgactive

Active-Active Replication Extension for PostgreSQL

Overview

ID	Extension	Package	Version	Category	License	Language
9550	pgactive	pgactive	`2.1.7`	ETL	Apache-2.0	C

Attribute	Has Binary	Has Library	Need Load	Has DDL	Relocatable	Trusted
--sLd--	Yes	Yes	Yes	Yes	no	no

Relationships
See Also	pglogical pg_failover_slots repmgr bgw_replstatus pglogical_origin pglogical_ticker pgl_ddl_deploy decoderbufs

require libpgfeutils

Packages

Type	Repo	Version	PG Major Availability	Package Pattern	Dependencies
EL	PIGSTY	`2.1.7`	18 17 16 15 14 13	`pgactive_$v*`	-
Debian	PIGSTY	`2.1.7`	18 17 16 15 14 13	`postgresql-$v-pgactive`	-

Linux / PG	PG18	PG17	PG16	PG15	PG14	PG13
el8.x86_64	PIGSTY 2.1.7	PIGSTY 2.1.7	PIGSTY 2.1.7	PIGSTY 2.1.7	PIGSTY 2.1.7	PIGSTY 2.1.7
el8.aarch64	PIGSTY 2.1.7	PIGSTY 2.1.7	PIGSTY 2.1.7	PIGSTY 2.1.7	PIGSTY 2.1.7	PIGSTY 2.1.7
el9.x86_64	PIGSTY 2.1.7	PIGSTY 2.1.7	PIGSTY 2.1.7	PIGSTY 2.1.7	PIGSTY 2.1.7	PIGSTY 2.1.7
el9.aarch64	PIGSTY 2.1.7	PIGSTY 2.1.7	PIGSTY 2.1.7	PIGSTY 2.1.7	PIGSTY 2.1.7	PIGSTY 2.1.7
el10.x86_64	PIGSTY 2.1.7	PIGSTY 2.1.7	PIGSTY 2.1.7	PIGSTY 2.1.7	PIGSTY 2.1.7	PIGSTY 2.1.7
el10.aarch64	PIGSTY 2.1.7	PIGSTY 2.1.7	PIGSTY 2.1.7	PIGSTY 2.1.7	PIGSTY 2.1.7	PIGSTY 2.1.7
d12.x86_64	MISS	PIGSTY 2.1.6	PIGSTY 2.1.6	PIGSTY 2.1.6	PIGSTY 2.1.6	PIGSTY 2.1.6
d12.aarch64	MISS	PIGSTY 2.1.6	PIGSTY 2.1.6	PIGSTY 2.1.6	PIGSTY 2.1.6	PIGSTY 2.1.6
d13.x86_64	MISS	MISS	MISS	MISS	MISS	MISS
d13.aarch64	MISS	MISS	MISS	MISS	MISS	MISS
u22.x86_64	MISS	PIGSTY 2.1.6	PIGSTY 2.1.6	PIGSTY 2.1.6	PIGSTY 2.1.6	PIGSTY 2.1.6
u22.aarch64	MISS	PIGSTY 2.1.6	PIGSTY 2.1.6	PIGSTY 2.1.6	PIGSTY 2.1.6	PIGSTY 2.1.6
u24.x86_64	MISS	PIGSTY 2.1.6	PIGSTY 2.1.6	PIGSTY 2.1.6	PIGSTY 2.1.6	PIGSTY 2.1.6
u24.aarch64	MISS	PIGSTY 2.1.6	PIGSTY 2.1.6	PIGSTY 2.1.6	PIGSTY 2.1.6	PIGSTY 2.1.6

Package	Version	OS	ORG	SIZE	File URL
`pgactive_18`	2.1.7	`el8.x86_64`	pigsty	376.1 KiB	pgactive_18-2.1.7-1PIGSTY.el8.x86_64.rpm
`pgactive_18`	2.1.7	`el8.aarch64`	pigsty	360.5 KiB	pgactive_18-2.1.7-1PIGSTY.el8.aarch64.rpm
`pgactive_18`	2.1.7	`el9.x86_64`	pigsty	346.6 KiB	pgactive_18-2.1.7-1PIGSTY.el9.x86_64.rpm
`pgactive_18`	2.1.7	`el9.aarch64`	pigsty	338.0 KiB	pgactive_18-2.1.7-1PIGSTY.el9.aarch64.rpm
`pgactive_18`	2.1.7	`el10.x86_64`	pigsty	350.7 KiB	pgactive_18-2.1.7-1PIGSTY.el10.x86_64.rpm
`pgactive_18`	2.1.7	`el10.aarch64`	pigsty	343.5 KiB	pgactive_18-2.1.7-1PIGSTY.el10.aarch64.rpm

Package	Version	OS	ORG	SIZE	File URL
`pgactive_17`	2.1.7	`el8.x86_64`	pigsty	367.9 KiB	pgactive_17-2.1.7-1PIGSTY.el8.x86_64.rpm
`pgactive_17`	2.1.7	`el8.aarch64`	pigsty	352.8 KiB	pgactive_17-2.1.7-1PIGSTY.el8.aarch64.rpm
`pgactive_17`	2.1.7	`el9.x86_64`	pigsty	339.2 KiB	pgactive_17-2.1.7-1PIGSTY.el9.x86_64.rpm
`pgactive_17`	2.1.7	`el9.aarch64`	pigsty	330.8 KiB	pgactive_17-2.1.7-1PIGSTY.el9.aarch64.rpm
`pgactive_17`	2.1.7	`el10.x86_64`	pigsty	343.0 KiB	pgactive_17-2.1.7-1PIGSTY.el10.x86_64.rpm
`pgactive_17`	2.1.7	`el10.aarch64`	pigsty	335.9 KiB	pgactive_17-2.1.7-1PIGSTY.el10.aarch64.rpm
`postgresql-17-pgactive`	2.1.6	`d12.x86_64`	pigsty	586.4 KiB	postgresql-17-pgactive_2.1.6-1PIGSTY~bookworm_amd64.deb
`postgresql-17-pgactive`	2.1.6	`d12.aarch64`	pigsty	560.4 KiB	postgresql-17-pgactive_2.1.6-1PIGSTY~bookworm_arm64.deb
`postgresql-17-pgactive`	2.1.6	`u22.x86_64`	pigsty	711.6 KiB	postgresql-17-pgactive_2.1.6-1PIGSTY~jammy_amd64.deb
`postgresql-17-pgactive`	2.1.6	`u22.aarch64`	pigsty	702.7 KiB	postgresql-17-pgactive_2.1.6-1PIGSTY~jammy_arm64.deb
`postgresql-17-pgactive`	2.1.6	`u24.x86_64`	pigsty	618.6 KiB	postgresql-17-pgactive_2.1.6-1PIGSTY~noble_amd64.deb
`postgresql-17-pgactive`	2.1.6	`u24.aarch64`	pigsty	612.8 KiB	postgresql-17-pgactive_2.1.6-1PIGSTY~noble_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pgactive_16`	2.1.7	`el8.x86_64`	pigsty	361.5 KiB	pgactive_16-2.1.7-1PIGSTY.el8.x86_64.rpm
`pgactive_16`	2.1.7	`el8.aarch64`	pigsty	346.2 KiB	pgactive_16-2.1.7-1PIGSTY.el8.aarch64.rpm
`pgactive_16`	2.1.7	`el9.x86_64`	pigsty	333.9 KiB	pgactive_16-2.1.7-1PIGSTY.el9.x86_64.rpm
`pgactive_16`	2.1.7	`el9.aarch64`	pigsty	325.5 KiB	pgactive_16-2.1.7-1PIGSTY.el9.aarch64.rpm
`pgactive_16`	2.1.7	`el10.x86_64`	pigsty	338.2 KiB	pgactive_16-2.1.7-1PIGSTY.el10.x86_64.rpm
`pgactive_16`	2.1.7	`el10.aarch64`	pigsty	329.6 KiB	pgactive_16-2.1.7-1PIGSTY.el10.aarch64.rpm
`postgresql-16-pgactive`	2.1.6	`d12.x86_64`	pigsty	581.2 KiB	postgresql-16-pgactive_2.1.6-1PIGSTY~bookworm_amd64.deb
`postgresql-16-pgactive`	2.1.6	`d12.aarch64`	pigsty	556.5 KiB	postgresql-16-pgactive_2.1.6-1PIGSTY~bookworm_arm64.deb
`postgresql-16-pgactive`	2.1.6	`u22.x86_64`	pigsty	700.8 KiB	postgresql-16-pgactive_2.1.6-1PIGSTY~jammy_amd64.deb
`postgresql-16-pgactive`	2.1.6	`u22.aarch64`	pigsty	692.2 KiB	postgresql-16-pgactive_2.1.6-1PIGSTY~jammy_arm64.deb
`postgresql-16-pgactive`	2.1.6	`u24.x86_64`	pigsty	613.8 KiB	postgresql-16-pgactive_2.1.6-1PIGSTY~noble_amd64.deb
`postgresql-16-pgactive`	2.1.6	`u24.aarch64`	pigsty	607.3 KiB	postgresql-16-pgactive_2.1.6-1PIGSTY~noble_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pgactive_15`	2.1.7	`el8.x86_64`	pigsty	353.2 KiB	pgactive_15-2.1.7-1PIGSTY.el8.x86_64.rpm
`pgactive_15`	2.1.7	`el8.aarch64`	pigsty	338.5 KiB	pgactive_15-2.1.7-1PIGSTY.el8.aarch64.rpm
`pgactive_15`	2.1.7	`el9.x86_64`	pigsty	330.2 KiB	pgactive_15-2.1.7-1PIGSTY.el9.x86_64.rpm
`pgactive_15`	2.1.7	`el9.aarch64`	pigsty	322.7 KiB	pgactive_15-2.1.7-1PIGSTY.el9.aarch64.rpm
`pgactive_15`	2.1.7	`el10.x86_64`	pigsty	333.6 KiB	pgactive_15-2.1.7-1PIGSTY.el10.x86_64.rpm
`pgactive_15`	2.1.7	`el10.aarch64`	pigsty	327.7 KiB	pgactive_15-2.1.7-1PIGSTY.el10.aarch64.rpm
`postgresql-15-pgactive`	2.1.6	`d12.x86_64`	pigsty	577.4 KiB	postgresql-15-pgactive_2.1.6-1PIGSTY~bookworm_amd64.deb
`postgresql-15-pgactive`	2.1.6	`d12.aarch64`	pigsty	550.9 KiB	postgresql-15-pgactive_2.1.6-1PIGSTY~bookworm_arm64.deb
`postgresql-15-pgactive`	2.1.6	`u22.x86_64`	pigsty	698.1 KiB	postgresql-15-pgactive_2.1.6-1PIGSTY~jammy_amd64.deb
`postgresql-15-pgactive`	2.1.6	`u22.aarch64`	pigsty	690.5 KiB	postgresql-15-pgactive_2.1.6-1PIGSTY~jammy_arm64.deb
`postgresql-15-pgactive`	2.1.6	`u24.x86_64`	pigsty	610.0 KiB	postgresql-15-pgactive_2.1.6-1PIGSTY~noble_amd64.deb
`postgresql-15-pgactive`	2.1.6	`u24.aarch64`	pigsty	605.7 KiB	postgresql-15-pgactive_2.1.6-1PIGSTY~noble_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pgactive_14`	2.1.7	`el8.x86_64`	pigsty	352.8 KiB	pgactive_14-2.1.7-1PIGSTY.el8.x86_64.rpm
`pgactive_14`	2.1.7	`el8.aarch64`	pigsty	339.0 KiB	pgactive_14-2.1.7-1PIGSTY.el8.aarch64.rpm
`pgactive_14`	2.1.7	`el9.x86_64`	pigsty	332.9 KiB	pgactive_14-2.1.7-1PIGSTY.el9.x86_64.rpm
`pgactive_14`	2.1.7	`el9.aarch64`	pigsty	325.3 KiB	pgactive_14-2.1.7-1PIGSTY.el9.aarch64.rpm
`pgactive_14`	2.1.7	`el10.x86_64`	pigsty	338.2 KiB	pgactive_14-2.1.7-1PIGSTY.el10.x86_64.rpm
`pgactive_14`	2.1.7	`el10.aarch64`	pigsty	329.0 KiB	pgactive_14-2.1.7-1PIGSTY.el10.aarch64.rpm
`postgresql-14-pgactive`	2.1.6	`d12.x86_64`	pigsty	580.8 KiB	postgresql-14-pgactive_2.1.6-1PIGSTY~bookworm_amd64.deb
`postgresql-14-pgactive`	2.1.6	`d12.aarch64`	pigsty	555.2 KiB	postgresql-14-pgactive_2.1.6-1PIGSTY~bookworm_arm64.deb
`postgresql-14-pgactive`	2.1.6	`u22.x86_64`	pigsty	701.1 KiB	postgresql-14-pgactive_2.1.6-1PIGSTY~jammy_amd64.deb
`postgresql-14-pgactive`	2.1.6	`u22.aarch64`	pigsty	692.8 KiB	postgresql-14-pgactive_2.1.6-1PIGSTY~jammy_arm64.deb
`postgresql-14-pgactive`	2.1.6	`u24.x86_64`	pigsty	613.2 KiB	postgresql-14-pgactive_2.1.6-1PIGSTY~noble_amd64.deb
`postgresql-14-pgactive`	2.1.6	`u24.aarch64`	pigsty	606.9 KiB	postgresql-14-pgactive_2.1.6-1PIGSTY~noble_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pgactive_13`	2.1.7	`el8.x86_64`	pigsty	345.8 KiB	pgactive_13-2.1.7-1PIGSTY.el8.x86_64.rpm
`pgactive_13`	2.1.7	`el8.aarch64`	pigsty	334.4 KiB	pgactive_13-2.1.7-1PIGSTY.el8.aarch64.rpm
`pgactive_13`	2.1.7	`el9.x86_64`	pigsty	328.9 KiB	pgactive_13-2.1.7-1PIGSTY.el9.x86_64.rpm
`pgactive_13`	2.1.7	`el9.aarch64`	pigsty	321.7 KiB	pgactive_13-2.1.7-1PIGSTY.el9.aarch64.rpm
`pgactive_13`	2.1.7	`el10.x86_64`	pigsty	334.1 KiB	pgactive_13-2.1.7-1PIGSTY.el10.x86_64.rpm
`pgactive_13`	2.1.7	`el10.aarch64`	pigsty	325.2 KiB	pgactive_13-2.1.7-1PIGSTY.el10.aarch64.rpm
`postgresql-13-pgactive`	2.1.6	`d12.x86_64`	pigsty	576.6 KiB	postgresql-13-pgactive_2.1.6-1PIGSTY~bookworm_amd64.deb
`postgresql-13-pgactive`	2.1.6	`d12.aarch64`	pigsty	549.9 KiB	postgresql-13-pgactive_2.1.6-1PIGSTY~bookworm_arm64.deb
`postgresql-13-pgactive`	2.1.6	`u22.x86_64`	pigsty	694.5 KiB	postgresql-13-pgactive_2.1.6-1PIGSTY~jammy_amd64.deb
`postgresql-13-pgactive`	2.1.6	`u22.aarch64`	pigsty	686.3 KiB	postgresql-13-pgactive_2.1.6-1PIGSTY~jammy_arm64.deb
`postgresql-13-pgactive`	2.1.6	`u24.x86_64`	pigsty	607.9 KiB	postgresql-13-pgactive_2.1.6-1PIGSTY~noble_amd64.deb
`postgresql-13-pgactive`	2.1.6	`u24.aarch64`	pigsty	601.7 KiB	postgresql-13-pgactive_2.1.6-1PIGSTY~noble_arm64.deb

Source

Repository

github.com/aws/pgactive

Source Tarball

pgactive-2.1.7.tar.gz

pig build get pgactive; # get pgactive source code
pig build dep pgactive; # install build dependencies
pig build pkg pgactive; # build extension rpm or deb
pig build ext pgactive; # build extension rpms

Install

To add the required PGDG / PIGSTY upstream repository, use:

pig repo add pgsql -u   # add PGDG + Pigsty repo and update cache (leave existing repos)

Install this extension with:

pig ext install pgactive; # install by extension name, for the current active PG version
pig ext install pgactive; # install via package alias, for the active PG version
pig ext install pgactive -v 18;   # install for PG 18
pig ext install pgactive -v 17;   # install for PG 17
pig ext install pgactive -v 16;   # install for PG 16
pig ext install pgactive -v 15;   # install for PG 15
pig ext install pgactive -v 14;   # install for PG 14
pig ext install pgactive -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION pgactive CASCADE SCHEMA pg_catalog;

Last updated on 2025-11-02

db_migrator wal2json