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.

Option	Description
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)

Option

Description

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)