Extensions
pgl_ddl_deploy

pgl_ddl_deploy

pgl_ddl_deploy : automated ddl deployment using pglogical

Overview

ID Extension Package Version Category License Language
9520
pgl_ddl_deploy
pgl_ddl_deploy
 2.2.1
ETL
MIT
C
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--s-d--
No
Yes
No
Yes
no
no
Relationships
Schemas pgl_ddl_deploy
Requires
pglogical
See Also
pglogical_origin
pglogical_ticker
ddlx
pg_permissions
pg_failover_slots
pgactive
wal2json
decoderbufs

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
PGDG
 2.2.1
18
17
16
15
14
 pgl_ddl_deploy pglogical
RPM
PGDG
 2.2.1
18
17
16
15
14
 pgl_ddl_deploy_$v pglogical_$v
DEB
PGDG
 2.2.1
18
17
16
15
14
 postgresql-$v-pgl-ddl-deploy postgresql-$v-pglogical
Linux / PG PG18 PG17 PG16 PG15 PG14
el8.x86_64
MISS
PGDG 2.2.1
PGDG 2.2.1
PGDG 2.2.1
PGDG 2.2.1
el8.aarch64
MISS
PGDG 2.2.1
PGDG 2.2.1
PGDG 2.2.1
PGDG 2.2.1
el9.x86_64
MISS
PGDG 2.2.1
PGDG 2.2.1
PGDG 2.2.0
PGDG 2.2.0
el9.aarch64
MISS
PGDG 2.2.1
PGDG 2.2.1
PGDG 2.2.1
PGDG 2.2.1
el10.x86_64
MISS
PGDG 2.2.1
PGDG 2.2.1
PGDG 2.2.1
PGDG 2.2.1
el10.aarch64
MISS
PGDG 2.2.1
PGDG 2.2.1
PGDG 2.2.1
PGDG 2.2.1
d12.x86_64
MISS
PGDG 2.2.1
PGDG 2.2.1
PGDG 2.2.1
PGDG 2.2.1
d12.aarch64
MISS
PGDG 2.2.1
PGDG 2.2.1
PGDG 2.2.1
PGDG 2.2.1
d13.x86_64
MISS
PGDG 2.2.1
PGDG 2.2.1
PGDG 2.2.1
PGDG 2.2.1
d13.aarch64
MISS
PGDG 2.2.1
PGDG 2.2.1
PGDG 2.2.1
PGDG 2.2.1
u22.x86_64
MISS
PGDG 2.2.1
PGDG 2.2.1
PGDG 2.2.1
PGDG 2.2.1
u22.aarch64
MISS
PGDG 2.2.1
PGDG 2.2.1
PGDG 2.2.1
PGDG 2.2.1
u24.x86_64
MISS
PGDG 2.2.1
PGDG 2.2.1
PGDG 2.2.1
PGDG 2.2.1
u24.aarch64
MISS
PGDG 2.2.1
PGDG 2.2.1
PGDG 2.2.1
PGDG 2.2.1
Package Version OS ORG SIZE File URL
pgl_ddl_deploy_17 2.2.1 el8.x86_64 pgdg 39.6 KiB pgl_ddl_deploy_17-2.2.1-2PGDG.rhel8.x86_64.rpm
pgl_ddl_deploy_17 2.2.1 el8.aarch64 pgdg 39.7 KiB pgl_ddl_deploy_17-2.2.1-2PGDG.rhel8.aarch64.rpm
pgl_ddl_deploy_17 2.2.1 el9.x86_64 pgdg 38.2 KiB pgl_ddl_deploy_17-2.2.1-2PGDG.rhel9.x86_64.rpm
pgl_ddl_deploy_17 2.2.1 el9.aarch64 pgdg 38.2 KiB pgl_ddl_deploy_17-2.2.1-2PGDG.rhel9.aarch64.rpm
pgl_ddl_deploy_17 2.2.1 el10.x86_64 pgdg 38.4 KiB pgl_ddl_deploy_17-2.2.1-3PGDG.rhel10.x86_64.rpm
pgl_ddl_deploy_17 2.2.1 el10.aarch64 pgdg 38.7 KiB pgl_ddl_deploy_17-2.2.1-3PGDG.rhel10.aarch64.rpm
postgresql-17-pgl-ddl-deploy 2.2.1 d12.x86_64 pgdg 39.4 KiB postgresql-17-pgl-ddl-deploy_2.2.1-2.pgdg120+1_amd64.deb
postgresql-17-pgl-ddl-deploy 2.2.1 d12.aarch64 pgdg 39.8 KiB postgresql-17-pgl-ddl-deploy_2.2.1-2.pgdg120+1_arm64.deb
postgresql-17-pgl-ddl-deploy 2.2.1 d13.x86_64 pgdg 39.4 KiB postgresql-17-pgl-ddl-deploy_2.2.1-2.pgdg130+2_amd64.deb
postgresql-17-pgl-ddl-deploy 2.2.1 d13.aarch64 pgdg 39.9 KiB postgresql-17-pgl-ddl-deploy_2.2.1-2.pgdg130+2_arm64.deb
postgresql-17-pgl-ddl-deploy 2.2.1 u22.x86_64 pgdg 40.0 KiB postgresql-17-pgl-ddl-deploy_2.2.1-2.pgdg22.04+1_amd64.deb
postgresql-17-pgl-ddl-deploy 2.2.1 u22.aarch64 pgdg 40.0 KiB postgresql-17-pgl-ddl-deploy_2.2.1-2.pgdg22.04+1_arm64.deb
postgresql-17-pgl-ddl-deploy 2.2.1 u24.x86_64 pgdg 38.6 KiB postgresql-17-pgl-ddl-deploy_2.2.1-2.pgdg24.04+1_amd64.deb
postgresql-17-pgl-ddl-deploy 2.2.1 u24.aarch64 pgdg 38.9 KiB postgresql-17-pgl-ddl-deploy_2.2.1-2.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pgl_ddl_deploy_16 2.2.1 el8.x86_64 pgdg 39.6 KiB pgl_ddl_deploy_16-2.2.1-1PGDG.rhel8.x86_64.rpm
pgl_ddl_deploy_16 2.2.0 el8.x86_64 pgdg 39.4 KiB pgl_ddl_deploy_16-2.2.0-1PGDG.rhel8.x86_64.rpm
pgl_ddl_deploy_16 2.2.1 el8.aarch64 pgdg 39.6 KiB pgl_ddl_deploy_16-2.2.1-1PGDG.rhel8.aarch64.rpm
pgl_ddl_deploy_16 2.2.0 el8.aarch64 pgdg 39.4 KiB pgl_ddl_deploy_16-2.2.0-1PGDG.rhel8.aarch64.rpm
pgl_ddl_deploy_16 2.2.1 el9.x86_64 pgdg 38.1 KiB pgl_ddl_deploy_16-2.2.1-1PGDG.rhel9.x86_64.rpm
pgl_ddl_deploy_16 2.2.0 el9.x86_64 pgdg 37.7 KiB pgl_ddl_deploy_16-2.2.0-1PGDG.rhel9.x86_64.rpm
pgl_ddl_deploy_16 2.2.1 el9.aarch64 pgdg 38.1 KiB pgl_ddl_deploy_16-2.2.1-1PGDG.rhel9.aarch64.rpm
pgl_ddl_deploy_16 2.2.0 el9.aarch64 pgdg 37.6 KiB pgl_ddl_deploy_16-2.2.0-1PGDG.rhel9.aarch64.rpm
pgl_ddl_deploy_16 2.2.1 el10.x86_64 pgdg 38.4 KiB pgl_ddl_deploy_16-2.2.1-3PGDG.rhel10.x86_64.rpm
pgl_ddl_deploy_16 2.2.1 el10.aarch64 pgdg 38.7 KiB pgl_ddl_deploy_16-2.2.1-3PGDG.rhel10.aarch64.rpm
postgresql-16-pgl-ddl-deploy 2.2.1 d12.x86_64 pgdg 39.4 KiB postgresql-16-pgl-ddl-deploy_2.2.1-2.pgdg120+1_amd64.deb
postgresql-16-pgl-ddl-deploy 2.2.1 d12.aarch64 pgdg 39.8 KiB postgresql-16-pgl-ddl-deploy_2.2.1-2.pgdg120+1_arm64.deb
postgresql-16-pgl-ddl-deploy 2.2.1 d13.x86_64 pgdg 39.4 KiB postgresql-16-pgl-ddl-deploy_2.2.1-2.pgdg130+2_amd64.deb
postgresql-16-pgl-ddl-deploy 2.2.1 d13.aarch64 pgdg 39.9 KiB postgresql-16-pgl-ddl-deploy_2.2.1-2.pgdg130+2_arm64.deb
postgresql-16-pgl-ddl-deploy 2.2.1 u22.x86_64 pgdg 40.0 KiB postgresql-16-pgl-ddl-deploy_2.2.1-2.pgdg22.04+1_amd64.deb
postgresql-16-pgl-ddl-deploy 2.2.1 u22.aarch64 pgdg 40.0 KiB postgresql-16-pgl-ddl-deploy_2.2.1-2.pgdg22.04+1_arm64.deb
postgresql-16-pgl-ddl-deploy 2.2.1 u24.x86_64 pgdg 38.5 KiB postgresql-16-pgl-ddl-deploy_2.2.1-2.pgdg24.04+1_amd64.deb
postgresql-16-pgl-ddl-deploy 2.2.1 u24.aarch64 pgdg 38.9 KiB postgresql-16-pgl-ddl-deploy_2.2.1-2.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pgl_ddl_deploy_15 2.2.1 el8.x86_64 pgdg 39.5 KiB pgl_ddl_deploy_15-2.2.1-1PGDG.rhel8.x86_64.rpm
pgl_ddl_deploy_15 2.2.0 el8.x86_64 pgdg 39.3 KiB pgl_ddl_deploy_15-2.2.0-1PGDG.rhel8.x86_64.rpm
pgl_ddl_deploy_15 2.2.1 el8.aarch64 pgdg 39.5 KiB pgl_ddl_deploy_15-2.2.1-1PGDG.rhel8.aarch64.rpm
pgl_ddl_deploy_15 2.2.0 el8.aarch64 pgdg 39.3 KiB pgl_ddl_deploy_15-2.2.0-1PGDG.rhel8.aarch64.rpm
pgl_ddl_deploy_15 2.2.0 el9.x86_64 pgdg 37.6 KiB pgl_ddl_deploy_15-2.2.0-1PGDG.rhel9.x86_64.rpm
pgl_ddl_deploy_15 2.2.1 el9.aarch64 pgdg 38.0 KiB pgl_ddl_deploy_15-2.2.1-1PGDG.rhel9.aarch64.rpm
pgl_ddl_deploy_15 2.2.0 el9.aarch64 pgdg 37.5 KiB pgl_ddl_deploy_15-2.2.0-1PGDG.rhel9.aarch64.rpm
pgl_ddl_deploy_15 2.2.1 el10.x86_64 pgdg 38.3 KiB pgl_ddl_deploy_15-2.2.1-3PGDG.rhel10.x86_64.rpm
pgl_ddl_deploy_15 2.2.1 el10.aarch64 pgdg 38.6 KiB pgl_ddl_deploy_15-2.2.1-3PGDG.rhel10.aarch64.rpm
postgresql-15-pgl-ddl-deploy 2.2.1 d12.x86_64 pgdg 39.0 KiB postgresql-15-pgl-ddl-deploy_2.2.1-2.pgdg120+1_amd64.deb
postgresql-15-pgl-ddl-deploy 2.2.1 d12.aarch64 pgdg 39.4 KiB postgresql-15-pgl-ddl-deploy_2.2.1-2.pgdg120+1_arm64.deb
postgresql-15-pgl-ddl-deploy 2.2.1 d13.x86_64 pgdg 39.0 KiB postgresql-15-pgl-ddl-deploy_2.2.1-2.pgdg130+2_amd64.deb
postgresql-15-pgl-ddl-deploy 2.2.1 d13.aarch64 pgdg 39.4 KiB postgresql-15-pgl-ddl-deploy_2.2.1-2.pgdg130+2_arm64.deb
postgresql-15-pgl-ddl-deploy 2.2.1 u22.x86_64 pgdg 39.6 KiB postgresql-15-pgl-ddl-deploy_2.2.1-2.pgdg22.04+1_amd64.deb
postgresql-15-pgl-ddl-deploy 2.2.1 u22.aarch64 pgdg 39.5 KiB postgresql-15-pgl-ddl-deploy_2.2.1-2.pgdg22.04+1_arm64.deb
postgresql-15-pgl-ddl-deploy 2.2.1 u24.x86_64 pgdg 38.3 KiB postgresql-15-pgl-ddl-deploy_2.2.1-2.pgdg24.04+1_amd64.deb
postgresql-15-pgl-ddl-deploy 2.2.1 u24.aarch64 pgdg 38.6 KiB postgresql-15-pgl-ddl-deploy_2.2.1-2.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pgl_ddl_deploy_14 2.2.1 el8.x86_64 pgdg 39.5 KiB pgl_ddl_deploy_14-2.2.1-1PGDG.rhel8.x86_64.rpm
pgl_ddl_deploy_14 2.2.0 el8.x86_64 pgdg 39.3 KiB pgl_ddl_deploy_14-2.2.0-1PGDG.rhel8.x86_64.rpm
pgl_ddl_deploy_14 2.2.1 el8.aarch64 pgdg 39.5 KiB pgl_ddl_deploy_14-2.2.1-1PGDG.rhel8.aarch64.rpm
pgl_ddl_deploy_14 2.2.0 el8.aarch64 pgdg 39.3 KiB pgl_ddl_deploy_14-2.2.0-1PGDG.rhel8.aarch64.rpm
pgl_ddl_deploy_14 2.2.0 el9.x86_64 pgdg 37.6 KiB pgl_ddl_deploy_14-2.2.0-1PGDG.rhel9.x86_64.rpm
pgl_ddl_deploy_14 2.2.1 el9.aarch64 pgdg 38.0 KiB pgl_ddl_deploy_14-2.2.1-1PGDG.rhel9.aarch64.rpm
pgl_ddl_deploy_14 2.2.0 el9.aarch64 pgdg 37.5 KiB pgl_ddl_deploy_14-2.2.0-1PGDG.rhel9.aarch64.rpm
pgl_ddl_deploy_14 2.2.1 el10.x86_64 pgdg 38.3 KiB pgl_ddl_deploy_14-2.2.1-3PGDG.rhel10.x86_64.rpm
pgl_ddl_deploy_14 2.2.1 el10.aarch64 pgdg 38.6 KiB pgl_ddl_deploy_14-2.2.1-3PGDG.rhel10.aarch64.rpm
postgresql-14-pgl-ddl-deploy 2.2.1 d12.x86_64 pgdg 39.0 KiB postgresql-14-pgl-ddl-deploy_2.2.1-2.pgdg120+1_amd64.deb
postgresql-14-pgl-ddl-deploy 2.2.1 d12.aarch64 pgdg 39.4 KiB postgresql-14-pgl-ddl-deploy_2.2.1-2.pgdg120+1_arm64.deb
postgresql-14-pgl-ddl-deploy 2.2.1 d13.x86_64 pgdg 38.9 KiB postgresql-14-pgl-ddl-deploy_2.2.1-2.pgdg130+2_amd64.deb
postgresql-14-pgl-ddl-deploy 2.2.1 d13.aarch64 pgdg 39.4 KiB postgresql-14-pgl-ddl-deploy_2.2.1-2.pgdg130+2_arm64.deb
postgresql-14-pgl-ddl-deploy 2.2.1 u22.x86_64 pgdg 39.6 KiB postgresql-14-pgl-ddl-deploy_2.2.1-2.pgdg22.04+1_amd64.deb
postgresql-14-pgl-ddl-deploy 2.2.1 u22.aarch64 pgdg 39.5 KiB postgresql-14-pgl-ddl-deploy_2.2.1-2.pgdg22.04+1_arm64.deb
postgresql-14-pgl-ddl-deploy 2.2.1 u24.x86_64 pgdg 38.3 KiB postgresql-14-pgl-ddl-deploy_2.2.1-2.pgdg24.04+1_amd64.deb
postgresql-14-pgl-ddl-deploy 2.2.1 u24.aarch64 pgdg 38.6 KiB postgresql-14-pgl-ddl-deploy_2.2.1-2.pgdg24.04+1_arm64.deb

Source

Repository
github.com/enova/pgl_ddl_deploy

Install

Make sure PGDG repo available:

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

Install this extension with pig:

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

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

Create this extension with:

CREATE EXTENSION pgl_ddl_deploy CASCADE; -- requires pglogical
Last updated on
pglogical_tickerpg_failover_slots