MIME-Version: 1.0
References: <18985-64431d78bcabae95@postgresql.org> <CAKFQuwb4en2gPyGep4TghVeqitxBPsgiQAG5AZJ4yikBgUzooQ@mail.gmail.com>
 <CAH7-e5tbkVLKeaCEqv-_eL9D9Ppikvq-bmjviKVG6-ukkU7pXQ@mail.gmail.com> <923969.1752595701@sss.pgh.pa.us>
In-Reply-To: <923969.1752595701@sss.pgh.pa.us>
From: =?UTF-8?Q?Erik_Dob=C3=A1k?= <erik.dobak@gmail.com>
Date: Tue, 15 Jul 2025 18:22:21 +0200
Message-ID: <CAH7-e5sFFOJ4e9D4b2130-mqHEj-m9GbBw-if_Uh9L5mCLRBWw@mail.gmail.com>
Subject: Re: BUG #18985: fast shutdown does not close connections from qlik
 data gateway data movement aka. replicate
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>, pgsql-bugs@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000003160d0639fa2fa3"
Archived-At: <https://www.postgresql.org/message-id/CAH7-e5sFFOJ4e9D4b2130-mqHEj-m9GbBw-if_Uh9L5mCLRBWw%40mail.gmail.com>
Precedence: bulk

--00000000000003160d0639fa2fa3
Content-Type: text/plain; charset="UTF-8"

On Tue, 15 Jul 2025, 18:08 Tom Lane, <tgl@sss.pgh.pa.us> wrote:

> =?UTF-8?Q?Erik_Dob=C3=A1k?= <erik.dobak@gmail.com> writes:
> > On Tue, 15 Jul 2025, 16:35 David G. Johnston, <
> david.g.johnston@gmail.com>
> > wrote:
> >> Can you replicate this on a supported version of PostgreSQL?
>
> > 14.18 is afaik supported. it is runn:ng on 14.8. so yes i could replicate
> > this on a supported version.
>
> I think what David is actually wondering about is "Qlik Data Gateway
> Data Movement".  That is not our code, and if it's using a custom
> logical-replication plugin then the plugin seems like the likely
> thing to blame.  We have not heard reports of this happening with
> our stock replication code.
>
>                         regards, tom lane
>

hi Tom,

not sure what you mean by "plugin".

dgdm is connecting to an untempered postgres db = standard postres db
installation afaik.

did not know about plugins in postgres. how would one check if there is
some?

E

>

--00000000000003160d0639fa2fa3
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><div><br><br><br><div class=3D"gmail_quote gmail_quote_co=
ntainer"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, 15 Jul 2025, 18:08 T=
om Lane, &lt;<a href=3D"mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt;=
 wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px =
0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">=3D?UTF-=
8?Q?Erik_Dob=3DC3=3DA1k?=3D &lt;<a href=3D"mailto:erik.dobak@gmail.com" tar=
get=3D"_blank" rel=3D"noreferrer">erik.dobak@gmail.com</a>&gt; writes:<br>
&gt; On Tue, 15 Jul 2025, 16:35 David G. Johnston, &lt;<a href=3D"mailto:da=
vid.g.johnston@gmail.com" target=3D"_blank" rel=3D"noreferrer">david.g.john=
ston@gmail.com</a>&gt;<br>
&gt; wrote:<br>
&gt;&gt; Can you replicate this on a supported version of PostgreSQL?<br>
<br>
&gt; 14.18 is afaik supported. it is runn:ng on 14.8. so yes i could replic=
ate<br>
&gt; this on a supported version.<br>
<br>
I think what David is actually wondering about is &quot;Qlik Data Gateway<b=
r>
Data Movement&quot;.=C2=A0 That is not our code, and if it&#39;s using a cu=
stom<br>
logical-replication plugin then the plugin seems like the likely<br>
thing to blame.=C2=A0 We have not heard reports of this happening with<br>
our stock replication code.<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<br></blockquote></div></div><div dir=3D"auto">=
<br></div><div dir=3D"auto">hi Tom,</div><div dir=3D"auto"><br></div><div d=
ir=3D"auto">not sure what you mean by &quot;plugin&quot;.</div><div dir=3D"=
auto"><br></div><div dir=3D"auto">dgdm is connecting to an untempered postg=
res db =3D standard postres db installation afaik.</div><div dir=3D"auto"><=
br></div><div dir=3D"auto">did not know about plugins in postgres. how woul=
d one check if there is some?</div><div dir=3D"auto"><br></div><div dir=3D"=
auto">E</div><div dir=3D"auto"><div class=3D"gmail_quote gmail_quote_contai=
ner"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bo=
rder-left:1px solid rgb(204,204,204);padding-left:1ex">
</blockquote></div></div></div>

--00000000000003160d0639fa2fa3--