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

From Erik Dobák
Subject Re: BUG #18985: fast shutdown does not close connections from qlik data gateway data movement aka. replicate
Date
Msg-id CAH7-e5vFAX+-EkjT20uMUw3kA8pNv53aD_jKR8+QBB+1hse9pg@mail.gmail.com
Whole thread Raw
In response to Re: BUG #18985: fast shutdown does not close connections from qlik data gateway data movement aka. replicate  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs


On Tue, 15 Jul 2025, 20:00 Tom Lane, <tgl@sss.pgh.pa.us> wrote:
"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
thank you Tom,

based on the documentation mentioned in my initial post i was thinking that the connections are closed during " fast" shutdown immediately.

i will forward this to Qlik then.

is there a better documentation that would explain the process of shutdown than the link i posted above?

regards

E

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: Erik Dobák
Date:
Subject: Re: BUG #18985: fast shutdown does not close connections from qlik data gateway data movement aka. replicate