MIME-Version: 1.0
From: Dennis White <dwhite@seawardmoon.com>
Date: Fri, 5 Jul 2024 14:12:27 -0400
Message-ID: <CAE=rie-ZcNzzt_8bKrN-7fnnbYL-ofbne4jNurd3HjjW2j9Yaw@mail.gmail.com>
Subject: Can a long running procedure detect when smart shutdown is pending?
To: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000003ffcad061c8402c0"
Archived-At: <https://www.postgresql.org/message-id/CAE%3Drie-ZcNzzt_8bKrN-7fnnbYL-ofbne4jNurd3HjjW2j9Yaw%40mail.gmail.com>
Precedence: bulk

--0000000000003ffcad061c8402c0
Content-Type: text/plain; charset="UTF-8"

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

--0000000000003ffcad061c8402c0
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>My project&#39;s DB has a mutli-step stored procedure=
 using Transaction Control that may take 30 minutes or more to complete.</d=
iv><div>I am curious if there is a way to make it more smart shutdown frien=
dly so it can stop between steps?</div><div><br></div><div>We are using bot=
h PG 14 and PG 16 on Rhel 8.</div><div>Pardon me if it&#39;s obvious but is=
 there a function to call or a table that could be checked after a commit w=
ithin the procedure to determine a shutdown is pending?</div><div><br></div=
><div>Thanks,</div><div>Dennis<br></div></div>

--0000000000003ffcad061c8402c0--