Re: BUG #18985: fast shutdown does not close connections from qlik data gateway data movement aka. replicate - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #18985: fast shutdown does not close connections from qlik data gateway data movement aka. replicate
Date
Msg-id 936089.1752602421@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #18985: fast shutdown does not close connections from qlik data gateway data movement aka. replicate  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: BUG #18985: fast shutdown does not close connections from qlik data gateway data movement aka. replicate
Re: BUG #18985: fast shutdown does not close connections from qlik data gateway data movement aka. replicate
List pgsql-bugs
"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



pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #18985: fast shutdown does not close connections from qlik data gateway data movement aka. replicate
Next
From: Tom Lane
Date:
Subject: Re: BUG #18986: SIGSEGV in nodeModifyTable.c during Parallel Execution