Question
Why is my PostgreSQL connector not loading data, delayed, and the connector dashboard displaying the following error message "Rescheduling the connector to allow us to release WAL entries in the source DB. This is intended behavior and means that the connector is working as expected"?
Environment
Connector: PostgreSQL configured with logical replication (WAL)
Answer
Verify the sync is writing to the warehouse by checking the fivetran_audit table. If the _fivetran_synced date is greater than the start date, this verifies the sync is writing to the warehouse.
Cause
This is the expected behavior. The WAL is cleared:
- By default every 6 hours.
- When the connector identifies the WAL is too large it clears it to reduce the load on the database.