PostgreSQL Snapshot Modes

When a PostgreSQL connecor is started, there are various options. The default is initial. The other options may be useful from time to time.

initialThe connector performs a snapshot if no offsets have been recorded for the logical server name
neverThe 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)