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 Respuesta
0
profile pictureAWS
respondido hace 2 años
  • 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?

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

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas