Question
Why is my PostgreSQL connector not capturing deletes?
Environment
Connector: PostgreSQL
Answer
If you are using XMIN as a replication method, this mechanism does not allow us to recognise deleted rows at all (for more information, see our XMIN documentation).
Preferred solution
The preferred method to replicate row deletions from your data source is to use Logical Replication.
Alternate solutions
If logical replication is not an option for you, you can use one of the below workarounds to keep the data up-to-date in the warehouse:
-
Manual re-syncs:
-
Re-sync via your own automated script using the Re-sync Connector Table data API endpoint.
-
See our documentation for workarounds using triggers or adding an extra column to your source.
Cause
XMIN does not support capturing deletes.