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.