public inbox for [email protected]  

help / color / mirror / Atom feed

From: Jelte Fennema-Nio <[email protected]>
To: Tatsuo Ishii <[email protected]>
Cc: [email protected]
Cc: [email protected]
Cc: [email protected]
Cc: [email protected]
Cc: [email protected]
Cc: [email protected]
Subject: Re: Add GoAway protocol message for graceful but fast server shutdown/switchover
Date: Tue, 31 Mar 2026 09:12:09 +0200
Message-ID: <CAGECzQSbr=WDJDZ-fFTDRjY7udC6H9Sb3VHWk9BxWx9uTG27tg@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<CAGECzQTu=SXZxg5ODf3xzQ5_pZiY5mPBO30ZL_2-0LNfM=wHyA@mail.gmail.com>
	<[email protected]>

On Tue, 31 Mar 2026 at 01:17, Tatsuo Ishii <[email protected]> wrote:
> Interesting. In Pgpool-II case, client disconnection is not a problem,
> the connection to PostgreSQL is kept open anyway (if connection
> expiration is not set). Probably this is because Pgpool-II only
> supports "session level" connection pooling.

I guess, I was not clear. Because the same problem exists for
Pgpool-II. When pgpool forwards the message to the client, the client
will disconnect from pgpool. But if connection_life_time is not
reached (and by default this is unlimited) pgpool will not disconnect
from the postgres server. So the postgres server has not actually
achieved the intended goal, but the client still disconnected for no
benefit, only downsides.

Maybe the problem is not too bad, i.e. it will cause some unnecessary
disconnects from the client, but it shouldn't cause big problems. So
maybe the ParameterStatus approach is worth exploring again (I
remember I ran into some problems, due to us normally only sending
ParameterStatus at the end of a query, but I'm pretty sure that can be
worked around somehow).

view thread (15+ messages)

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], [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Add GoAway protocol message for graceful but fast server shutdown/switchover
  In-Reply-To: <CAGECzQSbr=WDJDZ-fFTDRjY7udC6H9Sb3VHWk9BxWx9uTG27tg@mail.gmail.com>

* 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