MIME-Version: 1.0
From: Kiran K V <kirankv.1982@gmail.com>
Date: Fri, 11 Jul 2025 17:08:26 +0530
Message-ID: <CAGv0ivo-mWbs946rzjsAS3E7URhofQSbt3kX__hq7ysLScq3DQ@mail.gmail.com>
Subject: Query regarding support of test_decoding and PGReplicationStream with
 Standby Logical Replication
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000043f47b0639a5c0a0"
Archived-At: <https://www.postgresql.org/message-id/CAGv0ivo-mWbs946rzjsAS3E7URhofQSbt3kX__hq7ysLScq3DQ%40mail.gmail.com>
Precedence: bulk

--00000000000043f47b0639a5c0a0
Content-Type: text/plain; charset="UTF-8"

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

--00000000000043f47b0639a5c0a0
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi,=C2=A0</div><div><br></div><div>I have a question =
regarding the new feature introduced in PostgreSQL 16 that enables logical =
replication from a standby server.</div><br>Currently, we are using a stand=
alone instance of PostgreSQL 16 and performing logical replication by creat=
ing replication slots and utilizing the JDBC replication stream API (PGRepl=
icationStream)=C2=A0 with the test_decoding plugin.<br><br>Could you please=
 confirm whether this approach of logical replication is supported from a s=
tandby system? Specifically, does the standby system support the test_decod=
ing plugin and the JDBC PGReplicationStream API for streaming changes ?<br>=
<div><br></div><div>Reference to=C2=A0JDBC Logical replication - <a href=3D=
"https://jdbc.postgresql.org/documentation/server-prepare/#example-96-creat=
e-logical-replication-stream">https://jdbc.postgresql.org/documentation/ser=
ver-prepare/#example-96-create-logical-replication-stream</a></div><div><br=
></div><div>Regards,</div><div>Kiran</div></div>

--00000000000043f47b0639a5c0a0--