MIME-Version: 1.0
From: Kiran K V <kirankv.1982@gmail.com>
Date: Fri, 11 Jul 2025 23:09:38 +0530
Message-ID: <CAGv0ivr+f9azy-ef7yNVFB_T5Opnmb40BzuRd=pLvCCf7JGphw@mail.gmail.com>
Subject: Query regarding support of test_decoding and PGReplicationStream with
 Standby Logical Replication
To: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="0000000000000be1f30639aaccd8"
Archived-At: <https://www.postgresql.org/message-id/CAGv0ivr%2Bf9azy-ef7yNVFB_T5Opnmb40BzuRd%3DpLvCCf7JGphw%40mail.gmail.com>
Precedence: bulk

--0000000000000be1f30639aaccd8
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

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

<div dir=3D"ltr">
<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 standalone instance of PostgreSQL 16 and performing=20
logical replication by creating replication slots and utilizing the JDBC
 replication stream API (PGReplicationStream)=C2=A0 with the test_decoding=
=20
plugin.<br><br>Could you please confirm whether this approach of logical
 replication is supported from a standby system? Specifically, does the=20
standby system support the test_decoding plugin and the JDBC=20
PGReplicationStream API for streaming changes ?<br><div><br></div><div>Refe=
rence to=C2=A0JDBC Logical replication - <a href=3D"https://jdbc.postgresql=
.org/documentation/server-prepare/#example-96-create-logical-replication-st=
ream" target=3D"_blank">https://jdbc.postgresql.org/documentation/server-pr=
epare/#example-96-create-logical-replication-stream</a></div><div><br></div=
><div>Regards,</div><div>Kiran</div></div>

<br></div>

--0000000000000be1f30639aaccd8--