By using AWS re:Post, you agree to the Terms of Use

PG_CRON doesn't work

0

Hi, I have a RDS instance, I was used to running maintenance sql statements using pg_cron but for some reason it has stopped working and I can't seem to work out why. I no longer can see any activity in cron.job_run_details and my parameters in my RDS instance stay the same. I have also tried the following UPDATE cron.job SET nodename = ''; with no luck. Can anyone please advise?

1 Answer
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]https://aws.amazon.com/premiumsupport/knowledge-center/

answered 3 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions