citusdata / citusdata/pg_cron

Any Reason why there can only be one job table inside schema cron on postgres or configured?

Open
#36 6 comments 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
3.9k
Forks
260
Avg merge
5d 5h
Merged PRs (30d)
1

Description

Hello I'm actually quite loving the pg_cron extensions, it allows for small users a really simple mechanism to create High Available Cron Jobs.

However managing these are quite a bit painful.
Is there any reason why the metadata tables is expected to be a single one?

Isn't there a way to actually do `CREATE EXTENSION pg_cron;` and it would be possible to select all the jobs of the current user, schedule/unschedule them?

Currently we use jdbc and if we don't want to open up a second connection to the postgres database, we would need to reconfigure the cron extension everywhere (well sadly we need to configure `shared_preload_libraries` anyway...).
this looks a little bit of an overhead, especially since we want to still use our flyway migrations to insert new cron jobs.
Is there any "best practice"/no-go on what's the best way to integrate pg_cron inside an application?

(At the moment we actually have a single cron.schedule that calls
`SELECT pg_notify('our_channel', '{"type": "nightly"}')`. Which we registerted with `cron.schedule` and then updated the cron.job database column.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.