pglogical_ticker

pig build pkg pglogical_ticker         # build RPM / DEB packages

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

shared_preload_libraries = 'pglogical, pglogical_ticker';

CREATE EXTENSION pglogical_ticker CASCADE;  -- requires: pglogical

shared_preload_libraries = 'pglogical,pglogical_ticker'
pglogical_ticker.database = 'mydb'
pglogical_ticker.naptime = 10      -- tick interval in seconds (default 10)

CREATE EXTENSION pglogical_ticker;

-- Deploy ticker tables (one per replication set)
SELECT pglogical_ticker.deploy_ticker_tables();

-- Add ticker tables to replication
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();

-- Or, only launch if replication set tables exist
SELECT pglogical_ticker.launch_if_repset_tables();

SELECT * FROM pglogical_ticker.all_repset_tickers();

SELECT * FROM pglogical_ticker.all_subscription_tickers();