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

From David G. Johnston
Subject Re: BUG #18985: fast shutdown does not close connections from qlik data gateway data movement aka. replicate
Date
Msg-id CAKFQuwagA5jf1RAvT6LaD6fLQwJDG2Cd2koH6L3xz5KyEqtUWw@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, Jul 15, 2025, 11:00 Tom Lane <tgl@sss.pgh.pa.us> wrote:

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.

Ok, yeah.  Looking more closely the reconnection attempt in the log doesn't look related to this so those hung connections are not playing nicely when told to go away.  Which indeed in fast mode we have to rely upon.

David J.

pgsql-bugs by date:

Previous
From: Tom Lane
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