When a PostgreSQL connecor is started, there are various options. The default is
initial. The other options may be useful from time to time.
|initial||The connector performs a snapshot if no offsets have been recorded for the logical server name|
|never||The connector never performs snapshots. If there is a stored LSN (Log Sequence Number) in the Kafka offsets topic, the connector continues streaming changes from that position. Otherwise, it starts streaming changes from the creation point of the PostgreSQL logical replication slot on the server. Use this mode when you're confident that all relevant data is still available in the Write-Ahead Log (WAL)|
Updated 5 months ago