pgl_ddl_deploy

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

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 EXTENSION pgl_ddl_deploy CASCADE; -- requires pglogical

CREATE EXTENSION pgl_ddl_deploy;

-- Replicate DDL for all user schemas and auto-add new tables
INSERT INTO pgl_ddl_deploy.set_configs (set_name, include_schema_regex, driver)
VALUES ('default', '.*', 'native'::pgl_ddl_deploy.driver);

-- Or with pglogical driver
INSERT INTO pgl_ddl_deploy.set_configs (set_name, include_schema_regex, driver)
VALUES ('default', '.*', 'pglogical'::pgl_ddl_deploy.driver);

-- Maintain only specific tables already in replication (ALTER TABLE only)
INSERT INTO pgl_ddl_deploy.set_configs (set_name, include_only_repset_tables, driver)
VALUES ('my_tables', TRUE, 'native'::pgl_ddl_deploy.driver);

SELECT pgl_ddl_deploy.deploy(set_config_id) FROM pgl_ddl_deploy.set_configs;

-- View unhandled DDL events
SELECT * FROM pgl_ddl_deploy.unhandled;

-- View failed subscriber DDL
SELECT * FROM pgl_ddl_deploy.subscriber_logs WHERE NOT succeeded;

-- Retry failed DDL on subscriber
SELECT pgl_ddl_deploy.retry_all_subscriber_logs();

SELECT pgl_ddl_deploy.resolved_regex_include_schemas(set_config_id)
FROM pgl_ddl_deploy.set_configs;