PostgreSQL pgcron Schedule connection failed Error

Problem:

             The Scheduled run of a query in PostgreSQL pgcron is not executed.

Identification:

1.      Why the Problem?

                      Wrong Authentication method.

2.      How the Problem identified?

                      Used the below query to see the last run status and the return message

SELECT * FROM cron.job_run_details ORDER BY runid DESC;

 the connection failed return message for all the scheduled Jobs

Action to be Taken:

                refer: https://xcel.techfinite.com/wiki/postgresql-materialized-views#cron-failed-and-error-message-is-connection-failed-

Investigation Details:

                Done By: Sriram Annamalai G M

                Date: 19-05-2025