PostgreSQL module for simple job schedule

Edit Package pg_cron

pg_cron is a simple cron-based job scheduler for PostgreSQL (9.5 or higher) that runs inside the database as an extension. It uses the same syntax as regular cron, but it allows you to schedule PostgreSQL commands directly from the database.

Refresh
Refresh
Source Files
Filename Size Changed
_multibuild 0000000197 197 Bytes
pg_cron-1.6.4.tar.gz 0000055141 53.8 KB
pg_cron.changes 0000008718 8.51 KB
pg_cron.spec 0000002028 1.98 KB
Latest Revision
Ana Guerrero's avatar Ana Guerrero (anag+factory) accepted request 1201374 from Marcus Rueckert's avatar Marcus Rueckert (darix) (revision 13)
- disable pg11 builds as we will remove the EOL package soon

- update to 1.6.4
  - Fix bug with invalidation of CachedCronJobRelationId by
    @CyberDem0n in #346
  - Select procedure based on argument type of
    cron_unschedule_named by @CyberDem0n in #347
  - Revert d90843d per #342

- update to 1.6.3
  - Fix pointer reuse bug causing off-by-1 day of month by
    @marcoslot in #292
  - Update the database when scheduling an existing job by
    @nuno-faria in #293
  - Make cron_unschedule_named() accept v1.4 SQL signature. by
    @nmisch in #299
  - Allow interrupts in pg_cron launcher loop to avoid deadlock by
    @Ngalstyan4 in #319
  - Fixes possible overflow by @sminux in #326
  - Log start & end time for all failed runs by @kketch in #324
  - Replace MemoryContextResetAndDeleteChildren macro with
    MemoryContextReset for PG 17 compatibility by @esiaero in #332
  - Fix compiler error on Illumos by @japinli in #317

- update to 1.6.2
  - Fixes off-by-1 issue in day of month

- update to 1.6.1
  - Restart pg_cron scheduler when terminating the background
    worker by @marcocitus in #286
Comments 0
openSUSE Build Service is sponsored by