Postgres Pro
Downloads
Home   >   mailing lists

Logical Replication - Initial Snapshot Only mode - Mailing list pgsql-admin

From Raj kumar
Subject Logical Replication - Initial Snapshot Only mode
Date
Msg-id CACxU--XizpxQwQooKhQJe4Dy_sP5+LQTm4WOHjC_zYMQZm7BJw@mail.gmail.com
Whole thread Raw
List pgsql-admin
Tree view
Hi,

I have a use case to take only the Initial Snapshot from Source PG to Destination PG using logical replication. Once the initial snapshot is done, replication should stop automatically. Then, I need to start the CDC manually. How can I achieve this using Logical Replication?

For instance, Debezium Connector supports this using 'Snapshot.mode=Inital_only' for Full Initial load and stop automatically. For CDC, 'Snapshot.mode=never' helps. I'm expecting something similar to that.

Thanks,
Raj kumar Narendiran.

pgsql-admin by date:

Previous
From: jian xu
Date:
Subject: RE: how to calibrate the cost model parameters
Next
From: Raj kumar
Date:
Subject: Changing Data Type on Production Database - Impact