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