citusdata / citusdata/pg_cron

pg_cron not running

Open
#204 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

I have tried several way to run pg_corn but unable to do that. Did not found any log. Somewhere it said entry on on .pgpass and hba.conf file but not sure how to entry on pg_hba.conf because I did not found any user for pg_corn. There is no log at postgresql about pg_corn unable to execute for a rease. I am not sure does it support 24hr time format or not. Is here anyone can help me out?

`postgres=# select * from cron.job;
jobid | schedule | command | nodename | nodeport | database | username | active | jobname
-------+-------------+---------------------------------------------------------------------------------+-----------+----------+--------------+----------+--------+---------------
1 | 52 14 * * * | /data/pgsql/scrirpts/db_table_archiver.sh | 127.0.0.1 | 5439 | test_db | postgres | t | data_archiver
2 | 56 14 * * * | create table t1(a int); insert into t1(a) select * from generate_series(1,10); | localhost | 5439 | test_db | postgres | t |
(2 rows)

postgres=# select * from cron.job_run_details;
jobid | runid | job_pid | database | username | command | status | return_message | start_time | end_time
-------+-------+---------+----------+----------+---------+--------+----------------+------------+----------
(0 rows)

postgres=# select now();
now
-------------------------------
2022-09-16 14:59:51.263822+06
`

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the PostgreSQL authentication and pg_cron setup referenced in the report, especially pg_hba.conf and .pgpass. Compare the cron.job rows with cron.job_run_details and the reported time, and check the available PostgreSQL logs. Done means identifying why neither scheduled job has a run record and documenting a reproducible configuration or missing setting.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, shell
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.