Postgres Pro
Downloads
Home   >   mailing lists

Can a long running procedure detect when smart shutdown is pending? - Mailing list pgsql-general

From Dennis White
Subject Can a long running procedure detect when smart shutdown is pending?
Date
Msg-id CAE=rie-ZcNzzt_8bKrN-7fnnbYL-ofbne4jNurd3HjjW2j9Yaw@mail.gmail.com
Whole thread Raw
Responses Re: Can a long running procedure detect when smart shutdown is pending?
Re: Can a long running procedure detect when smart shutdown is pending?
List pgsql-general
Tree view
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?

Thanks,
Dennis

pgsql-general by date:

Previous
From: "Tefft, Michael J"
Date:
Subject: RE: Removing the default grant of EXECUTE on functions/procedures to PUBLIC
Next
From: Tom Lane
Date:
Subject: Re: Removing the default grant of EXECUTE on functions/procedures to PUBLIC