pglogical_ticker

pig build pkg pglogical_ticker;		# build rpm/deb

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

pig install pglogical_ticker;		# install via package name, for the active PG version

pig install pglogical_ticker -v 18;   # install for PG 18
pig install pglogical_ticker -v 17;   # install for PG 17
pig install pglogical_ticker -v 16;   # install for PG 16
pig install pglogical_ticker -v 15;   # install for PG 15
pig install pglogical_ticker -v 14;   # install for PG 14

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();