From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
cc: =?UTF-8?Q?Erik_Dob=C3=A1k?= <erik.dobak@gmail.com>,
        "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #18985: fast shutdown does not close connections from qlik data gateway data movement aka. replicate
In-reply-to: <CAKFQuwbENYBRre_Yo+jhtx+56b0W--AANjgJp1j-Ax9xUfAMxQ@mail.gmail.com>
References: <18985-64431d78bcabae95@postgresql.org> <CAKFQuwb4en2gPyGep4TghVeqitxBPsgiQAG5AZJ4yikBgUzooQ@mail.gmail.com> <CAH7-e5tbkVLKeaCEqv-_eL9D9Ppikvq-bmjviKVG6-ukkU7pXQ@mail.gmail.com> <923969.1752595701@sss.pgh.pa.us> <CAKFQuwbENYBRre_Yo+jhtx+56b0W--AANjgJp1j-Ax9xUfAMxQ@mail.gmail.com>
Comments: In-reply-to "David G. Johnston" <david.g.johnston@gmail.com>
	message dated "Tue, 15 Jul 2025 09:27:36 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <936088.1752602421.1@sss.pgh.pa.us>
Date: Tue, 15 Jul 2025 14:00:21 -0400
Message-ID: <936089.1752602421@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/936089.1752602421%40sss.pgh.pa.us>
Precedence: bulk

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> The observed behavior of the server seems like a bug no matter how
> well-coded or not the software trying to make the connecting is.  The
> server should be able to close and disallow clients no matter what they are
> doing.

We will SIGKILL recalcitrant children during an "immediate" shutdown.
"Fast" shutdown is not defined to do that, and should not do so
because it'd imply having to do an unclean restart later.

I just tested logical replication both ways between current master and
v14 branch tip, and in either case the publishing server stops pretty
much instantaneously after "pg_ctl stop -m fast".  So I don't see
anything broken about our code, and I remain of the opinion that Qlik
is probably at fault.

			regards, tom lane