pg_cron
A cron-based job scheduler that runs as a PostgreSQL extension for running periodic jobs directly inside the database.
What is pg_cron?
pg_cron is a PostgreSQL extension that provides a cron-based job scheduler running inside the database. It allows users to schedule periodic SQL commands, stored procedures, and maintenance tasks directly within PostgreSQL, eliminating the need for external cron services. The extension uses standard cron syntax with extensions like seconds-based intervals and runs as a background worker within the PostgreSQL cluster.
PostgreSQL database administrators and developers who need to automate periodic database tasks like data cleanup, rollups, maintenance, or stored procedure execution. It's particularly useful for teams managing PostgreSQL instances who want to keep job scheduling integrated with their database infrastructure.
Developers choose pg_cron because it runs entirely inside PostgreSQL, leveraging the database's security, reliability, and existing infrastructure without external dependencies. Unlike external cron services, it provides native SQL functions for job management, Row-Level Security for job isolation, and detailed execution logging within the database.
Overview
Run periodic jobs in PostgreSQL
Use Cases
Best For
- Automating periodic data cleanup tasks like deleting old records from tables on a schedule
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
