Enable pg_cron in distributed PostgreSQL system

[cwang9208]

Hi, we are trying to deploy the pg_cron extension in Postgresql-xl, which is a distributed version of Postgresql. The question is how can we ensure there is only one scheduler running? Are there any suggestions?

[marcoslot]

As long as the cron.jobs table is local to a specific node, then jobs would only run on that node. That's the case in Citus at least.