Re: Can a long running procedure detect when smart shutdown is pending?

Dennis White <dwhite@xxxxxxxxxxxxxxx> · Fri, 5 Jul 2024 19:36:07 -0400

Thanks for responding.
This will be a stored procedure written in plpgsql that's kicked off by pg_cron.
I wasn't sure a normal smart shutdown would stop it.

Thanks

On Fri, Jul 5, 2024 at 4:57 PM Achilleas Mantzios <a.mantzios@xxxxxxxxxxxxxxxxxxxx> wrote:

    Στις 5/7/24 21:12, ο/η Dennis White
      έγραψε:

        My project's DB has a mutli-step stored procedure using
          Transaction Control that may take 30 minutes or more to
          complete.
        I am curious if there is a way to make it more smart
          shutdown friendly so it can stop between steps?

        We are using both PG 14 and PG 16 on Rhel 8.
        Pardon me if it's obvious but is there a function to call
          or a table that could be checked after a commit within the
          procedure to determine a shutdown is pending?

    Maybe somehow checking the log for a message like : 

    received smart
          shutdown request
    Or use
          tail_n_mail against the log and then implement some logic
          using NOTIFY , ideally you want your procedure to be
          interrupted rather than do polling.

        Thanks,
        Dennis

    -- 
Achilleas Mantzios
 IT DEV - HEAD
 IT DEPT
 Dynacom Tankers Mgmt (as agents only)