| From: | Raj kumar <rajkumar820999(at)gmail(dot)com> |
|---|---|
| To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Cc: | Raj kumar <rajkumar820999(at)gmail(dot)com> |
| Subject: | Logical Replication - Initial Snapshot Only mode |
| Date: | 2022-06-03 06:49:42 |
| Message-ID: | CACxU--XizpxQwQooKhQJe4Dy_sP5+LQTm4WOHjC_zYMQZm7BJw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jack DeVries | 2022-06-03 20:18:10 | Re: Fwd: Adding more detail to pg_upgrade documentation |
| Previous Message | jian xu | 2022-06-02 12:07:23 | RE: how to calibrate the cost model parameters |