Re: BUG #18985: fast shutdown does not close connections from qlik data gateway data movement aka. replicate

From: Erik Dobák <erik(dot)dobak(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #18985: fast shutdown does not close connections from qlik data gateway data movement aka. replicate
Date: 2025-07-15 18:32:53
Message-ID: CAH7-e5vFAX+-EkjT20uMUw3kA8pNv53aD_jKR8+QBB+1hse9pg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, 15 Jul 2025, 20:00 Tom Lane, <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)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

>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Erik Dobák 2025-07-15 18:38:46 Re: BUG #18985: fast shutdown does not close connections from qlik data gateway data movement aka. replicate
Previous Message David G. Johnston 2025-07-15 18:28:08 Re: BUG #18985: fast shutdown does not close connections from qlik data gateway data movement aka. replicate