public inbox for [email protected]
help / color / mirror / Atom feedFrom: Kiran K V <[email protected]>
To: DINESH NAIR <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication
Date: Wed, 16 Jul 2025 06:23:49 +0530
Message-ID: <CAGv0ivpFR1sv_37xa-xFdXqJr7TGNyAogzG7xqD6VSj-S8Dv4w@mail.gmail.com> (raw)
In-Reply-To: <PN4P287MB4381ADAE837D0246C0E8DA8B9C57A@PN4P287MB4381.INDP287.PROD.OUTLOOK.COM>
References: <CAGv0ivr+f9azy-ef7yNVFB_T5Opnmb40BzuRd=pLvCCf7JGphw@mail.gmail.com>
<PN4P287MB4381ADAE837D0246C0E8DA8B9C57A@PN4P287MB4381.INDP287.PROD.OUTLOOK.COM>
Hi Dinesh,
Yes, that is correct.
Regards,
Kiran
On Tue, Jul 15, 2025 at 11:43 PM DINESH NAIR <[email protected]>
wrote:
>
> 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 ?
>
> Reference to JDBC Logical replication -
> https://jdbc.postgresql.org/documentation/server-prepare/#example-96-create-logical-replication-stre...
>
> Regards,
> Kiran
>
>
>
>
> Thanks
>
> Dinesh
>
>
> ------------------------------
> *From:* Kiran K V <[email protected]>
> *Sent:* Friday, July 11, 2025 11:09 PM
> *To:* [email protected] <[email protected]>
> *Subject:* Query regarding support of test_decoding and
> PGReplicationStream with Standby Logical Replication
>
> You don't often get email from [email protected]. Learn why this is
> important <https://aka.ms/LearnAboutSenderIdentification;
> 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 ?
>
> Reference to JDBC Logical replication -
> https://jdbc.postgresql.org/documentation/server-prepare/#example-96-create-logical-replication-stre...
>
> Regards,
> Kiran
>
>
view thread (3+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication
In-Reply-To: <CAGv0ivpFR1sv_37xa-xFdXqJr7TGNyAogzG7xqD6VSj-S8Dv4w@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox