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 1ubhld-004CLt-0a for pgsql-bugs@arkaria.postgresql.org; Tue, 15 Jul 2025 15:40:29 +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 1ubhlZ-0035QX-OG for pgsql-bugs@arkaria.postgresql.org; Tue, 15 Jul 2025 15:40:26 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ubh6P-002j8B-Ja for pgsql-bugs@lists.postgresql.org; Tue, 15 Jul 2025 14:57:54 +0000 Received: from mail-lj1-x22d.google.com ([2a00:1450:4864:20::22d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1ubh6O-007tWH-0j for pgsql-bugs@lists.postgresql.org; Tue, 15 Jul 2025 14:57:53 +0000 Received: by mail-lj1-x22d.google.com with SMTP id 38308e7fff4ca-32b43cce9efso43369741fa.3 for ; Tue, 15 Jul 2025 07:57:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1752591471; x=1753196271; 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=OHjPHD3MMARTbr3TvtSqH3OyXBdMp5O7apNWxRR+4IU=; b=bwxX1udajXw4uxnW2sl5b/9JIHMNoIkDMMCyhTWAdYy1wdVfNkJf/YMjkIPWIKeJwa hAJqWpGjziq2itQ0U0wVZkva+uikK8PaYa63TGn/ksB6pz0vY0pulCaj6kJNNjmSwua4 4/xVQK0s/cvBVIi1VuhOzpqFvDjdpZXXB88wO5g8s8JsbA7E8553n6xXcKWhxfHv46Ma LTJcVih49zINi77KElKQLsDKW3qMOj13eyz6v2lAZJpuNf9ACINRBSz6+f67df6y1Gu+ LH2baUdvjEIJP3sifroVE8UdUnJwK3iQR7SMxcx7k7iQB/78CYIb03Jb4KeqY+K+lB6U qA9Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1752591471; x=1753196271; 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=OHjPHD3MMARTbr3TvtSqH3OyXBdMp5O7apNWxRR+4IU=; b=bdWUjoWvU8m/ygSq4pt1RKLFARgPRxQLldqQFCx8s6Ce2Zreuv/5EIcbNsRQNvbpdR WAseMz0dZ1x8t5ga1e0Wzn7ChSveUeCOSNcvdKhNWEUwmmkf0mzPDaZ82aXn7uBT6Hu4 rQ4JnremJhflTeNrUrSsfm1xGYFH8VM01hcmuZqCqbalZKVytK06jdgRSHPZ/dMVGOt5 d73R4SE2Rjnqm7fjkqqWhRBnCe6dNKmXKgTXc62iTwoBiycZkZgOEJXTBJymhjPvtMJ2 tsLQEwLOBwvAsCTYRMZZ3MB2DFWOsaHbdDQLwOaJ+zm8NUdTpqYSoqg8CTg05rFHBYa4 7Y3Q== X-Gm-Message-State: AOJu0YxwVsz1IFlOg3U2xzNZH9Niq45uNKPyF6f2ETpbK1VLHpZwIwKl /K8Tn8GmemBbLrek+AQRFEQOMkpSPeExjkTRvOXrJi6Qc7dh8w1TBh8QPo1kGbbMucUIz5hADOx C1fkBoK/2chfEEm750xeCcHddc4gSTDs= X-Gm-Gg: ASbGncuKpDcnLqNC27fkiQfZcAfVn3B6NvQ+EqdQDuK3dLELj+wL5ju0iL21FaYHim8 gaDVsCL/tr+vz5RQURrWbS4qbOn5FhAIxuNUg4LwvWuTac7WA01i9NHja0BB+BJoKAS8BK9Mrqj WbG5cu1M8Hx1mkAr/hOQ3Y+qkHocK9sked0sBXCD5B5AgmklrMutbZlpn0ol7AFJWNZ0UrjZqie kxrrLKf2CLY1EOKuTfUgaERdcg= X-Google-Smtp-Source: AGHT+IGHMN+BsposqOqs05uXO6OQ3S7dvRn7MXHbpv34hWegrVfOFKGx+svQFgTxIjP4iPnZaieO91qKn1YpkwBHb8A= X-Received: by 2002:a2e:8687:0:b0:32b:a7d2:a8cd with SMTP id 38308e7fff4ca-330533d83a5mr47303241fa.23.1752591470840; Tue, 15 Jul 2025 07:57:50 -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:57:37 +0200 X-Gm-Features: Ac12FXwzVjFG-hCzSgaWHq88WxgVeCfuaud8IxIVutAshXhwOz3aPfcWu0U4xrI 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="0000000000000e4ff00639f9006f" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000000e4ff00639f9006f Content-Type: text/plain; charset="UTF-8" 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. > 14.18 is afaik supported. it is runn:ng on 14.8. so yes i could replicate this on a supported version. E > --0000000000000e4ff00639f9006f Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


On Tue, 15 Jul 2025, 16:35 David= G. Johnston, <david.g.joh= nston@gmail.com> wrote:
On Tuesday, July 15, 2025, PG Bug reporting form <nor= eply@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

14.18 is afaik = supported. it is runn:ng on 14.8. so yes i could replicate this on a suppor= ted version.

E
--0000000000000e4ff00639f9006f--