Replication Slot Error in Self-hosted Airbyte

Summary

User reports a recurring error related to replication slots in Postgres while using the latest self-hosted Airbyte version (1.2.0). The issue involves saved offsets and suggests actions regarding WAL retention and sync frequency.


Question

Failure in source: Saved offset is before replication slot’s confirmed lsn. Please reset the connection, and then increase WAL retention and/or increase sync frequency to prevent this from happening in the future. See https://docs.airbyte.com/integrations/sources/postgres/postgres-troubleshooting#under-cdc-incremental-mode-there-are-still-full-refresh-syncs for more details.
getting this error againa an again I am using the lastest version of self hosted airbyte: 1.2.0 and wal_keep_size - 20GB .
still getting this error .
please help to resolve this issue.



This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

['postgres', 'replication-slot', 'wal-retention', 'airbyte-1.2.0', 'incremental-mode']