PostgreSQL Connector Not Capturing Deletes

Question

Why is my PostgreSQL connector not capturing deletes?

Environment

Connector: PostgreSQL

Answer

If you are using XMIN as your incremental sync method, this mechanism does not allow us to recognize deleted rows at all. For more information, see our XMIN documentation.

You can use of one of the following workarounds to keep the data up to date in your destination:

• Re-sync the table. This will be time-consuming. However, you can write some scripts to capture the tables that have deletes on your end to automate the process.
• Re-sync the connector. This may slow down the updates and cause significant processing overhead on your PostgreSQL server.
• Read our PostgreSQL documentation for more information on other workarounds.