citusdata / citusdata/pg_cron

cron scheduling

Open
#357 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
3.9k
Forks
260
Avg merge
5d 5h
Merged PRs (30d)
1

Description

Hi,
I have servers in different time zones, and I know that pg_cron schedules jobs by default in UTC. Is there any way to schedule jobs based on the server's local time zone instead of UTC?

Contributor guide

No contributing guide indexed for this repository

Research direction

No source files, tests, or entry points are named. Start by tracing how pg_cron currently applies UTC scheduling and review PostgreSQL time-zone behavior; define the expected local-time semantics and tests needed to show that scheduling uses the server's local time zone.

Written by the indexing model from the issue text.

Assessment

Tech stack
c, postgresql
Domain
databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.