citusdata/pg_cron issues and pull requests

#363 - Fix maybe-uninitialized compile warn.

Pull Request - State: open - Opened by reshke 10 days ago

#362 - Job scheduled form another cron job does not always start

Issue - State: open - Opened by juvies 21 days ago - 1 comment

#361 - How to execute cron in database other than postgres

Issue - State: open - Opened by bhanotjyoti 27 days ago - 1 comment

#360 - pg_cron executes job outside of specified schedule

Issue - State: closed - Opened by ethan-blaze about 1 month ago

#359 - Does the PG_CRON support PG 17 major version?

Issue - State: open - Opened by jasonchenTJ about 2 months ago - 2 comments

#358 - schedule_in_database function wastes sequence values

Issue - State: open - Opened by caseyandgina 2 months ago

#357 - cron scheduling

Issue - State: open - Opened by ramkly 2 months ago - 1 comment

#356 - Add break in CRON_TASK_WAITING switch case.

Pull Request - State: closed - Opened by zxwsbg 2 months ago

#355 - How to delay by N seconds

Issue - State: open - Opened by mozeryansky 3 months ago - 4 comments

#354 - Cron jobs halted and not logged to cron.job_run_details during demanding and long running job.

Issue - State: open - Opened by Strijdhagen 3 months ago

#353 - pg_read_all_data cannot read cron.job table

Issue - State: closed - Opened by JamesInform 3 months ago - 1 comment

#352 - Unable to stop pg_cron scheduler

Issue - State: open - Opened by serpent7776 3 months ago - 2 comments

#351 - OpenBSD crond / crontab set_range() heap underflow (CVE-2024-43688)

Issue - State: closed - Opened by df7cb 3 months ago - 3 comments

#350 - pg_cron writing every client_min_messages to log file

Issue - State: open - Opened by bernardo-bc 3 months ago - 7 comments

#349 - executing multiple statements in one job but logging only first statement's output

Issue - State: open - Opened by bsislow 3 months ago

#348 - Updated readme to show that Instaclustr now supports pg_cron

Pull Request - State: closed - Opened by Chrismelba-Instaclustr 4 months ago

#347 - Select procedure based on argument type of cron_unschedule_named

Pull Request - State: closed - Opened by CyberDem0n 4 months ago

#346 - Fix bug with invalidation of CachedCronJobRelationId

Pull Request - State: closed - Opened by CyberDem0n 4 months ago - 1 comment

#345 - Do not cache CronJobRelationId in job unschedule functions

Pull Request - State: closed - Opened by hari90 4 months ago - 2 comments

#344 - unschedule fails if extension is dropped and recreated between calls

Issue - State: closed - Opened by hari90 4 months ago - 1 comment

#343 - [New Feature]

Issue - State: open - Opened by melquelima 4 months ago - 4 comments

#342 - Misleading start times in pg_cron 1.6.3

Issue - State: closed - Opened by esiaero 4 months ago - 2 comments
Labels: bug

#341 - An undocumented behavior with years in Cron expressions

Issue - State: open - Opened by sanchezcarlosjr 4 months ago - 1 comment

#340 - Segmentation fault error in version 1.6

Issue - State: open - Opened by slothyrulez 4 months ago - 8 comments
Labels: bug

#339 - PostgreSQL 17 support

Issue - State: closed - Opened by devrimgunduz 4 months ago - 1 comment

#338 - Is it possible to schedule pg_dump using pg_cron?

Issue - State: open - Opened by ploef 5 months ago - 2 comments

#337 - 请问我是PG数据库14.7 版本，我应该用pg_cron那个版本？May I ask which version of pg_cron should I use for PG database version 14.7?

Issue - State: open - Opened by MyGit-Z 5 months ago

#336 - Is there any way to pass the job runid to the SQL command?

Issue - State: open - Opened by nickhandel 5 months ago

#335 - unschedule can not specify user name

Issue - State: open - Opened by josehu-t 5 months ago

#334 - confirmation that pg_cron only runs on one database per server

Issue - State: closed - Opened by chrislungu 5 months ago - 2 comments

#333 - [BUG] setting search_path causes error

Issue - State: open - Opened by cwang9208 6 months ago - 1 comment

#332 - Replace MemoryContextResetAndDeleteChildren macro with MemoryContextReset for PG 17 compatibility

Pull Request - State: closed - Opened by esiaero 6 months ago - 1 comment

#331 - Make it easier to find the query to see all scheduled jobs

Pull Request - State: closed - Opened by ryw 6 months ago - 1 comment

#330 - Add YugabyteDB to list of supported services

Pull Request - State: closed - Opened by hari90 6 months ago - 3 comments

#329 - Leap year scheduling problem

Issue - State: open - Opened by marcocicalaacn 6 months ago - 4 comments

#328 - Can not be compiled.

Issue - State: open - Opened by ld1978 7 months ago

#327 - cron job doesn't running as expected

Issue - State: open - Opened by rudonx 7 months ago - 1 comment

#326 - Fixes #311

Pull Request - State: closed - Opened by sminux 7 months ago - 1 comment

#325 - on Google Cloud Platform Cloud SQL pg_cron is not working on monthly and weekly schedule

Issue - State: open - Opened by paolocastle 7 months ago

#324 - Log start & end time for all failed runs

Pull Request - State: closed - Opened by kketch 7 months ago - 1 comment

#323 - installation on windows

Issue - State: open - Opened by Mohammad-Safaie-1999 7 months ago - 1 comment

#322 - ERROR: could not find function "cron_schedule_named" in file "/usr/lib/postgresql/X.X/lib/pg_cron.so"

Issue - State: closed - Opened by ognyanist 7 months ago - 1 comment

#321 - connection failed

Issue - State: closed - Opened by tranicus 7 months ago - 1 comment

#320 - API inconsistency: `cron.unschedule(jobid)` can unschedule jobs of another user but `cron.unschedule(jobname)` cannot

Issue - State: open - Opened by Ngalstyan4 7 months ago

#319 - Allow interrupts in pg_cron launcher loop to avoid deadlock

Pull Request - State: closed - Opened by Ngalstyan4 8 months ago

#318 - Unable to drop a database when there is an active cron job

Issue - State: closed - Opened by Ngalstyan4 8 months ago

#317 - Fix compiler error on Illumos

Pull Request - State: closed - Opened by japinli 8 months ago - 3 comments

#316 - Azure Postgres Job Table Permissions

Issue - State: open - Opened by tcartwright 8 months ago - 1 comment

#315 - Default value for cron.host

Issue - State: closed - Opened by sjmiller609 9 months ago - 1 comment

#314 - Read `cron.database_name` from environment variables (`$PGDATABASE`)

Issue - State: open - Opened by sepsol 9 months ago

#313 - Enable pg_cron in distributed PostgreSQL system

Issue - State: open - Opened by cwang9208 9 months ago - 1 comment

#312 - ".../pg_cron.control": No such file or directory

Issue - State: open - Opened by illiasokolov 9 months ago - 1 comment

#311 - Possible oveflow

Issue - State: closed - Opened by Bbulatov 10 months ago

#310 - Add Tembo to list of managed clouds

Pull Request - State: closed - Opened by ryw 10 months ago

#309 - Cant install

Issue - State: open - Opened by DavidBuch1 10 months ago - 1 comment

#308 - Feature request: unschedule job without cancelling running jobs

Issue - State: open - Opened by ThomasHeijtink 10 months ago

#307 - pg_cron schedule runs 1 day in advance in AWS Aurora Postgres

Issue - State: open - Opened by hoonjoo 10 months ago - 3 comments

#306 - Pg cron fails to create schema for extension to properly work on the db

Issue - State: open - Opened by windmillcode0 10 months ago - 3 comments

#305 - Trouble adding more than 5 cron jobs...

Issue - State: closed - Opened by ssoper-usgs 10 months ago - 2 comments

#304 - Problem when installing pg_cron. Can you help me fix my Dockerfile?

Issue - State: open - Opened by ember11498 11 months ago - 4 comments

#303 - connection failed with schedule_in_database

Issue - State: open - Opened by erichanson 11 months ago - 1 comment

#302 - How can I activate the pg_cron scheduler session?

Issue - State: open - Opened by abdullahergin 11 months ago

#301 - Only substring of `schedule` passed to `cron.schedule` saved to `jobname` column

Issue - State: closed - Opened by iamchubko 11 months ago - 1 comment

#300 - Jobs seems to be stacking up of the previous job is still running. How large can this get before thing go bad?

Issue - State: open - Opened by anderssjoblom-vertex 11 months ago - 1 comment

#299 - Make cron_unschedule_named() accept v1.4 SQL signature.

Pull Request - State: closed - Opened by nmisch 11 months ago - 1 comment

#298 - nothing

Issue - State: closed - Opened by wzbnb001 11 months ago

#297 - tables not getting created in database during CREATE EXTENSION pg_cron;

Issue - State: closed - Opened by tamarmot 12 months ago - 1 comment

#296 - Queue clarification

Issue - State: closed - Opened by meyerovb 12 months ago - 1 comment

#295 - Remove CacheInvalidateRelcacheByTuple and put CronJobCacheValid in shmem

Pull Request - State: closed - Opened by fanfuxiaoran 12 months ago - 3 comments

#294 - Installing pg_cron 1.6 (pg_cron_16 package) on postgresql-16 but extension version showing as 1.5

Issue - State: closed - Opened by lalitvc about 1 year ago - 1 comment

#293 - Update the database when scheduling an existing job

Pull Request - State: closed - Opened by nuno-faria about 1 year ago

#292 - Fix pointer reuse bug causing off-by-1 day of month

Pull Request - State: closed - Opened by marcoslot about 1 year ago - 1 comment

#291 - Qualify function call in migration script

Pull Request - State: closed - Opened by hanefi about 1 year ago

#290 - Schedule running the day before

Issue - State: closed - Opened by elkejava about 1 year ago - 9 comments

#289 - Remove hard dependency on creation in the `pg_catalog` schema

Pull Request - State: closed - Opened by hanefi about 1 year ago - 4 comments

#288 - Schedule running the day after

Issue - State: closed - Opened by iglesiasroberto14 about 1 year ago - 2 comments

#287 - Should the default_version in control file be 1.6?

Issue - State: closed - Opened by jorsol about 1 year ago - 1 comment

#285 - cron.schedule() in postgreSQL in GCP using liquiBase

Issue - State: closed - Opened by macgru94 over 1 year ago - 1 comment

#284 - A function declaration without a prototype is deprecated in all versions of C and is not supported in C2x [-Werror,-Wdeprecated-non-prototype]

Issue - State: closed - Opened by aagranados over 1 year ago - 1 comment

#283 - Overall on/off to launch active jobs

Pull Request - State: closed - Opened by bdrouvotAWS over 1 year ago - 3 comments

#282 - startup timeout after a certain amount of simultaneous jobs

Issue - State: open - Opened by elkejava over 1 year ago - 4 comments

#281 - Convert K&R function definitions

Pull Request - State: closed - Opened by df7cb over 1 year ago

#280 - Execute command in custom schema with schedule_in_database

Issue - State: closed - Opened by Andarius over 1 year ago

#279 - Call Remote Procedure

Issue - State: open - Opened by YuriyTigiev over 1 year ago

#278 - Is it wrong to have a lot of cron jobs (over a million)?

Issue - State: open - Opened by tolunayar over 1 year ago - 2 comments

#277 - Postgres 16 support

Issue - State: closed - Opened by Deltaus over 1 year ago - 1 comment

#276 - Not necessary to save user`s password in task?

Issue - State: closed - Opened by roseduan over 1 year ago - 2 comments

#275 - fix warning- "declaration shadows a previous local"

Pull Request - State: closed - Opened by sahemant over 1 year ago

#274 - Hard pg_cron 1.5+ dependency on pg_catalog breaks restores of dumps created when using older extension versions

Issue - State: open - Opened by pcnc over 1 year ago - 17 comments

#273 - add possibility to schedule jobs on the last day of month

Pull Request - State: closed - Opened by zhjwpku over 1 year ago

#272 - docker postgres:16beta1-alpine : src/job_metadata.c:1526:24: error: declaration of 'schedule' shadows a previous local [-Werror=shadow=compatible-local]

Issue - State: open - Opened by xxaier over 1 year ago

#271 - fix memory corruption bug of cron module

Pull Request - State: closed - Opened by zhjwpku over 1 year ago - 2 comments

#270 - pg_cron logs many errors when default_transaction_read_only on

Issue - State: open - Opened by serprex over 1 year ago
Labels: enhancement

#269 - pg_cron cannot be compiled against Postgres 1.5

Issue - State: open - Opened by CMUboy over 1 year ago - 3 comments

#268 - Test latest version instead of hardcoding 1.4

Pull Request - State: closed - Opened by df7cb over 1 year ago - 1 comment

#267 - ERROR: compressed lz4 data is corrupt on big-endian architectures

Issue - State: closed - Opened by df7cb over 1 year ago - 3 comments

#266 - 0/5 * * * * not suppored

Issue - State: closed - Opened by roseduan over 1 year ago - 2 comments

#265 - cron.timezone

Issue - State: closed - Opened by 1schmnkS over 1 year ago - 2 comments

#264 - `ALTER EXTENSION UPDATE` and `pg_cron launcher` blocked each other, none of the backends proceed

Issue - State: open - Opened by onderkalaci over 1 year ago

#263 - Adding pg_cron to Alpine Linux docker image based on PostgreSQL 14.6

Issue - State: closed - Opened by espadarticoDBA over 1 year ago - 4 comments

GitHub / citusdata/pg_cron issues and pull requests