citusdata/pg_cron

View on GitHub

Run periodic jobs in PostgreSQL

Stars: 3.9k
Forks: 260
Open beginner issues: 0
Indexed issues: 128
Avg merge: 5d 5h
Merged PRs (30d): 1

Dominant language: C
License: PostgreSQL
Last GitHub push: Sep 8, 2026
Latest indexed: Sep 15, 2026
Contributing guide: No contributing guide
Code of conduct: No code of conduct
Beginner labels: No beginner labels indexed

Open All

128 open issues indexed

Make it available (again) on PGXN Open

citusdata/pg_cron#212 · 1 comment · 3 reactions · 0 assignees · Indexed Sep 15, 2026
When hour field is set, then rule does not run Open

citusdata/pg_cron#216 · 4 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Support using custom schema when creating extension Open

citusdata/pg_cron#225 · 3 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Add function to run cron job manually Open

citusdata/pg_cron#226 · 3 comments · 6 reactions · 0 assignees · Indexed Sep 15, 2026
Could not run unschedule Open

citusdata/pg_cron#227 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
pg_cron 1.5.0 cannot be found with postgresql v15 setup Open

citusdata/pg_cron#237 · 3 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
cron.timezone Does Nothing Open

citusdata/pg_cron#238 · 3 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
pg_cron partly jobs not running without any logs on job_run_details table. Open

citusdata/pg_cron#240 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
CALL running slower via cron job Open

citusdata/pg_cron#245 · 2 comments · 1 reaction · 0 assignees · Indexed Sep 15, 2026
[Feature Request] Add a function to stop a running job Open

citusdata/pg_cron#247 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
pg_cron on Aurora cluster strange output Open

citusdata/pg_cron#248 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
cron jobs do nor work at scheduled time and can not create a new job Open

citusdata/pg_cron#249 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Job scheduled to run every minute not running every minute Open

citusdata/pg_cron#251 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Scheduling more than two jobs, starts failing with "job startup timeout" Open

citusdata/pg_cron#253 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
invalid message size 327696859971 in shared memory queue Open

citusdata/pg_cron#257 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
alter_job should allow to change own jobs Open

citusdata/pg_cron#258 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
cron.job_run_details is still empty Open

citusdata/pg_cron#259 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
PG_Cron Container Scope of depended job Open

citusdata/pg_cron#260 · 1 comment · 1 reaction · 0 assignees · Indexed Sep 15, 2026
Get the next date from a cron string Open

citusdata/pg_cron#261 · 2 comments · 1 reaction · 0 assignees · Indexed Sep 15, 2026
`ALTER EXTENSION UPDATE` and `pg_cron launcher` blocked each other, none of the backends proceed Open

citusdata/pg_cron#264 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
pg_cron cannot be compiled against Postgres 1.5 Open

citusdata/pg_cron#269 · 3 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
pg_cron logs many errors when default_transaction_read_only on Open

enhancement

citusdata/pg_cron#270 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 15, 2026
docker postgres:16beta1-alpine : src/job_metadata.c:1526:24: error: declaration of 'schedule' shadows a previous local [-Werror=shadow=compatible-local] Open

citusdata/pg_cron#272 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Hard pg_cron 1.5+ dependency on pg_catalog breaks restores of dumps created when using older extension versions Open

citusdata/pg_cron#274 · 17 comments · 12 reactions · 0 assignees · Indexed Sep 15, 2026
startup timeout after a certain amount of simultaneous jobs Open

citusdata/pg_cron#282 · 4 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Jobs seems to be stacking up of the previous job is still running. How large can this get before thing go bad? Open

citusdata/pg_cron#300 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
How can I activate the pg_cron scheduler session? Open

citusdata/pg_cron#302 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
connection failed with schedule_in_database Open

citusdata/pg_cron#303 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Problem when installing pg_cron. Can you help me fix my Dockerfile? Open

citusdata/pg_cron#304 · 4 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Pg cron fails to create schema for extension to properly work on the db Open

citusdata/pg_cron#306 · 3 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
pg_cron schedule runs 1 day in advance in AWS Aurora Postgres Open

citusdata/pg_cron#307 · 3 comments · 4 reactions · 0 assignees · Indexed Sep 15, 2026
Feature request: unschedule job without cancelling running jobs Open

citusdata/pg_cron#308 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Cant install Open

citusdata/pg_cron#309 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
".../pg_cron.control": No such file or directory Open

citusdata/pg_cron#312 · 1 comment · 2 reactions · 0 assignees · Indexed Sep 15, 2026
Enable pg_cron in distributed PostgreSQL system Open

citusdata/pg_cron#313 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Read `cron.database_name` from environment variables (`$PGDATABASE`) Open

citusdata/pg_cron#314 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Azure Postgres Job Table Permissions Open

citusdata/pg_cron#316 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
API inconsistency: `cron.unschedule(jobid)` can unschedule jobs of another user but `cron.unschedule(jobname)` cannot Open

citusdata/pg_cron#320 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
on Google Cloud Platform Cloud SQL pg_cron is not working on monthly and weekly schedule Open

citusdata/pg_cron#325 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
cron job doesn't running as expected Open

citusdata/pg_cron#327 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Can not be compiled. Open

citusdata/pg_cron#328 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Leap year scheduling problem Open

citusdata/pg_cron#329 · 16 comments · 5 reactions · 0 assignees · Indexed Sep 15, 2026
[BUG] setting search_path causes error Open

citusdata/pg_cron#333 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
unschedule can not specify user name Open

citusdata/pg_cron#335 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Is there any way to pass the job runid to the SQL command? Open

citusdata/pg_cron#336 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Is it possible to schedule pg_dump using pg_cron? Open

citusdata/pg_cron#338 · 4 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Segmentation fault error in version 1.6 Open

bug

citusdata/pg_cron#340 · 9 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
An undocumented behavior with years in Cron expressions Open

citusdata/pg_cron#341 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Add a next_runtime function Open

citusdata/pg_cron#343 · 5 comments · 1 reaction · 0 assignees · Indexed Sep 15, 2026
executing multiple statements in one job but logging only first statement's output Open

citusdata/pg_cron#349 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026

citusdata/pg_cron

Get new issues in your inbox