.png){kind=logo}
PostgreSQL Advanced Settings
-
DarkLight
PostgreSQL Advanced Settings
-
DarkLight
Overview
In most cases, the advanced settings will not be required however Matillion CDC do provide some additional configuration items when setting up your pipelines. Please take a moment to understand what these advanced settings are and what they achieve before incorporating them within your pipeline.
Warning
If you are unclear about a particular setting, please reach out to Matillion for support.
PostgreSQL Advanced Settings
Pipeline advanced settings can be added at the end of the Add Pipeline journey via the Matillion Data Loader UI.
snapshot.mode
The snapshot.mode setting allows control over the snapshot stage of the CDC process when your pipeline begins. Its valid values are listed below:
- initial: A snapshot is always captured if one does not previously exist. This is the default value.
- never: Snapshots are never taken. Can only be used if the Write-Ahead Log still contains all change data required. Begins streaming from when the logical replication slot was created on the source server.
Note
Note that this option is now available through a toggle in the Pipeline Settings UI when setting up your CDC Pipeline and should no longer be used as an Advanced Setting.
slot.name
The name of the PostgreSQL logical decoding slot that was created for streaming changes from a particular plug-in for a particular database/schema.
Valid replication slot name must contain only digits, lowercase characters and underscores with length <= 63.
You need to use this setting if you want to have more than one pipeline using the same source postgres database.