pglogical

PostgreSQL Logical Replication

Overview

ID	Extension	Package	Version	Category	License	Language
9500	pglogical	pglogical	`2.4.6`	ETL	PostgreSQL	C

Attribute	Has Binary	Has Library	Need Load	Has DDL	Relocatable	Trusted
--s-d--	No	Yes	No	Yes	no	no

Relationships
Need By	pgl_ddl_deploy pglogical_ticker
See Also	decoderbufs wal2json dblink postgres_fdw pg_failover_slots pgactive repmgr kafka_fdw
Siblings	pglogical_origin

Packages

Type	Repo	Version	PG Major Availability	Package Pattern	Dependencies
EL	PGDG	`2.4.6`	18 17 16 15 14 13	`pglogical_$v*`	-
Debian	PGDG	`2.4.6`	18 17 16 15 14 13	`postgresql-$v-pglogical`	-

Linux / PG	PG18	PG17	PG16	PG15	PG14	PG13
el8.x86_64	PGDG 2.4.6	PGDG 2.4.5	PGDG 2.4.4	PGDG 2.4.3	PGDG 2.4.3	PGDG 2.4.3
el8.aarch64	PGDG 2.4.6	PGDG 2.4.5	PGDG 2.4.4	PGDG 2.4.3	PGDG 2.4.3	PGDG 2.4.3
el9.x86_64	PGDG 2.4.6	PGDG 2.4.5	PGDG 2.4.4	PGDG 2.4.3	PGDG 2.4.3	PGDG 2.4.3
el9.aarch64	PGDG 2.4.6	PGDG 2.4.5	PGDG 2.4.4	PGDG 2.4.3	PGDG 2.4.3	PGDG 2.4.3
el10.x86_64	PGDG 2.4.6	PGDG 2.4.5	PGDG 2.4.5	PGDG 2.4.5	PGDG 2.4.5	PGDG 2.4.5
el10.aarch64	PGDG 2.4.6	PGDG 2.4.5	PGDG 2.4.5	PGDG 2.4.5	PGDG 2.4.5	PGDG 2.4.5
d12.x86_64	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6
d12.aarch64	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6
d13.x86_64	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6
d13.aarch64	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6
u22.x86_64	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6
u22.aarch64	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6
u24.x86_64	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6
u24.aarch64	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6	PGDG 2.4.6

Package	Version	OS	ORG	SIZE	File URL
`pglogical_18`	2.4.6	`el8.x86_64`	pgdg	154.6 KiB	pglogical_18-2.4.6-1PGDG.rhel8.x86_64.rpm
`pglogical_18`	2.4.6	`el8.aarch64`	pgdg	148.0 KiB	pglogical_18-2.4.6-1PGDG.rhel8.aarch64.rpm
`pglogical_18`	2.4.6	`el9.x86_64`	pgdg	146.3 KiB	pglogical_18-2.4.6-1PGDG.rhel9.x86_64.rpm
`pglogical_18`	2.4.6	`el9.aarch64`	pgdg	143.1 KiB	pglogical_18-2.4.6-1PGDG.rhel9.aarch64.rpm
`pglogical_18`	2.4.6	`el10.x86_64`	pgdg	148.4 KiB	pglogical_18-2.4.6-1PGDG.rhel10.x86_64.rpm
`pglogical_18`	2.4.6	`el10.aarch64`	pgdg	145.1 KiB	pglogical_18-2.4.6-1PGDG.rhel10.aarch64.rpm
`postgresql-18-pglogical`	2.4.6	`d12.x86_64`	pgdg	344.8 KiB	postgresql-18-pglogical_2.4.6-1.pgdg12+1_amd64.deb
`postgresql-18-pglogical`	2.4.6	`d12.aarch64`	pgdg	335.8 KiB	postgresql-18-pglogical_2.4.6-1.pgdg12+1_arm64.deb
`postgresql-18-pglogical`	2.4.6	`d13.x86_64`	pgdg	345.4 KiB	postgresql-18-pglogical_2.4.6-1.pgdg13+1_amd64.deb
`postgresql-18-pglogical`	2.4.6	`d13.aarch64`	pgdg	336.7 KiB	postgresql-18-pglogical_2.4.6-1.pgdg13+1_arm64.deb
`postgresql-18-pglogical`	2.4.6	`u22.x86_64`	pgdg	355.8 KiB	postgresql-18-pglogical_2.4.6-1.pgdg22.04+1_amd64.deb
`postgresql-18-pglogical`	2.4.6	`u22.aarch64`	pgdg	344.9 KiB	postgresql-18-pglogical_2.4.6-1.pgdg22.04+1_arm64.deb
`postgresql-18-pglogical`	2.4.6	`u24.x86_64`	pgdg	343.4 KiB	postgresql-18-pglogical_2.4.6-1.pgdg24.04+1_amd64.deb
`postgresql-18-pglogical`	2.4.6	`u24.aarch64`	pgdg	334.2 KiB	postgresql-18-pglogical_2.4.6-1.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pglogical_17`	2.4.5	`el8.x86_64`	pgdg	153.8 KiB	pglogical_17-2.4.5-1PGDG.rhel8.x86_64.rpm
`pglogical_17`	2.4.5	`el8.aarch64`	pgdg	147.2 KiB	pglogical_17-2.4.5-1PGDG.rhel8.aarch64.rpm
`pglogical_17`	2.4.5	`el9.x86_64`	pgdg	146.5 KiB	pglogical_17-2.4.5-1PGDG.rhel9.x86_64.rpm
`pglogical_17`	2.4.5	`el9.aarch64`	pgdg	143.5 KiB	pglogical_17-2.4.5-1PGDG.rhel9.aarch64.rpm
`pglogical_17`	2.4.5	`el10.x86_64`	pgdg	148.3 KiB	pglogical_17-2.4.5-3PGDG.rhel10.x86_64.rpm
`pglogical_17`	2.4.5	`el10.aarch64`	pgdg	144.7 KiB	pglogical_17-2.4.5-3PGDG.rhel10.aarch64.rpm
`postgresql-17-pglogical`	2.4.6	`d12.x86_64`	pgdg	344.7 KiB	postgresql-17-pglogical_2.4.6-1.pgdg12+1_amd64.deb
`postgresql-17-pglogical`	2.4.6	`d12.aarch64`	pgdg	334.8 KiB	postgresql-17-pglogical_2.4.6-1.pgdg12+1_arm64.deb
`postgresql-17-pglogical`	2.4.6	`d13.x86_64`	pgdg	345.2 KiB	postgresql-17-pglogical_2.4.6-1.pgdg13+1_amd64.deb
`postgresql-17-pglogical`	2.4.6	`d13.aarch64`	pgdg	336.6 KiB	postgresql-17-pglogical_2.4.6-1.pgdg13+1_arm64.deb
`postgresql-17-pglogical`	2.4.6	`u22.x86_64`	pgdg	432.4 KiB	postgresql-17-pglogical_2.4.6-1.pgdg22.04+1_amd64.deb
`postgresql-17-pglogical`	2.4.6	`u22.aarch64`	pgdg	420.8 KiB	postgresql-17-pglogical_2.4.6-1.pgdg22.04+1_arm64.deb
`postgresql-17-pglogical`	2.4.6	`u24.x86_64`	pgdg	343.6 KiB	postgresql-17-pglogical_2.4.6-1.pgdg24.04+1_amd64.deb
`postgresql-17-pglogical`	2.4.6	`u24.aarch64`	pgdg	333.7 KiB	postgresql-17-pglogical_2.4.6-1.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pglogical_16`	2.4.4	`el8.x86_64`	pgdg	152.1 KiB	pglogical_16-2.4.4-1PGDG.rhel8.x86_64.rpm
`pglogical_16`	2.4.4	`el8.aarch64`	pgdg	145.6 KiB	pglogical_16-2.4.4-1PGDG.rhel8.aarch64.rpm
`pglogical_16`	2.4.4	`el9.x86_64`	pgdg	146.1 KiB	pglogical_16-2.4.4-1PGDG.rhel9.x86_64.rpm
`pglogical_16`	2.4.4	`el9.aarch64`	pgdg	143.0 KiB	pglogical_16-2.4.4-1PGDG.rhel9.aarch64.rpm
`pglogical_16`	2.4.5	`el10.x86_64`	pgdg	148.5 KiB	pglogical_16-2.4.5-3PGDG.rhel10.x86_64.rpm
`pglogical_16`	2.4.5	`el10.aarch64`	pgdg	144.9 KiB	pglogical_16-2.4.5-3PGDG.rhel10.aarch64.rpm
`postgresql-16-pglogical`	2.4.6	`d12.x86_64`	pgdg	343.5 KiB	postgresql-16-pglogical_2.4.6-1.pgdg12+1_amd64.deb
`postgresql-16-pglogical`	2.4.6	`d12.aarch64`	pgdg	333.7 KiB	postgresql-16-pglogical_2.4.6-1.pgdg12+1_arm64.deb
`postgresql-16-pglogical`	2.4.6	`d13.x86_64`	pgdg	344.4 KiB	postgresql-16-pglogical_2.4.6-1.pgdg13+1_amd64.deb
`postgresql-16-pglogical`	2.4.6	`d13.aarch64`	pgdg	335.4 KiB	postgresql-16-pglogical_2.4.6-1.pgdg13+1_arm64.deb
`postgresql-16-pglogical`	2.4.6	`u22.x86_64`	pgdg	429.9 KiB	postgresql-16-pglogical_2.4.6-1.pgdg22.04+1_amd64.deb
`postgresql-16-pglogical`	2.4.6	`u22.aarch64`	pgdg	417.9 KiB	postgresql-16-pglogical_2.4.6-1.pgdg22.04+1_arm64.deb
`postgresql-16-pglogical`	2.4.6	`u24.x86_64`	pgdg	342.4 KiB	postgresql-16-pglogical_2.4.6-1.pgdg24.04+1_amd64.deb
`postgresql-16-pglogical`	2.4.6	`u24.aarch64`	pgdg	332.8 KiB	postgresql-16-pglogical_2.4.6-1.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pglogical_15`	2.4.3	`el8.x86_64`	pgdg	153.2 KiB	pglogical_15-2.4.3-1.rhel8.x86_64.rpm
`pglogical_15`	2.4.2	`el8.x86_64`	pgdg	152.5 KiB	pglogical_15-2.4.2-1.rhel8.x86_64.rpm
`pglogical_15`	2.4.3	`el8.aarch64`	pgdg	146.4 KiB	pglogical_15-2.4.3-1.rhel8.aarch64.rpm
`pglogical_15`	2.4.2	`el8.aarch64`	pgdg	145.6 KiB	pglogical_15-2.4.2-1.rhel8.aarch64.rpm
`pglogical_15`	2.4.3	`el9.x86_64`	pgdg	150.6 KiB	pglogical_15-2.4.3-1.rhel9.x86_64.rpm
`pglogical_15`	2.4.2	`el9.x86_64`	pgdg	150.1 KiB	pglogical_15-2.4.2-1.rhel9.x86_64.rpm
`pglogical_15`	2.4.3	`el9.aarch64`	pgdg	146.0 KiB	pglogical_15-2.4.3-1.rhel9.aarch64.rpm
`pglogical_15`	2.4.2	`el9.aarch64`	pgdg	146.1 KiB	pglogical_15-2.4.2-1.rhel9.aarch64.rpm
`pglogical_15`	2.4.5	`el10.x86_64`	pgdg	151.9 KiB	pglogical_15-2.4.5-3PGDG.rhel10.x86_64.rpm
`pglogical_15`	2.4.5	`el10.aarch64`	pgdg	149.2 KiB	pglogical_15-2.4.5-3PGDG.rhel10.aarch64.rpm
`postgresql-15-pglogical`	2.4.6	`d12.x86_64`	pgdg	346.2 KiB	postgresql-15-pglogical_2.4.6-1.pgdg12+1_amd64.deb
`postgresql-15-pglogical`	2.4.6	`d12.aarch64`	pgdg	335.2 KiB	postgresql-15-pglogical_2.4.6-1.pgdg12+1_arm64.deb
`postgresql-15-pglogical`	2.4.6	`d13.x86_64`	pgdg	347.0 KiB	postgresql-15-pglogical_2.4.6-1.pgdg13+1_amd64.deb
`postgresql-15-pglogical`	2.4.6	`d13.aarch64`	pgdg	336.2 KiB	postgresql-15-pglogical_2.4.6-1.pgdg13+1_arm64.deb
`postgresql-15-pglogical`	2.4.6	`u22.x86_64`	pgdg	435.7 KiB	postgresql-15-pglogical_2.4.6-1.pgdg22.04+1_amd64.deb
`postgresql-15-pglogical`	2.4.6	`u22.aarch64`	pgdg	423.9 KiB	postgresql-15-pglogical_2.4.6-1.pgdg22.04+1_arm64.deb
`postgresql-15-pglogical`	2.4.6	`u24.x86_64`	pgdg	346.3 KiB	postgresql-15-pglogical_2.4.6-1.pgdg24.04+1_amd64.deb
`postgresql-15-pglogical`	2.4.6	`u24.aarch64`	pgdg	335.3 KiB	postgresql-15-pglogical_2.4.6-1.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pglogical_14`	2.4.3	`el8.x86_64`	pgdg	151.7 KiB	pglogical_14-2.4.3-1.rhel8.x86_64.rpm
`pglogical_14`	2.4.2	`el8.x86_64`	pgdg	150.9 KiB	pglogical_14-2.4.2-1.rhel8.x86_64.rpm
`pglogical_14`	2.4.1	`el8.x86_64`	pgdg	150.4 KiB	pglogical_14-2.4.1-1.rhel8.x86_64.rpm
`pglogical_14`	2.4.0	`el8.x86_64`	pgdg	149.9 KiB	pglogical_14-2.4.0-1.rhel8.x86_64.rpm
`pglogical_14`	2.4.3	`el8.aarch64`	pgdg	145.3 KiB	pglogical_14-2.4.3-1.rhel8.aarch64.rpm
`pglogical_14`	2.4.2	`el8.aarch64`	pgdg	144.6 KiB	pglogical_14-2.4.2-1.rhel8.aarch64.rpm
`pglogical_14`	2.4.3	`el9.x86_64`	pgdg	150.1 KiB	pglogical_14-2.4.3-1.rhel9.x86_64.rpm
`pglogical_14`	2.4.2	`el9.x86_64`	pgdg	150.1 KiB	pglogical_14-2.4.2-1.rhel9.x86_64.rpm
`pglogical_14`	2.4.1	`el9.x86_64`	pgdg	149.7 KiB	pglogical_14-2.4.1-1.rhel9.x86_64.rpm
`pglogical_14`	2.4.3	`el9.aarch64`	pgdg	145.6 KiB	pglogical_14-2.4.3-1.rhel9.aarch64.rpm
`pglogical_14`	2.4.2	`el9.aarch64`	pgdg	145.6 KiB	pglogical_14-2.4.2-1.rhel9.aarch64.rpm
`pglogical_14`	2.4.5	`el10.x86_64`	pgdg	151.3 KiB	pglogical_14-2.4.5-3PGDG.rhel10.x86_64.rpm
`pglogical_14`	2.4.5	`el10.aarch64`	pgdg	148.7 KiB	pglogical_14-2.4.5-3PGDG.rhel10.aarch64.rpm
`postgresql-14-pglogical`	2.4.6	`d12.x86_64`	pgdg	346.6 KiB	postgresql-14-pglogical_2.4.6-1.pgdg12+1_amd64.deb
`postgresql-14-pglogical`	2.4.6	`d12.aarch64`	pgdg	334.7 KiB	postgresql-14-pglogical_2.4.6-1.pgdg12+1_arm64.deb
`postgresql-14-pglogical`	2.4.6	`d13.x86_64`	pgdg	346.2 KiB	postgresql-14-pglogical_2.4.6-1.pgdg13+1_amd64.deb
`postgresql-14-pglogical`	2.4.6	`d13.aarch64`	pgdg	335.7 KiB	postgresql-14-pglogical_2.4.6-1.pgdg13+1_arm64.deb
`postgresql-14-pglogical`	2.4.6	`u22.x86_64`	pgdg	433.6 KiB	postgresql-14-pglogical_2.4.6-1.pgdg22.04+1_amd64.deb
`postgresql-14-pglogical`	2.4.6	`u22.aarch64`	pgdg	422.4 KiB	postgresql-14-pglogical_2.4.6-1.pgdg22.04+1_arm64.deb
`postgresql-14-pglogical`	2.4.6	`u24.x86_64`	pgdg	345.9 KiB	postgresql-14-pglogical_2.4.6-1.pgdg24.04+1_amd64.deb
`postgresql-14-pglogical`	2.4.6	`u24.aarch64`	pgdg	335.1 KiB	postgresql-14-pglogical_2.4.6-1.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pglogical_13`	2.4.3	`el8.x86_64`	pgdg	149.9 KiB	pglogical_13-2.4.3-1.rhel8.x86_64.rpm
`pglogical_13`	2.4.2	`el8.x86_64`	pgdg	149.1 KiB	pglogical_13-2.4.2-1.rhel8.x86_64.rpm
`pglogical_13`	2.4.1	`el8.x86_64`	pgdg	148.6 KiB	pglogical_13-2.4.1-1.rhel8.x86_64.rpm
`pglogical_13`	2.4.0	`el8.x86_64`	pgdg	147.9 KiB	pglogical_13-2.4.0-1.rhel8.x86_64.rpm
`pglogical_13`	2.3.4	`el8.x86_64`	pgdg	460.2 KiB	pglogical_13-2.3.4-1.rhel8.x86_64.rpm
`pglogical_13`	2.4.3	`el8.aarch64`	pgdg	145.2 KiB	pglogical_13-2.4.3-1.rhel8.aarch64.rpm
`pglogical_13`	2.4.2	`el8.aarch64`	pgdg	144.4 KiB	pglogical_13-2.4.2-1.rhel8.aarch64.rpm
`pglogical_13`	2.4.3	`el9.x86_64`	pgdg	149.3 KiB	pglogical_13-2.4.3-1.rhel9.x86_64.rpm
`pglogical_13`	2.4.2	`el9.x86_64`	pgdg	149.0 KiB	pglogical_13-2.4.2-1.rhel9.x86_64.rpm
`pglogical_13`	2.4.1	`el9.x86_64`	pgdg	149.0 KiB	pglogical_13-2.4.1-1.rhel9.x86_64.rpm
`pglogical_13`	2.4.3	`el9.aarch64`	pgdg	145.6 KiB	pglogical_13-2.4.3-1.rhel9.aarch64.rpm
`pglogical_13`	2.4.2	`el9.aarch64`	pgdg	145.5 KiB	pglogical_13-2.4.2-1.rhel9.aarch64.rpm
`pglogical_13`	2.4.5	`el10.x86_64`	pgdg	151.2 KiB	pglogical_13-2.4.5-3PGDG.rhel10.x86_64.rpm
`pglogical_13`	2.4.5	`el10.aarch64`	pgdg	149.3 KiB	pglogical_13-2.4.5-3PGDG.rhel10.aarch64.rpm
`postgresql-13-pglogical`	2.4.6	`d12.x86_64`	pgdg	345.3 KiB	postgresql-13-pglogical_2.4.6-1.pgdg12+1_amd64.deb
`postgresql-13-pglogical`	2.4.6	`d12.aarch64`	pgdg	334.0 KiB	postgresql-13-pglogical_2.4.6-1.pgdg12+1_arm64.deb
`postgresql-13-pglogical`	2.4.6	`d13.x86_64`	pgdg	345.4 KiB	postgresql-13-pglogical_2.4.6-1.pgdg13+1_amd64.deb
`postgresql-13-pglogical`	2.4.6	`d13.aarch64`	pgdg	335.6 KiB	postgresql-13-pglogical_2.4.6-1.pgdg13+1_arm64.deb
`postgresql-13-pglogical`	2.4.6	`u22.x86_64`	pgdg	430.1 KiB	postgresql-13-pglogical_2.4.6-1.pgdg22.04+1_amd64.deb
`postgresql-13-pglogical`	2.4.6	`u22.aarch64`	pgdg	419.2 KiB	postgresql-13-pglogical_2.4.6-1.pgdg22.04+1_arm64.deb
`postgresql-13-pglogical`	2.4.6	`u24.x86_64`	pgdg	345.1 KiB	postgresql-13-pglogical_2.4.6-1.pgdg24.04+1_amd64.deb
`postgresql-13-pglogical`	2.4.6	`u24.aarch64`	pgdg	334.9 KiB	postgresql-13-pglogical_2.4.6-1.pgdg24.04+1_arm64.deb

Source

Repository

github.com/2ndQuadrant/pglogical

Source Tarball

pglogical_ticker-1.4.1.tar.gz

pig build get pglogical; # get pglogical source code
pig build dep pglogical; # install build dependencies
pig build pkg pglogical; # build extension rpm or deb
pig build ext pglogical; # 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 pglogical; # install by extension name, for the current active PG version
pig ext install pglogical; # install via package alias, for the active PG version
pig ext install pglogical -v 18;   # install for PG 18
pig ext install pglogical -v 17;   # install for PG 17
pig ext install pglogical -v 16;   # install for PG 16
pig ext install pglogical -v 15;   # install for PG 15
pig ext install pglogical -v 14;   # install for PG 14
pig ext install pglogical -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION pglogical CASCADE SCHEMA pglogical;

Last updated on 2025-11-02

pgmemcache pglogical_origin