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"?
Connector: PostgreSQL configured with logical replication (WAL)
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.
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.