pg_cron not running
- 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