pgl_ddl_deploy
automated ddl deployment using pglogical
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 logical_ddl spock pgactive mimeo pgoutput lolor |
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 | PIGSTY 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 |
| el8.aarch64 | PIGSTY 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 |
| el9.x86_64 | PIGSTY 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 |
| el9.aarch64 | PIGSTY 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 |
| el10.x86_64 | PIGSTY 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 |
| el10.aarch64 | PIGSTY 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 |
| d12.x86_64 | PIGSTY 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 |
| d12.aarch64 | PIGSTY 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 |
| d13.x86_64 | PIGSTY 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 |
| d13.aarch64 | PIGSTY 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 |
| u22.x86_64 | PIGSTY 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 |
| u22.aarch64 | PIGSTY 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 |
| u24.x86_64 | PIGSTY 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 |
| u24.aarch64 | PIGSTY 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 | PGDG 2.2.1 |
| u26.x86_64 | PIGSTY 2.2.1 | PIGSTY 2.2.1 | PIGSTY 2.2.1 | PIGSTY 2.2.1 | PIGSTY 2.2.1 |
| u26.aarch64 | PIGSTY 2.2.1 | PIGSTY 2.2.1 | PIGSTY 2.2.1 | PIGSTY 2.2.1 | PIGSTY 2.2.1 |
Source
github.com/enova/pgl_ddl_deploy
Install
Make sure PGDG repo available:
Install this extension with pig:
Create this extension with:
Usage
Transparent DDL replication for PostgreSQL 9.5+ supporting both pglogical and native logical replication. Automatically propagates DDL changes (CREATE TABLE, ALTER TABLE, etc.) to subscribers.
Enabling
Configuration
Insert configuration into the pgl_ddl_deploy.set_configs table:
Deploy Event Triggers
After configuring, deploy the event triggers:
Key Configuration Options
driver:nativeorpglogicalset_name: publication name or pglogical replication set nameinclude_schema_regex: regex to match schemas for DDL replicationinclude_only_repset_tables: if true, only ALTER TABLE for tables already in replicationlock_safe_deployment: if true, DDL executes in a low lock_timeout loop on subscriberallow_multi_statements: if true, multi-statement DDL can be propagatedqueue_subscriber_failures: if true, failed DDL on subscriber is queued for retryddl_only_replication: replicate schema only without auto-adding tables to data replication