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 1ubmZC-005Ceu-R7 for pgsql-bugs@arkaria.postgresql.org; Tue, 15 Jul 2025 20:47:58 +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 1ubmZA-005Eit-Ur for pgsql-bugs@arkaria.postgresql.org; Tue, 15 Jul 2025 20:47:57 +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 1ubkYQ-004hd0-IP for pgsql-bugs@lists.postgresql.org; Tue, 15 Jul 2025 18:39:03 +0000 Received: from mail-lj1-x22c.google.com ([2a00:1450:4864:20::22c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1ubkYP-007RuX-1R for pgsql-bugs@lists.postgresql.org; Tue, 15 Jul 2025 18:39:02 +0000 Received: by mail-lj1-x22c.google.com with SMTP id 38308e7fff4ca-32b7f41d3e6so2067211fa.1 for ; Tue, 15 Jul 2025 11:39:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1752604740; x=1753209540; 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=3+LTH0ntNCeFYiIzj5iUKQAL/bko4CoIImghLz34Hh4=; b=iAkpKbNQIty2QlUaHC0dXuegZiKprn1B4MF34TLJdWIAtLRgfcNVoYxWT4VpdLqz05 r6Oy5JywwtcaWktT2SVhzqEEcEXwTTSaTZaudApYqpQPAf7JDRBvF/TZ8SAQ14CuPdAu DLM3SHZRVP0SyfKbVv9wcyGYPLNa/jwBj+aoDVsrubsDO3ELnp5jSLZ72w2zIbS7w/jm 6v4pPXG07YkFiicDW4v1TPbgKRKF5O35q09BcLr1pQPCmyTWdui2WUi7/o2VG/Jhwes0 nJLsqZzveq9b8kczOvLPFdoLx2mlh9ozDoTSnlKyKPf5VrcjvGyqN8dugVssE2/40QV/ h1lQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1752604740; x=1753209540; 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=3+LTH0ntNCeFYiIzj5iUKQAL/bko4CoIImghLz34Hh4=; b=LIO+IKjahMi/JPGqWvfO7TjSSBVzDYRLBVR1BuDpXTHhnBObdj4/w9WPsmJyng8y2e ZZ5Q+8T2jNyM/YqouoL55+str3w8lUKfUyAR4bs9yWTvz5exfCF52rq4y5UE087VE/Uo BvEJVY52YOEAgfkSmNcNOiX2TprcL9c4FGqvv4XV3qIQtMyv1kmqbdyabbR8llQ2+4rr CzU30jXeLv3K20ilEuV1bURPaKOJUA0oukotsy1S1XBrvgmQmZ6DPZ0S6MsqlXASsvtr YhgmyZ1Dt0gsMpEjsSshgHZnaL6qQa4aveIsxTY8x+nVbCz2I8qhznknz2UFicDbInaw QeVw== X-Forwarded-Encrypted: i=1; AJvYcCW2XdN/jd3KOhS1tv5PRRDXIqWsVuCd1ouwJH3EL+DZG4inmlDIwy/kFzgaXOKgcuqvcPDDVYlhtSsN@lists.postgresql.org X-Gm-Message-State: AOJu0YxcTV75Zw3dG8BRSgniV20fNCp1WFvoiQkHLPFl9QQGzpK+bg1C So8xixfX/d7VGRAe5+6MbD1GwV3HgaWipC/P0ZfXB0Q+Ut3mzym2tq48qjFv/q/4XPiOA1DrLWs 5gYs6KKofm+KZleKCjYurm2p6X56CjNw= X-Gm-Gg: ASbGncs69JJE8yLDdOf7mVIiU1DEbdpfgNcEmmWpkewuWX7s+D11plh7T7BWDAZ4H4b I5puCqKcH/rDHBVyrXu5D9nOcmaiMqwNuPBseMKgeZ6n5roqu5xha9/YJh7hH4+papIGoe4nPbW NNGe+77ZSpliX+IpArtQEwHQ40PWJ2vsPdCu7yAZp9vvjjFyRV+k68mhGMmzflnzvNEnMcN/833 uACxVdc6e1HQBavV/6EqsE5b5vtoTrVdHGOIUbASoC9K+4nY3DU X-Google-Smtp-Source: AGHT+IG2o0euIO3tQxT66dfPo5KlxkXbNCEkMjntrcwf9gOO8akZunXsIa7Mdy5LOXSj/z8FgNwNqIoW1Wf/Vxvcc5s= X-Received: by 2002:a05:651c:b24:b0:308:ee65:7f44 with SMTP id 38308e7fff4ca-3308e85bf12mr932111fa.8.1752604739333; Tue, 15 Jul 2025 11:38:59 -0700 (PDT) MIME-Version: 1.0 References: <18985-64431d78bcabae95@postgresql.org> <923969.1752595701@sss.pgh.pa.us> <938838.1752604022@sss.pgh.pa.us> In-Reply-To: <938838.1752604022@sss.pgh.pa.us> From: =?UTF-8?Q?Erik_Dob=C3=A1k?= Date: Tue, 15 Jul 2025 20:38:46 +0200 X-Gm-Features: Ac12FXywsx9J2SfejTSaCivdEsV3v1t1ThuJzkGxoFgkv7y35CXiRLCD-QvxHsU Message-ID: Subject: Re: BUG #18985: fast shutdown does not close connections from qlik data gateway data movement aka. replicate To: Tom Lane Cc: "David G. Johnston" , pgsql-bugs@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000eb71f20639fc162f" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000eb71f20639fc162f Content-Type: text/plain; charset="UTF-8" nice thanks i will study that. E On Tue, 15 Jul 2025, 20:27 Tom Lane, wrote: > =?UTF-8?Q?Erik_Dob=C3=A1k?= writes: > > did not know about plugins in postgres. how would one check if there is > > some? > > Check the pg_replication_slots view on the publisher for the slot(s) > being used for Qlik replication. If the "plugin" column says > something other than "pgoutput" then a nonstandard plugin is being > used. > > regards, tom lane > --000000000000eb71f20639fc162f Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
nice thanks i will study that.
E

On Tue, 15 Jul 2025, 20:27 Tom Lane, <tgl@sss.pgh.pa.us> wrote:
=3D?UTF-8?Q?Erik_Dob=3DC3=3DA1k?=3D= <erik.dobak@gmail.com> writes:
> did not know about plugins in postgres. how would one check if there i= s
> some?

Check the pg_replication_slots view on the publisher for the slot(s)
being used for Qlik replication.=C2=A0 If the "plugin" column say= s
something other than "pgoutput" then a nonstandard plugin is bein= g
used.

=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
--000000000000eb71f20639fc162f--