pg_cron not running scheduled tasks

0

Recently had to terminate an SQL query "update cron.job_run_details" that was running indefintely on our RDS db, using SELECT pg_terminate_backend(<jobid>);

Since then, no cron jobs are running. I've taken a snapshot and restored a test instance, in which ive tried adding new cron jobs (such as vacuums every minute on a table) and it still does not work. I've rebooted the test instance to no effect. I wondering if the pg_chron extension works off a daemon and it I unwillingly terminated it and have no idea how to reboot it from RDS. Has anyone had similar issues?

2回答
0
承認された回答

Turn out I had terminated the connection that was idle, and pg_cron does not automatically recreate the connection. What we had to do was delete the extension, recreate it and reboot the instance and now the cron jobs work as expected

回答済み 9ヶ月前
0

Hello.
Does cron not work even if you reconfigure it according to the steps in the following document?
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL_pg_cron.html

profile picture
エキスパート
回答済み 9ヶ月前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ