Στις 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)
