Issue

The PostgreSQL connector is not capturing deletes.

Environment

Connector: PostgreSQL

Resolution

If you are using XMIN as a replication method, this mechanism does not allow us to recognize deleted rows. For more information, please 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 the table

  • Re-sync the connector

• 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.