pglogical

pglogical

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
--sLd--
No
Yes
Yes
Yes
no
no
Relationships
Schemas pglogical
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 Compatibility Package Pattern Dependencies
EXT
PGDG
2.4.6
18
17
16
15
14
pglogical -
RPM
PGDG
2.4.6
18
17
16
15
14
pglogical_$v -
DEB
PGDG
2.4.6
18
17
16
15
14
postgresql-$v-pglogical -
Linux / PG PG18 PG17 PG16 PG15 PG14
el8.x86_64
PGDG 2.4.6
PGDG 2.4.5
PGDG 2.4.4
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
el9.x86_64
PGDG 2.4.6
PGDG 2.4.5
PGDG 2.4.4
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
el10.x86_64
PGDG 2.4.6
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
d12.x86_64
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
d13.x86_64
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
u22.x86_64
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
u24.x86_64
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
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 345.7 KiB postgresql-18-pglogical_2.4.6-2.pgdg12+1_amd64.deb
postgresql-18-pglogical 2.4.6 d12.aarch64 pgdg 336.5 KiB postgresql-18-pglogical_2.4.6-2.pgdg12+1_arm64.deb
postgresql-18-pglogical 2.4.6 d13.x86_64 pgdg 346.5 KiB postgresql-18-pglogical_2.4.6-2.pgdg13+1_amd64.deb
postgresql-18-pglogical 2.4.6 d13.aarch64 pgdg 337.7 KiB postgresql-18-pglogical_2.4.6-2.pgdg13+1_arm64.deb
postgresql-18-pglogical 2.4.6 u22.x86_64 pgdg 357.3 KiB postgresql-18-pglogical_2.4.6-2.pgdg22.04+1_amd64.deb
postgresql-18-pglogical 2.4.6 u22.aarch64 pgdg 345.8 KiB postgresql-18-pglogical_2.4.6-2.pgdg22.04+1_arm64.deb
postgresql-18-pglogical 2.4.6 u24.x86_64 pgdg 344.7 KiB postgresql-18-pglogical_2.4.6-2.pgdg24.04+1_amd64.deb
postgresql-18-pglogical 2.4.6 u24.aarch64 pgdg 335.5 KiB postgresql-18-pglogical_2.4.6-2.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 345.7 KiB postgresql-17-pglogical_2.4.6-2.pgdg12+1_amd64.deb
postgresql-17-pglogical 2.4.6 d12.aarch64 pgdg 336.0 KiB postgresql-17-pglogical_2.4.6-2.pgdg12+1_arm64.deb
postgresql-17-pglogical 2.4.6 d13.x86_64 pgdg 346.1 KiB postgresql-17-pglogical_2.4.6-2.pgdg13+1_amd64.deb
postgresql-17-pglogical 2.4.6 d13.aarch64 pgdg 337.1 KiB postgresql-17-pglogical_2.4.6-2.pgdg13+1_arm64.deb
postgresql-17-pglogical 2.4.6 u22.x86_64 pgdg 434.2 KiB postgresql-17-pglogical_2.4.6-2.pgdg22.04+1_amd64.deb
postgresql-17-pglogical 2.4.6 u22.aarch64 pgdg 422.2 KiB postgresql-17-pglogical_2.4.6-2.pgdg22.04+1_arm64.deb
postgresql-17-pglogical 2.4.6 u24.x86_64 pgdg 344.9 KiB postgresql-17-pglogical_2.4.6-2.pgdg24.04+1_amd64.deb
postgresql-17-pglogical 2.4.6 u24.aarch64 pgdg 334.8 KiB postgresql-17-pglogical_2.4.6-2.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 344.5 KiB postgresql-16-pglogical_2.4.6-2.pgdg12+1_amd64.deb
postgresql-16-pglogical 2.4.6 d12.aarch64 pgdg 334.6 KiB postgresql-16-pglogical_2.4.6-2.pgdg12+1_arm64.deb
postgresql-16-pglogical 2.4.6 d13.x86_64 pgdg 345.8 KiB postgresql-16-pglogical_2.4.6-2.pgdg13+1_amd64.deb
postgresql-16-pglogical 2.4.6 d13.aarch64 pgdg 336.0 KiB postgresql-16-pglogical_2.4.6-2.pgdg13+1_arm64.deb
postgresql-16-pglogical 2.4.6 u22.x86_64 pgdg 431.0 KiB postgresql-16-pglogical_2.4.6-2.pgdg22.04+1_amd64.deb
postgresql-16-pglogical 2.4.6 u22.aarch64 pgdg 419.8 KiB postgresql-16-pglogical_2.4.6-2.pgdg22.04+1_arm64.deb
postgresql-16-pglogical 2.4.6 u24.x86_64 pgdg 343.4 KiB postgresql-16-pglogical_2.4.6-2.pgdg24.04+1_amd64.deb
postgresql-16-pglogical 2.4.6 u24.aarch64 pgdg 334.2 KiB postgresql-16-pglogical_2.4.6-2.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.9 KiB postgresql-15-pglogical_2.4.6-2.pgdg12+1_amd64.deb
postgresql-15-pglogical 2.4.6 d12.aarch64 pgdg 335.7 KiB postgresql-15-pglogical_2.4.6-2.pgdg12+1_arm64.deb
postgresql-15-pglogical 2.4.6 d13.x86_64 pgdg 348.1 KiB postgresql-15-pglogical_2.4.6-2.pgdg13+1_amd64.deb
postgresql-15-pglogical 2.4.6 d13.aarch64 pgdg 336.9 KiB postgresql-15-pglogical_2.4.6-2.pgdg13+1_arm64.deb
postgresql-15-pglogical 2.4.6 u22.x86_64 pgdg 436.4 KiB postgresql-15-pglogical_2.4.6-2.pgdg22.04+1_amd64.deb
postgresql-15-pglogical 2.4.6 u22.aarch64 pgdg 424.8 KiB postgresql-15-pglogical_2.4.6-2.pgdg22.04+1_arm64.deb
postgresql-15-pglogical 2.4.6 u24.x86_64 pgdg 347.0 KiB postgresql-15-pglogical_2.4.6-2.pgdg24.04+1_amd64.deb
postgresql-15-pglogical 2.4.6 u24.aarch64 pgdg 336.9 KiB postgresql-15-pglogical_2.4.6-2.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 347.2 KiB postgresql-14-pglogical_2.4.6-2.pgdg12+1_amd64.deb
postgresql-14-pglogical 2.4.6 d12.aarch64 pgdg 335.5 KiB postgresql-14-pglogical_2.4.6-2.pgdg12+1_arm64.deb
postgresql-14-pglogical 2.4.6 d13.x86_64 pgdg 347.2 KiB postgresql-14-pglogical_2.4.6-2.pgdg13+1_amd64.deb
postgresql-14-pglogical 2.4.6 d13.aarch64 pgdg 336.8 KiB postgresql-14-pglogical_2.4.6-2.pgdg13+1_arm64.deb
postgresql-14-pglogical 2.4.6 u22.x86_64 pgdg 434.5 KiB postgresql-14-pglogical_2.4.6-2.pgdg22.04+1_amd64.deb
postgresql-14-pglogical 2.4.6 u22.aarch64 pgdg 423.2 KiB postgresql-14-pglogical_2.4.6-2.pgdg22.04+1_arm64.deb
postgresql-14-pglogical 2.4.6 u24.x86_64 pgdg 347.2 KiB postgresql-14-pglogical_2.4.6-2.pgdg24.04+1_amd64.deb
postgresql-14-pglogical 2.4.6 u24.aarch64 pgdg 336.0 KiB postgresql-14-pglogical_2.4.6-2.pgdg24.04+1_arm64.deb

Source

Install

Make sure PGDG repo available:

pig repo add pgdg -u    # add pgdg repo and update cache

Install this extension with pig:

pig install pglogical;		# install via package name, for the active PG version

pig install pglogical -v 18;   # install for PG 18
pig install pglogical -v 17;   # install for PG 17
pig install pglogical -v 16;   # install for PG 16
pig install pglogical -v 15;   # install for PG 15
pig install pglogical -v 14;   # install for PG 14

Config this extension to shared_preload_libraries:

shared_preload_libraries = 'pglogical';

Create this extension with:

CREATE EXTENSION pglogical;
Last updated on