Home > mailing lists

Re: How can I stop a long run pgAgent job? - Mailing list pgsql-general

From	Adam Brusselback
Subject	Re: How can I stop a long run pgAgent job?
Date	June 21, 2018 20:05:20
Msg-id	CAMjNa7f4_OhKfNtoFAf811ZM9-pBJoCBqZy34zJ4sQu2rxrAsQ@mail.gmail.com Whole thread Raw
In response to	Re: How can I stop a long run pgAgent job? (Fabio Pardi <f.pardi@portavita.eu>)
List	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.

From: Łukasz Jarych
Date: 21 June 2018, 19:37:55
Subject: Re: Using DSN Connection and knowing windows username

From: Moreno Andreo
Date: 21 June 2018, 21:36:23
Subject: pgp_sym_decrypt() - error 39000: wrong key or corrupt data