public inbox for [email protected]  

help / color / mirror / Atom feed

From: Laurenz Albe <[email protected]>
To: Dennis White <[email protected]>
To: pgsql-general <[email protected]>
Subject: Re: Can a long running procedure detect when smart shutdown is pending?
Date: Sat, 06 Jul 2024 07:59:26 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAE=rie-ZcNzzt_8bKrN-7fnnbYL-ofbne4jNurd3HjjW2j9Yaw@mail.gmail.com>
References: <CAE=rie-ZcNzzt_8bKrN-7fnnbYL-ofbne4jNurd3HjjW2j9Yaw@mail.gmail.com>

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

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Can a long running procedure detect when smart shutdown is pending?
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox