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 1ucMpy-00C8Ea-EY for pgsql-general@arkaria.postgresql.org; Thu, 17 Jul 2025 11:31:42 +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 1ucMpw-001T6s-6M for pgsql-general@arkaria.postgresql.org; Thu, 17 Jul 2025 11:31:40 +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 1ubqPL-006txy-C2 for pgsql-general@lists.postgresql.org; Wed, 16 Jul 2025 00:54:04 +0000 Received: from mail-ej1-x62f.google.com ([2a00:1450:4864:20::62f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1ubqPJ-007UlN-2J for pgsql-general@postgresql.org; Wed, 16 Jul 2025 00:54:02 +0000 Received: by mail-ej1-x62f.google.com with SMTP id a640c23a62f3a-ae223591067so1039303666b.3 for ; Tue, 15 Jul 2025 17:54:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1752627240; x=1753232040; darn=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=z71WUMmmIw3aeuyTdQrd6Q6+HK34Q4YHTIlm2PkwAQA=; b=lkWd+L2PCAZYzBWP7HH14PuDRUEhF8iscLuQD4ijt6CQLl7A/ZQhDzGmB72MLqK73T txO22LhNUFjW2cYBY9uUiYLrxpAKdKS5gwHUxU6f3A23xsJHj/XTivNQTvqz6e6d/7mD HUHvQkHhigJjH5WFZHrsL72qUbyFBfm0nNNKyARGE7URVYrVC7Fce1X6w3G97T02lBoq fUKzRul7yM6lwkHtgqNECQF94AofjGO4g1AlIS6+9QW+kqZKg0LepBTSIKej+IEQa7xI SOE5akDQC5glzD113h2GnDPi5yF1peqYFk78eJQAKMo1gGWB+c77DZbMBtYg1cmH+bRJ lwzA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1752627240; x=1753232040; 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=z71WUMmmIw3aeuyTdQrd6Q6+HK34Q4YHTIlm2PkwAQA=; b=w4g68eTnyPXlcMydMqKYrWjpdQpl2vot7x25woEalNiKrecexsc7beLKQ3zvNGvIPK d8ruAYLnWIauX3LJdfk231rhM1mR3fgzX6cYrcdpO3U8ATI4M5pIMgO/OV5zlnJOuyu/ BRl8I2daJ8gOJeF9cqfVxjbAD73ZbqMzg9oxs9WZj2a+XjEJjMqRp3AYEJt5djXGvl+1 avtC57Jali91mL1rmekFiOqOOsRfVAPq2TmUo3F+61EqvPmwEi+rQnCTkr9kk2U4OM9I WKBRsXw0kkgMDSYe/WKrT7HF4h+MtsxdxlCDg+48LmMPUyXgEL8sdSIk50C5hwSKlnp9 EJkg== X-Gm-Message-State: AOJu0Ywrai0fjwzlzzurFx2apQWz9PNnS1n2pd3h77Usldv2Pg6cZ+Yz Pfa+5Va9HphSD+jDu7ZIAc3weBuPurHsvanV6dyRQ7jV6GaZDRuJotaIdw8vpRLw6BUP/Hg6G+T WyY+qqkxpCRGgMiJnzYN1HZvwCDMxxKxDJg== X-Gm-Gg: ASbGncu/KGp0yCpTlKC1zAIAXy1haMGDQRVoCXe3u0avK1+fJlwqv+a2BNsf6pdukzm ss/3ffGmppr7Iu6U4ssUkr+6yRgAjtuz+XrIZ/yZYfE9tK0fEqjrvKZ4RscucIsOObFljMNUiZs jmt1ANGx0FEU10tFEuRP+Pet9cbioIgBueZRn3cWRaVH3KJS80a3Nz6E6+oSkss7pRP0E9qbh14 OkMME0Ln1Ph/cFC68Mq/GOlshYmAEHpjXTOVfa0ErasIUU5MXti X-Google-Smtp-Source: AGHT+IHegnC+waMLzzS8bJWZHk7g7D2u1TW/LZs0z3tr7tG9ne86LrkxTG7y0oJeObHKfSvQbxjC+L6mTG4jQ7Vr3AE= X-Received: by 2002:a17:906:9fc9:b0:ae6:c232:efb8 with SMTP id a640c23a62f3a-ae9cddd5fc6mr66941566b.17.1752627239692; Tue, 15 Jul 2025 17:53:59 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Kiran K V Date: Wed, 16 Jul 2025 06:23:49 +0530 X-Gm-Features: Ac12FXxdSiv4rPYHcqLGwfdU8FnCkNQWQyI1Uqma_lTR3z21Hcg9_v-tZfpm2mo Message-ID: Subject: Re: Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication To: DINESH NAIR Cc: "pgsql-general@postgresql.org" Content-Type: multipart/alternative; boundary="0000000000000bb038063a015472" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000000bb038063a015472 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Dinesh, Yes, that is correct. Regards, Kiran On Tue, Jul 15, 2025 at 11:43=E2=80=AFPM DINESH NAIR wrote: > > Hi Kiran, > > Are we trying to perform logical replication from create replication slot= s > on a standby server and use logical decoding plugins(JDBC > PGReplicationStream API) to stream changes from the standby > Is my understanding correct? > > > > > Hi, > > I have a question regarding the new feature introduced in PostgreSQL 16 > that enables logical replication from a standby server. > > Currently, we are using a standalone instance of PostgreSQL 16 and > performing logical replication by creating replication slots and utilizin= g > the JDBC replication stream API (PGReplicationStream) with the > test_decoding plugin. > > Could you please confirm whether this approach of logical replication is > supported from a standby system? Specifically, does the standby system > support the test_decoding plugin and the JDBC PGReplicationStream API for > streaming changes ? > > Reference to JDBC Logical replication - > https://jdbc.postgresql.org/documentation/server-prepare/#example-96-crea= te-logical-replication-stream > > Regards, > Kiran > > > > > Thanks > > Dinesh > > > ------------------------------ > *From:* Kiran K V > *Sent:* Friday, July 11, 2025 11:09 PM > *To:* pgsql-general@postgresql.org > *Subject:* Query regarding support of test_decoding and > PGReplicationStream with Standby Logical Replication > > You don't often get email from kirankv.1982@gmail.com. Learn why this is > important > Caution: This email was sent from an external source. Please verify the > sender=E2=80=99s identity before clicking links or opening attachments. > Hi, > > I have a question regarding the new feature introduced in PostgreSQL 16 > that enables logical replication from a standby server. > > Currently, we are using a standalone instance of PostgreSQL 16 and > performing logical replication by creating replication slots and utilizin= g > the JDBC replication stream API (PGReplicationStream) with the > test_decoding plugin. > > Could you please confirm whether this approach of logical replication is > supported from a standby system? Specifically, does the standby system > support the test_decoding plugin and the JDBC PGReplicationStream API for > streaming changes ? > > Reference to JDBC Logical replication - > https://jdbc.postgresql.org/documentation/server-prepare/#example-96-crea= te-logical-replication-stream > > Regards, > Kiran > > --0000000000000bb038063a015472 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Dinesh,

Yes, that is corr= ect.=C2=A0

Regards,
Kiran
On Tue, Jul 15, 2025 at 11:43=E2=80=AFPM DINESH NAIR <Dinesh_Nair@iitmpravartak.net<= /a>> wrote:
<= div class=3D"msg-2947974300137827646">

Hi Kiran,

Are we trying to perform logical replication from create replication slots = on a standby server and use logical decoding plugins(JDBC PGReplicationStre= am API) to stream changes from the standby
Is=C2=A0 my understanding correct?




=E2=80=82=E2=80= =82=E2=80=82=E2=80=82=E2=80=82=E2=80=82=E2=80=82=E2=80=82=E2=80=82=E2=80=82= =E2=80=82=E2=80=82Hi,=C2=A0

I have a question regarding the new feature introduced in PostgreSQL 16 tha= t enables logical replication from a standby server.

Currently, we are using a= standalone instance of PostgreSQL 16 and performing logical replication by= creating replication slots and utilizing the JDBC replication stream API (= PGReplicationStream)=C2=A0 with the test_decoding plugin.

Could you please confirm = whether this approach of logical replication is supported from a standby sy= stem? Specifically, does the standby system support the test_decoding plugi= n and the JDBC PGReplicationStream API for streaming changes ?

Regards,
Kiran




Thanks=C2=A0


Dinesh


From:= Kiran K V <= kirankv.1982@gmail.com>
Sent: Friday, July 11, 2025 11:09 PM
To: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Subject: Query regarding support of test_decoding and PGReplicationS= tream with Standby Logical Replication
=C2=A0
You don't often get email from kirankv.1982@gmail.com. Learn why this is important
Caution: This email was sent from a= n external source. Please verify the sender=E2=80=99s identity before click= ing links or opening attachments.
Hi,=C2=A0

I have a question regarding the new feature introduced in PostgreSQL 1= 6 that enables logical replication from a standby server.

Currently, we are using a standalone instance of PostgreSQL 16 and performi= ng logical replication by creating replication slots and utilizing the JDBC= replication stream API (PGReplicationStream)=C2=A0 with the test_decoding = plugin.

Could you please confirm whether this approach of logical replication is su= pported from a standby system? Specifically, does the standby system suppor= t the test_decoding plugin and the JDBC PGReplicationStream API for streami= ng changes ?


Regards,
Kiran

--0000000000000bb038063a015472--