1

Aurora Postgres 12.8

Created pg_cron job, everything looks good in cron.job, but the job actually didn't work and cron.job_run_details didn't get any record either.

RDS console log shows the following error

5 is outside the valid range for parameter "cron.max_running_jobs" (0 .. 0)

cron.max_running_jobs =5 in db, what should be the valid range/value for cron.max_running_jobs? and how to set it?

Wishes

user3706888
  • 159
  • 2
  • 11
  • Were you able to solve this? I'm having the same issue – Holmestorm Apr 21 '22 at 14:54
  • @Holmestorm Yes, fixed with AWS support ticket. set parameter 'max_worker_processes' =6. DRS instance was very small so the default value for 'max_worker_processes' was 2, to have a job running parameter 'max_worker_processes' value should be greater than parameter 'cron.max_running_jobs'. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL_pg_cron.html#PostgreSQL_pg_cron.examples – user3706888 Apr 22 '22 at 04:47

1 Answers1

0

Fixed with AWS support ticket. set parameter 'max_worker_processes' =6.

DRS instance was very small so the default value for 'max_worker_processes' was 2, to have a job running parameter 'max_worker_processes' value should be greater than parameter 'cron.max_running_jobs'. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL_pg_cron.html#PostgreSQL_pg_cron.examples

user3706888
  • 159
  • 2
  • 11