select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Time series

pg_cron

Job scheduler for PostgreSQL

pgext.cloud · Source code · License text · Control file

Overview

Packagepg_cron
Version1.6.8
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPGDG
Extension typePreloaded
Requires CREATE EXTENSIONYes
Requires preloadYes
TrustedNo
RelocatableNo
Shared librariespg_cron
Schemapg_catalog
Stars3,876
Latest commit2026-08-30
Latest release2025-09-04
Catalogue updated2026-09-19

Related extensions

Required by

documentdbAPI surface for DocumentDB for PostgreSQL
dventimi@pg_flight_recorderServer-side flight recorder for PostgreSQL performance monitoring
dventimi@pg_partition_magicianPure-SQL online RANGE-partition manager (time / id / uuidv7), pg_cron-driven
keyhippoRLS-compatible API keys for PostgreSQL
olirice-read_onceSend messages that can only be read once
pg_dispatchAsynchronous SQL dispatcher built on pg_cron
pg_tursoPostgres output plugin for replicating data to Turso.
pgfr_recordServer-side PostgreSQL performance flight recorder
pglockLightweight distributed lock service inside PostgreSQL
pgmbA simple PostgreSQL Message Broker system
supa_queueSimple PostgreSQL job queue that dispatches asynchronous HTTP requests with pg_net, schedules processing and retries with pg_cron, and stores endpoint credentials in Supabase Vault.
timeseriesConvenience API for time series stack
vectorizeThe simplest way to do vector search on Postgres

See also

pgagentA PostgreSQL job scheduler
pg_taskexecute any sql command at any specific time at background
pg_dbms_jobExtension to add Oracle DBMS_JOB full compatibility to PostgreSQL
pg_dispatchAsynchronous SQL dispatcher built on pg_cron
pg_laterRun queries now and get results later
pg_jobmonExtension for logging and monitoring functions in PostgreSQL
pg_durableSQL-native durable orchestrations for PostgreSQL
pg_backgroundRun SQL queries in the background
pg_whenNatural language time parsing for PostgreSQL
cron_utilsParse cron expressions and compute previous or next trigger times