Re: Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication - Mailing list pgsql-general

From DINESH NAIR
Subject Re: Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication
Date
Msg-id PN4P287MB4381ADAE837D0246C0E8DA8B9C57A@PN4P287MB4381.INDP287.PROD.OUTLOOK.COM
Whole thread Raw
In response to Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication  (Kiran K V <kirankv.1982@gmail.com>)
Responses Re: Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication
List pgsql-general

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 ?


Regards,
Kiran




Thanks 


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 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’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 ?


Regards,
Kiran

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Removing terminal period from varchar string in table column
Next
From: Thom Brown
Date:
Subject: Re: Removing terminal period from varchar string in table column