public inbox for [email protected]help / color / mirror / Atom feed
Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication 3+ messages / 2 participants [nested] [flat]
* Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication @ 2025-07-11 17:39 Kiran K V <[email protected]> 2025-07-15 18:13 ` Re: Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication DINESH NAIR <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Kiran K V @ 2025-07-11 17:39 UTC (permalink / raw) To: 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-stre... Regards, Kiran ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication 2025-07-11 17:39 Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication Kiran K V <[email protected]> @ 2025-07-15 18:13 ` DINESH NAIR <[email protected]> 2025-07-16 00:53 ` Re: Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication Kiran K V <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: DINESH NAIR @ 2025-07-15 18:13 UTC (permalink / raw) To: Kiran K V <[email protected]>; pgsql-general 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication 2025-07-11 17:39 Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication Kiran K V <[email protected]> 2025-07-15 18:13 ` Re: Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication DINESH NAIR <[email protected]> @ 2025-07-16 00:53 ` Kiran K V <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Kiran K V @ 2025-07-16 00:53 UTC (permalink / raw) To: DINESH NAIR <[email protected]>; +Cc: pgsql-general 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 > > ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-07-16 00:53 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-07-11 17:39 Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication Kiran K V <[email protected]> 2025-07-15 18:13 ` DINESH NAIR <[email protected]> 2025-07-16 00:53 ` Kiran K V <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox