pglogical_ticker

pig build pkg pglogical_ticker         # 构建 RPM / DEB 包

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

shared_preload_libraries = 'pglogical, pglogical_ticker';

CREATE EXTENSION pglogical_ticker CASCADE;  -- 依赖: pglogical

shared_preload_libraries = 'pglogical,pglogical_ticker'
pglogical_ticker.database = 'mydb'
pglogical_ticker.naptime = 10      -- tick 间隔（秒，默认 10）

CREATE EXTENSION pglogical_ticker;

-- 部署 ticker 表（每个复制集一个）
SELECT pglogical_ticker.deploy_ticker_tables();

-- 将 ticker 表添加到复制
SELECT pglogical_ticker.add_ticker_tables_to_replication();

SELECT pglogical_ticker.deploy_ticker_tables('my_cascaded_set_name');
SELECT pglogical_ticker.add_ticker_tables_to_replication('my_cascaded_set_name');

SELECT pglogical_ticker.tick();

SELECT pglogical_ticker.launch();

-- 或者，仅在复制集表存在时启动
SELECT pglogical_ticker.launch_if_repset_tables();

SELECT * FROM pglogical_ticker.all_repset_tickers();

SELECT * FROM pglogical_ticker.all_subscription_tickers();