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.mantz...@cloud.gatewaynet.com> 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) > >
