1 Answer
- Newest
- Most votes
- Most comments
0
Hi ,
I understand you are trying to run maintenance sql statements using pg_cron and it has stopped working.Please correct me if I misunderstood.
The pg_cron extension is supported on RDS for PostgreSQL engine versions 12.5 and higher. Please verify your engine version if it is updated to the supported one.
Please also verify if you have done the following :
1)Is cron_job enabled
2)Enabling the pg_extension,granting permissions to the pg_cron,scheduling pg_jobs following the link[1].
3)For further assistance you can contact AWS Customer Support to review your RDS instance[2].
I hope the above is helpful.
Reference
[1]https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL_pg_cron.html
answered 2 years ago
Relevant content
- asked 2 years ago
- Accepted Answerasked a year ago
- asked 2 years ago
- AWS OFFICIALUpdated 4 years ago
- AWS OFFICIALUpdated 7 months ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated a year ago