Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ubhoW-004D1l-0H for pgsql-bugs@arkaria.postgresql.org; Tue, 15 Jul 2025 15:43:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ubhoU-00387q-2t for pgsql-bugs@arkaria.postgresql.org; Tue, 15 Jul 2025 15:43:26 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ubh7v-002kn0-6r for pgsql-bugs@lists.postgresql.org; Tue, 15 Jul 2025 14:59:27 +0000 Received: from mail-lj1-x234.google.com ([2a00:1450:4864:20::234]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1ubh7t-007QDZ-2R for pgsql-bugs@lists.postgresql.org; Tue, 15 Jul 2025 14:59:26 +0000 Received: by mail-lj1-x234.google.com with SMTP id 38308e7fff4ca-32b5931037eso41961601fa.2 for ; Tue, 15 Jul 2025 07:59:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1752591564; x=1753196364; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=wqCWcAuMtXeS/JjSHHvlmHIBY5luLfaRe66wPp28Vu4=; b=ax2PjKnxW3BNcFXQlv2pnh0kQW6s8GXVH4ncHCEx6xp136pqpsV6rKYtTs4DzcKSkz m42FHZF055JsFYVHI+jM5wP8FE9z4KhCF1q6TLY5p/TY3iUgZPOjxQKyX3MrGk/KYeQv 1fs41tad/sta+aTRlYvg+xs8erGpwuNEkVFBjpSBA1X6LM/F8Pz0hNftJ8z59yrJEAuT IXV3XouOme56frMJ+i9RypIuEHLonlohQSXCvyIB+rqWLqVpEEJHp7ozQOiuKo7Cj5WF xWNwaro6sqnyEDW9Ii4MoS0EOuQYyOGCbOG3yoKTgMrpzCJ5Az2uKVbsbjAnJyEOPYo4 5krA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1752591564; x=1753196364; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=wqCWcAuMtXeS/JjSHHvlmHIBY5luLfaRe66wPp28Vu4=; b=sOUSvKzs1XI9gi8kTJyNK2WH+SF/OBRfVTmfZBeDu51n7ImK8NVDbQ3GGHFCwbJ69M GMJQLelKXMiTMlbrHlnp3YIvAM/4dygNTM9FP3RGEzZ13A3volhrArUvhmGIqoMM8LmR I05OR8XMopbJ0oX85J+XR5RPx6jUtYmbkuoJ4Be5OroOtZlfE80lVh5Ajambuo7RwLjm exaLa93mvyz0Mj/HaNkpuhLiON95YoMtXDB3VKBr8EY5Z8r/kOs7znCld+Na7NeVxkFE Fn4HmQgHsNhfuxlOT0fGNBqmcRG68wW8AFbmKiiVoV7XMkeix5Qiv6NDQZYA58RXw7ZB TNfA== X-Gm-Message-State: AOJu0YyjnQDRrBGew+fHAH9ZlRK3GWsGhPjrDTVo+9s1QAY8k+Zwml+J wOcVkzkqBfbY1Rn6RWo/1hIdvqXa1PG/OAmhWsbUSG37hvTVj4h+e9CYSccdtkHm0aC0YWYwttx 40OyWmiPgGPl8eAxwiP8Zz+LengC2bmo= X-Gm-Gg: ASbGnctdk64fph4ClEc1rDq/F8m8+We5eU5rJck8v+36X8tVDUpPVxmy/aVbr5bCeYU QBDOkvG0YvPd07g94mIHH1emeg4iEcZmOATSfNTtxo4JD5b6lL7+cVwMDmFflrEITugBzIwMLq1 73X6KjeA3xBjVxoUh0Qzar6q2y4t3rGUGAvZ/tAIGzUlxXR+mSWzF4gCZKGdiyQJeOeVv411Kzo 9N9mDZic3GO2EHB X-Google-Smtp-Source: AGHT+IEnaWTtTnYIDyNSrb0/DzsOeFjd35vVhAHzUkCXQI870ijTu8VilytCRkJ1QwnYB0718ozpKTiUSNoSQNUv550= X-Received: by 2002:a05:651c:50f:b0:32b:3aeb:5533 with SMTP id 38308e7fff4ca-33054f524bamr39929691fa.3.1752591563688; Tue, 15 Jul 2025 07:59:23 -0700 (PDT) MIME-Version: 1.0 References: <18985-64431d78bcabae95@postgresql.org> In-Reply-To: From: =?UTF-8?Q?Erik_Dob=C3=A1k?= Date: Tue, 15 Jul 2025 16:59:11 +0200 X-Gm-Features: Ac12FXwQU1qCVErIsRFbzjOnZ7sqwzUbSZ9RxLjXtf7PizrDnJ-9axid-NzNu_o Message-ID: Subject: Re: BUG #18985: fast shutdown does not close connections from qlik data gateway data movement aka. replicate To: "David G. Johnston" Cc: pgsql-bugs@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000970f940639f9051d" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000970f940639f9051d Content-Type: text/plain; charset="UTF-8" ah yes now i see. we could reproduce it on 14.8 and 14.18. i E On Tue, 15 Jul 2025, 16:35 David G. Johnston, wrote: > On Tuesday, July 15, 2025, PG Bug reporting form > wrote: > >> The following bug has been logged on the website: >> >> Bug reference: 18985 >> Logged by: Erik Dobak >> Email address: erik.dobak@gmail.com >> PostgreSQL version: 14.8 >> Operating system: Windows server 2022 >> Description: >> >> We use postgresql 14.18 at a windows server 2022 as a repository db for >> the >> Qlik Sense product. Additionally we connect to the postgresql db from a >> remote server running Qlik Data Gateway Data Movement server which >> replicates data and changes to various cloud DBs by using replication >> slots. >> > > Can you replicate this on a supported version of PostgreSQL? > > David J. > --000000000000970f940639f9051d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
ah yes now i see. we could reproduce it on 14.8 and 14.18= . i

E

On Tue, 15 Jul 2025, 16:35 David G. Johnston, <david.g.johnston@gmail.com> wrote:
=
On Tuesday, July 15, 2025= , PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been = logged on the website:

Bug reference:=C2=A0 =C2=A0 =C2=A0 18985
Logged by:=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Erik Dobak
Email address:=C2=A0 =C2=A0 =C2=A0 erik.dobak@gmail.com
PostgreSQL version: 14.8
Operating system:=C2=A0 =C2=A0Windows server 2022
Description:=C2=A0 =C2=A0 =C2=A0 =C2=A0

We use postgresql 14.18 at a windows server 2022 as a repository db for the=
Qlik Sense product. Additionally we connect to the postgresql db from a
remote server running Qlik Data Gateway Data Movement server which
replicates data and changes to various cloud DBs by using replication slots= .

Can you replicate this on a supported vers= ion of PostgreSQL?

David J.=C2=A0
--000000000000970f940639f9051d--