On Fri, 2024-07-05 at 14:12 -0400, Dennis White wrote:
> 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?
I don't think there is a direct way to do that in SQL; that would require a new
system function that exposes canAcceptConnections() in SQL.
What you could do is use the dblink extension to connect to the local database.
If you get an error "the database system is shutting down", there is a smart
shutdown in progress.
Yours,
Laurenz Albe