pg_timetable

Project Overview

pg_timetable is an advanced standalone job scheduler for PostgreSQL, offering many advantages over traditional schedulers like cron. It is completely database driven and provides advanced concepts for scheduling PostgreSQL commands, system programs, and built-in operations.

Key Features

• Tasks can be arranged in chains with SQL, built-in, or executable commands
• Parameters can be passed to tasks
• Missed chains (due to downtime) can be retried automatically
• Configurable repetitions
• Built-in tasks: sending emails, downloading, importing files, etc.
• Fully database driven configuration and logging
• Enhanced cron-style scheduling
• Optional concurrency protection
• YAML-based chain definitions for easy configuration
• OpenTelemetry tracing and metrics export (opt-in)
• Official Docker images for both linux/amd64 and linux/arm64

Target Audience

• PostgreSQL database administrators
• Developers and operations engineers who need advanced scheduling

Quick Start

1. Install pg_timetable
2. Add tasks via SQL: SELECT timetable.add_job('execute-func', '5 0 * 8 *', 'SELECT public.my_func()')
3. Or define chains via YAML: pg_timetable --file chains.yaml postgresql://user:pass@host/db
4. See the documentation

Core Advantages

• Fully database-driven — config and logs in the database
• Task chains and parameter passing support
• YAML configuration for readability
• OpenTelemetry observability

System Requirements

• OS: Cross-platform (via Docker)
• Architectures: linux/amd64, linux/arm64