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
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
13
 pgl_ddl_deploy -
RPM
PGDG
 2.2.1
18
17
16
15
14
13
 pgl_ddl_deploy_$v* pglogical_$v
DEB
PGDG
 2.2.1
18
17
16
15
14
13
 postgresql-$v-pgl-ddl-deploy postgresql-$v-pglogical
Linux / PG PG18 PG17 PG16 PG15 PG14 PG13
el8.x86_64
MISS
PGDG 2.2.1
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
PGDG 2.2.1
el9.x86_64
MISS
PGDG 2.2.1
PGDG 2.2.1
PGDG 2.2.0
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
PGDG 2.2.1
el10.x86_64
MISS
PGDG 2.2.1
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
PGDG 2.2.1
d12.x86_64
MISS
PGDG 2.2.1
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
PGDG 2.2.1
d13.x86_64
MISS
PGDG 2.2.1
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
PGDG 2.2.1
u22.x86_64
MISS
PGDG 2.2.1
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
PGDG 2.2.1
u24.x86_64
MISS
PGDG 2.2.1
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
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
Package Version OS ORG SIZE File URL
pgl_ddl_deploy_13 2.2.1 el8.x86_64 pgdg 39.4 KiB pgl_ddl_deploy_13-2.2.1-1PGDG.rhel8.x86_64.rpm
pgl_ddl_deploy_13 2.2.0 el8.x86_64 pgdg 39.2 KiB pgl_ddl_deploy_13-2.2.0-1PGDG.rhel8.x86_64.rpm
pgl_ddl_deploy_13 2.2.1 el8.aarch64 pgdg 39.5 KiB pgl_ddl_deploy_13-2.2.1-1PGDG.rhel8.aarch64.rpm
pgl_ddl_deploy_13 2.2.0 el8.aarch64 pgdg 39.4 KiB pgl_ddl_deploy_13-2.2.0-1PGDG.rhel8.aarch64.rpm
pgl_ddl_deploy_13 2.2.0 el9.x86_64 pgdg 37.6 KiB pgl_ddl_deploy_13-2.2.0-1PGDG.rhel9.x86_64.rpm
pgl_ddl_deploy_13 2.2.1 el9.aarch64 pgdg 38.0 KiB pgl_ddl_deploy_13-2.2.1-1PGDG.rhel9.aarch64.rpm
pgl_ddl_deploy_13 2.2.0 el9.aarch64 pgdg 37.5 KiB pgl_ddl_deploy_13-2.2.0-1PGDG.rhel9.aarch64.rpm
pgl_ddl_deploy_13 2.2.1 el10.x86_64 pgdg 38.3 KiB pgl_ddl_deploy_13-2.2.1-3PGDG.rhel10.x86_64.rpm
pgl_ddl_deploy_13 2.2.1 el10.aarch64 pgdg 38.6 KiB pgl_ddl_deploy_13-2.2.1-3PGDG.rhel10.aarch64.rpm
postgresql-13-pgl-ddl-deploy 2.2.1 d12.x86_64 pgdg 38.7 KiB postgresql-13-pgl-ddl-deploy_2.2.1-2.pgdg120+1_amd64.deb
postgresql-13-pgl-ddl-deploy 2.2.1 d12.aarch64 pgdg 39.0 KiB postgresql-13-pgl-ddl-deploy_2.2.1-2.pgdg120+1_arm64.deb
postgresql-13-pgl-ddl-deploy 2.2.1 d13.x86_64 pgdg 38.7 KiB postgresql-13-pgl-ddl-deploy_2.2.1-2.pgdg130+2_amd64.deb
postgresql-13-pgl-ddl-deploy 2.2.1 d13.aarch64 pgdg 39.0 KiB postgresql-13-pgl-ddl-deploy_2.2.1-2.pgdg130+2_arm64.deb
postgresql-13-pgl-ddl-deploy 2.2.1 u22.x86_64 pgdg 39.4 KiB postgresql-13-pgl-ddl-deploy_2.2.1-2.pgdg22.04+1_amd64.deb
postgresql-13-pgl-ddl-deploy 2.2.1 u22.aarch64 pgdg 39.1 KiB postgresql-13-pgl-ddl-deploy_2.2.1-2.pgdg22.04+1_arm64.deb
postgresql-13-pgl-ddl-deploy 2.2.1 u24.x86_64 pgdg 38.1 KiB postgresql-13-pgl-ddl-deploy_2.2.1-2.pgdg24.04+1_amd64.deb
postgresql-13-pgl-ddl-deploy 2.2.1 u24.aarch64 pgdg 38.2 KiB postgresql-13-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
pig install pgl_ddl_deploy -v 13;   # install for PG 13

Create this extension with:

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