Summary
In Airbyte version 0.61.0, users can reset a connection to resolve errors like ‘Saved offset is before replication slot’s confirmed lsn’. The user is looking for guidance on how to reset a connection as they couldn’t find a button for it.
Question
Hello,
Does anyone know how can I reset a connection airbyte in version 0.61.0 ?
I can find any button anywhere to reset the connection.
I need to reset the connection because of this error:
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.
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
["reset-connection", "airbyte-version-0.61.0", "connection-error", "replication-slot", "reset-button"]
Can you make a screenshot on Settings tab for a connection?
Not for the moment, I tried to upgrade to version 0.64, and now airbyte wont go up 
I’ll comeback as soon as I can
On 1.0.0 there is Refresh your data which is equivalent for Reset
Wordings have changed over last few months
I only saw two buttons, “Clear your data” and “Delete connection”
Ah, yes, some destinations have only Clear your data option. Then you need clear all data and start synchronization again.
I tried that, and it didn’t work, I get the same error
I think I could delete the connection and created again, but I really don’t want to do that. There would be too many tables to manually setup
sidenote: I recommend using terraform for storing Airbyte configuration https://github.com/airbytehq/terraform-provider-airbyte
in the meantime, I’m checking other possibilities
On Settings tab for Postgres source you might have an option Invalid CDC position behavior (Advanced)
Set to Re-sync data
If you don’t have it, which version of Postgres source connector do you have?
I can see it on Postgres source connector v3.6.18
That setting seems to have fixed the issue!