Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication
Kiran K V <kirankv.1982@gmail.com>
From: Kiran K V <kirankv.1982@gmail.com>
To: pgsql-general@postgresql.org
Date: 2025-07-11T17:39:38Z
Lists: pgsql-general
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-stream Regards, Kiran