Re: BUG #18985: fast shutdown does not close connections from qlik data gateway data movement aka. replicate
Erik Dobák <erik.dobak@gmail.com>
From: Erik Dobák <erik.dobak@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>,
pgsql-bugs@lists.postgresql.org
Date: 2025-07-15T18:32:53Z
Lists: 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 >