How can I activate the "pg_cron scheduler" session?

Поиск
Список
Период
Сортировка
От Abdullah Ergin
Тема How can I activate the "pg_cron scheduler" session?
Дата
Msg-id CAJZxWENG_Mmsfz=jAYzUwkErX3YS8iKHvfBR4VeK-w0_5rRhJQ@mail.gmail.com
обсуждение исходный текст
Список pgsql-admin
I am using the pg_cron extension for scheduled tasks in PostgreSQL. While monitoring active sessions due to intermittent interruptions in my database, I noticed that the 'postgres' user was running a long-lasting session. This session had an Application Name of: 'pg_cron scheduler' and a command of;
update cron.job_run_details set status = $1, return_message = $2, end_time = $3 where runid = $4.
Since the session duration was excessively long, I terminated this session, and afterward, my cron jobs stopped running. How can I re-enable the session?  

В списке pgsql-admin по дате отправления:

Предыдущее
От: Rambabu V
Дата:
Сообщение: Db nodes are getting deregistering from consul
Следующее
От: Rakesh Nashine
Дата:
Сообщение: Ingress to PostgreSQL Migration