1개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
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
답변함 2년 전
관련 콘텐츠
- AWS 공식업데이트됨 일 년 전
- AWS 공식업데이트됨 일 년 전
- AWS 공식업데이트됨 7달 전