Re: How can I stop a long run pgAgent job?

From: Adam Brusselback <adambrusselback(at)gmail(dot)com>
To: f(dot)pardi(at)portavita(dot)eu
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: How can I stop a long run pgAgent job?
Date: 2018-06-21 14:05:20
Message-ID: CAMjNa7f4_OhKfNtoFAf811ZM9-pBJoCBqZy34zJ4sQu2rxrAsQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

As said, terminating a backend is the current way to kill a job.

An alternative if this is something you do often:
https://github.com/GoSimpleLLC/jpgAgent
jpgAgent supports terminating a job by issuing a NOTIFY command on the
correct channel like this: NOTIFY jpgagent_kill_job, 'job_id_here';
It works well with windows, and all the existing pgAgent admin tools work
to manage it, it's just a drop in replacement for the agent portion.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Moreno Andreo 2018-06-21 15:36:23 pgp_sym_decrypt() - error 39000: wrong key or corrupt data
Previous Message Łukasz Jarych 2018-06-21 13:37:55 Re: Using DSN Connection and knowing windows username