To answer your query, I would like to mention that the parameter ‘cron.task_running_timeout’ is not available currently for either RDS for PostgreSQL or Aurora for PostgreSQL. You can also verify the same by referring the below documents that state all the custom parameters currently available for RDS and Aurora for PostgreSQL:
[+] RDS for PostgreSQL DB instance parameter list: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.PostgreSQL.CommonDBATasks.Parameters.html#Appendix.PostgreSQL.CommonDBATasks.Parameters.parameters-list
[+] Aurora PostgreSQL cluster-level parameters: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Reference.ParameterGroups.html#AuroraPostgreSQL.Reference.Parameters.Cluster
[+] Aurora PostgreSQL instance-level parameters: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Reference.ParameterGroups.html#AuroraPostgreSQL.Reference.Parameters.Instance
As the parameter is not supported currently for RDS/Aurora for PostgreSQL, hence you are facing the below mentioned error while modifying the parameter in the parameter group:
‘Error: error modifying DB Cluster Parameter Group: InvalidParameterValue: Could not find parameter with name: cron.task_running_timeout’
Moreover, as you have also asked whether you need to set the parameter on the session level, I would like to inform that as per the architecture of PostgreSQL, you need to modify the timing task timeout time by setting the guc parameter cron.task_running_timeout in postgresql.conf and restarting the database to take effect.
However, RDS/Aurora being a managed database service, it is not possible to have root access of the database to modify the config file of the DB engine. Hence, currently the parameter ‘cron.task_running_timeout’ cannot be modified by the user for RDS/Aurora for PostgreSQL.
In case, the parameter is made available for modification in the future, you can find the same listed in the parameter lists whose reference links have been provided above.
Thank you for your incredibly detailed answer. I appreciate it!
Dependency TimeOut Error when making requests to Neptuneasked 8 days ago
RDS Storage upgrade - failure Error: Error modifying DB Instance: InvalidParameterCombination: Invalid storage size for engine name postgres and storage type gp2: 2400Accepted Answerasked 7 months ago
An error occurred (InvalidRequestException) when calling the CreateProvisioningTemplate operation: Access denied during validating provisioning hook, Hook: arn:aws:lambda:ap-southeast-2::fAccepted Answerasked 7 months ago
Error connection to the API!asked 3 years ago
AWS step function giving error, when I had included the "Parameter" tagasked 4 months ago
How I can increase the Integration association limit for the Amazon Connect instance?asked 6 months ago
Does RDS/Aurora for postgresql support cron.task_running_timeoutasked 2 months ago
Error when trying to add db instance to VS server explorerasked 3 years ago
RDS does not support creating a DB instanceasked 8 months ago
InvalidResourceId Error When Trying to List Tags for ParameterAccepted Answerasked 3 years ago