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 recognize deleted rows at all(For more information, see our XMIN documentation).

You can make use of one of the below workarounds to keep the data up-to-date in the warehouse : 

• Resync the table (This will be tedious however, you can write some scripts to capture the tables that have deletes at your end to automate the process).
• Resync the connector (Can slow down the updates and cause significant processing overhead on your PostgreSQL server).
• Please refer to our docs for more information on other workarounds.

Cause

XMIN does not support capturing deletes.