1개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
0
Have you enabled it first? See https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL_pg_cron.html
답변함 2년 전
관련 콘텐츠
- AWS 공식업데이트됨 일 년 전
- AWS 공식업데이트됨 3년 전
- AWS 공식업데이트됨 일 년 전
Have you enabled it first? See https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL_pg_cron.html
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.