pgl_ddl_deploy

pig repo add pgdg -u          # 添加 PGDG 仓库并更新缓存

CREATE EXTENSION pgl_ddl_deploy CASCADE;  -- 依赖: pglogical

CREATE EXTENSION pgl_ddl_deploy;

-- 复制所有用户模式的 DDL 并自动添加新表
INSERT INTO pgl_ddl_deploy.set_configs (set_name, include_schema_regex, driver)
VALUES ('default', '.*', 'native'::pgl_ddl_deploy.driver);

-- 或使用 pglogical 驱动
INSERT INTO pgl_ddl_deploy.set_configs (set_name, include_schema_regex, driver)
VALUES ('default', '.*', 'pglogical'::pgl_ddl_deploy.driver);

-- 仅维护已在复制中的特定表（仅 ALTER TABLE）
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;

-- 查看未处理的 DDL 事件
SELECT * FROM pgl_ddl_deploy.unhandled;

-- 查看订阅者失败的 DDL
SELECT * FROM pgl_ddl_deploy.subscriber_logs WHERE NOT succeeded;

-- 在订阅者上重试失败的 DDL
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;