pg_cron

• citusdata/pg_cron

提示

• 默认元数据表位于 postgres 库 - 只有在给定库才可以 CREATE EXTENSION
  • schema 为 cron

shared_preload_libraries = 'pg_cron'
cron.database_name = 'postgres'

SELECT cron.schedule('nightly-vacuum', '0 3 * * *', 'VACUUM');
SELECT cron.unschedule('nightly-vacuum' );

-- 直接跨库操作
INSERT INTO cron.job (schedule, command, nodename, nodeport, database, username)
VALUES ('*/1 * * * *', '
DO $$
BEGIN
    delete from table_one;
    delete from table_two;
    delete from table_three;
END;
$$;',
        '/run/postgresql', 5432, 'my_dataabse', 'postgres');