pgl_ddl_deploy

Overview

PGDG 1st Party Extension: pgl_ddl_deploy : automated ddl deployment using pglogical

Information

• Extension ID: 9520
• Extension Name: pgl_ddl_deploy
• Package Name: pgl_ddl_deploy
• Category: ETL
• License: MIT
• Website: https://github.com/enova/pgl_ddl_deploy
• Language: C
• Extra Tags: N/A
• Comment: N/A

Metadata

• Latest Version: 2.2.1
• Postgres Support: 17,16,15,14,13
• Need Load: Shared library do not need explicit loading
• Need DDL: Need CREATE EXTENSION DDL
• Relocatable: Unknown
• Trusted: Untrusted, Require Superuser to Create
• Schemas: pgl_ddl_deploy
• Requires: pglogical

RPM / DEB

• RPM Repo: PGDG
• RPM Name: pgl_ddl_deploy_$v*
• RPM Ver : 2.2.1
• RPM Deps: pglogical_$v
• DEB Repo: PGDG
• DEB Name: postgresql-$v-pgl-ddl-deploy
• DEB Ver : 2.2.1
• DEB Deps: postgresql-$v-pglogical

Availability

Installation

Install pgl_ddl_deploy via the pig CLI tool:

pig ext install pgl_ddl_deploy

Install pgl_ddl_deploy via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgl_ddl_deploy"]}' # -l <cls>

Install pgl_ddl_deploy RPM from YUM repo directly:

dnf install pgl_ddl_deploy_17*;
dnf install pgl_ddl_deploy_16*;
dnf install pgl_ddl_deploy_15*;
dnf install pgl_ddl_deploy_14*;
dnf install pgl_ddl_deploy_13*;

Install pgl_ddl_deploy DEB from APT repo directly:

apt install postgresql-17-pgl-ddl-deploy;
apt install postgresql-16-pgl-ddl-deploy;
apt install postgresql-15-pgl-ddl-deploy;
apt install postgresql-14-pgl-ddl-deploy;
apt install postgresql-13-pgl-ddl-deploy;

Create pgl_ddl_deploy extension on PostgreSQL cluster:

CREATE EXTENSION pgl_ddl_deploy CASCADE;