From: | Dennis White <dwhite(at)seawardmoon(dot)com> |
---|---|
To: | Achilleas Mantzios <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Can a long running procedure detect when smart shutdown is pending? |
Date: | 2024-07-05 23:36:07 |
Message-ID: | CAE=rie95=YwVnL9ix0Xwp2wfUZY7rSJ4Ji_uQEAiAdgdpOqvfQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)mantzios(at)cloud(dot)gatewaynet(dot)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)
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Krishnakant Mane | 2024-07-06 05:39:23 | Re: confused about material view locks please explain |
Previous Message | David Rowley | 2024-07-05 22:26:01 | Re: Planning of sub partitions |