public inbox for [email protected]  

help / color / mirror / Atom feed

From: DINESH  NAIR <[email protected]>
To: Kiran K V <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication
Date: Tue, 15 Jul 2025 18:13:44 +0000
Message-ID: <PN4P287MB4381ADAE837D0246C0E8DA8B9C57A@PN4P287MB4381.INDP287.PROD.OUTLOOK.COM> (raw)
In-Reply-To: <CAGv0ivr+f9azy-ef7yNVFB_T5Opnmb40BzuRd=pLvCCf7JGphw@mail.gmail.com>
References: <CAGv0ivr+f9azy-ef7yNVFB_T5Opnmb40BzuRd=pLvCCf7JGphw@mail.gmail.com>


Hi Kiran,

Are we trying to perform logical replication from create replication slots 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 utilizing 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-create-logical-replication-stre...

Regards,
Kiran





Thanks

Dinesh


________________________________
From: Kiran K V <[email protected]>
Sent: Friday, July 11, 2025 11:09 PM
To: [email protected] <[email protected]>
Subject: Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication

You don't often get email from [email protected]. Learn why this is important<https://aka.ms/LearnAboutSenderIdentification;
Caution: This email was sent from an external source. Please verify the sender’s 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 utilizing 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-create-logical-replication-stre...

Regards,
Kiran

view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication
  In-Reply-To: <PN4P287MB4381ADAE837D0246C0E8DA8B9C57A@PN4P287MB4381.INDP287.PROD.OUTLOOK.COM>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox