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

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?

Topics
DatabaseMigration & ModernizationAnalyticsServerlessCompute
Tags
PostgreSQLAmazon Relational Database ServiceJob Scheduling
Language
English
AWS-User-7535845
asked 2 years ago1178 views
1 Answer
0

Have you enabled it first? See https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL_pg_cron.html

profile pictureAWS
Rodney Lester
answered 2 years ago
  • AWS-User-7535845
    2 years ago

    Yes, it was working perfectly until 3 days ago. I shut all sessions on my database (there were farr too many idle connections) using the following code

    SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = 'database_name' ;

    From then on, I believe, it stopped working. I don't know if this is what triggered it to not work anymore? Any way to restore it?

  • Rodney Lester
    2 years ago

    I don't know enough about the PG engine to tell you, so we'll have to see if others know.

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

Relevant content