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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tkyjV-008JO7-Mf
	for pgsql-general@arkaria.postgresql.org; Thu, 20 Feb 2025 05:04:21 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tkyjU-0010lQ-47
	for pgsql-general@arkaria.postgresql.org; Thu, 20 Feb 2025 05:04:20 +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 <jethish777@gmail.com>)
	id 1tkyjT-0010kR-Oe
	for pgsql-general@lists.postgresql.org; Thu, 20 Feb 2025 05:04:19 +0000
Received: from mail-qv1-xf2f.google.com ([2607:f8b0:4864:20::f2f])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <jethish777@gmail.com>)
	id 1tkyjS-001q9P-0X
	for pgsql-general@lists.postgresql.org;
	Thu, 20 Feb 2025 05:04:19 +0000
Received: by mail-qv1-xf2f.google.com with SMTP id 6a1803df08f44-6df83fd01cbso2399076d6.2
        for <pgsql-general@lists.postgresql.org>; Wed, 19 Feb 2025 21:04:18 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1740027857; x=1740632657; darn=lists.postgresql.org;
        h=to:subject:message-id:date:from:mime-version:from:to:cc:subject
         :date:message-id:reply-to;
        bh=COsZNv9b77EQM/fGCuGBpuGUhP3rOOqGxnqwK4NSoUY=;
        b=jXFSvL9ffPUCFlfJrTGXvU7oEL4ADHBrwgadcxMzHm7f2ICCUDDgPJ49uh4YQr5zrG
         EzH5iLlLKUBIesS2TBX9ugVhF3wgf/isSlMH0njoF0FXqQ4RKBqnITFp9tRQm9e5RHKO
         rektTD/1mIBZksIyhz7ZU1vovjgdSHFQ5dgWiFDDtS5tYuvQ/VoFlAwPhiH1cXvAldVP
         u0kC2BOorjmmT0+IiJ9DYSi1BIIUG4jxHTRSX2AyxgZ/Atn6lu2HvL1wyUn8fdQaUabJ
         PRfRV10ZncJ2DDcnriwgf8VNefgQ3FhHMnPV6VNa/lUJAsWzTf3jnEAvSKUmwTKp1JMr
         8I/w==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1740027857; x=1740632657;
        h=to:subject:message-id:date:from:mime-version:x-gm-message-state
         :from:to:cc:subject:date:message-id:reply-to;
        bh=COsZNv9b77EQM/fGCuGBpuGUhP3rOOqGxnqwK4NSoUY=;
        b=OSpgRbncPyHPa0irEZzOB9UNxQgxJAG6R1CFPmbZU6hY9IlVvsskMXKPWw9sJztI83
         5ZzACD6Tq3npSRu1eiZs3ltA/fVcgQkA2RdlkxYXzE8OoCfN+lqZGNBJxipqMPWGqv92
         1rSYLJP6ZGKuVJxIEbvioyzrF6ja1k8ZXIx4JMdSYuxR3JEtxfx1W3KgwjpHMsCk8KRS
         nWTuZBFrdOyS9ZnJFJltvT9hhGP2FPhWMIumYfDCixdWKO4/HB2zzN1CAIm9EmB7SOBF
         C71czCE76HdFewFS2dTOQk5OmTc82jF32XsxU8bz/9xyxoRIm6wrP4Eev8JqCr+q6sXa
         +F8Q==
X-Gm-Message-State: AOJu0YxVB/LjbLPdU9gSzb4xQ9hhcgZLV/m3sVa6djbTaBKRH9u0+2Uq
	ah/6K6Y1/deXY66DdbrMMLh9ELGlfO2rAN+din4m3aU2xmOVn7ZrtRkuQXJka/5kDPQQ7e5ExHu
	4oTAmdEAGj/J/BcDS4GEWq58ayco6VQ==
X-Gm-Gg: ASbGncuBxMB088hKWvTc9JV//gn9QJNGQjUHAxLZOcbCtG4A70YeqMNSz0bUvEc7NPG
	HLZ6ievO0vxGk1lVRZyTZ2ro5FHzq9LiymvUZ5ip9gMnZJVfwM+olJ9px+tIj+SfzoAqDXCWYS/
	QZ9SNU86Tt588oEw==
X-Google-Smtp-Source: AGHT+IF+e3xjyHlBDoQELY1Uy/ufIuiRtMPRN9jvqbYLe4a1zY386svOXHFfZUtj3/n2Ci5oD/6N9SAxGcr+1sKqGXY=
X-Received: by 2002:a05:6214:c84:b0:6e6:630c:71e8 with SMTP id
 6a1803df08f44-6e6974fc67cmr85126746d6.7.1740027856860; Wed, 19 Feb 2025
 21:04:16 -0800 (PST)
MIME-Version: 1.0
From: Jethish Jethish <jethish777@gmail.com>
Date: Thu, 20 Feb 2025 10:34:05 +0530
X-Gm-Features: AWEUYZmGdB4eHP0elojiruZVafyL-FReolKy0Ob7d2gbTsFG3ZMRcePz2VsMeeo
Message-ID: <CAKeSjMjBTxSVHq==8UuNBwAXjDC+vonsdJEd3TndN2-PP=NzpQ@mail.gmail.com>
Subject: Logical decoding
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000004ebb24062e8bce56"
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/CAKeSjMjBTxSVHq%3D%3D8UuNBwAXjDC%2BvonsdJEd3TndN2-PP%3DNzpQ%40mail.gmail.com>
Precedence: bulk

--0000000000004ebb24062e8bce56
Content-Type: text/plain; charset="UTF-8"

Hi everyone,

Is there is any option to perform logical decoding on an active replication
slot.
I'm trying to decode a replication slot but it throughs an error as below.

ERROR: replication slot "my_sub" is active for PID 2525720

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

<div dir=3D"auto">Hi everyone,<div dir=3D"auto"><br></div><div dir=3D"auto"=
>Is there is any option to perform logical decoding on an active replicatio=
n slot.</div><div dir=3D"auto">I&#39;m trying to decode a replication slot =
but it throughs an error as below.</div><div dir=3D"auto"><br></div><div di=
r=3D"auto">ERROR: replication slot &quot;my_sub&quot; is active for PID 252=
5720</div></div>

--0000000000004ebb24062e8bce56--