@kapa.ai my current configuration for update method in source connection is set to “detect changes with admin System Column” I want to change this to “Read changes using write ahead log (CDC) “ What are the steps to do so

To change your update method from "Detect changes with admin System Column" to "Read changes using write ahead log (CDC)" for a Postgres source connection in Airbyte, you'll need to follow these steps: 1. Enable CDC on your Postgres database: - Grant REPLICATION permissions to your Airbyte user:

sql      ALTER USER <user_name> REPLICATION;

- Enable logical replication on your Postgres database - Create a replication slot - Create publication and replication identities for each Postgres table you want to replicate 2. In the Airbyte UI: - Go to your Postgres source configuration - Change the replication mode to "Logical Replication (CDC)" - Enter the replication slot and publication you created 3. Specifically, in the Airbyte UI, you need to: - Change the update method to "Read Changes using Change Data Capture (CDC)" - Enter the replication slot and publication you created [Postgres Source CDC Setup](https://docs.airbyte.com/integrations/sources/postgres#setup-using-cdc) [Enabling CDC in Airbyte UI](https://docs.airbyte.com/integrations/sources/postgres#step-6-enable-cdc-replication-in-airbyte-ui) Please note that CDC has specific requirements and limitations, so make sure your Postgres setup meets these before proceeding with the change. Also, be aware that for CDC to work correctly, you must connect to primary/master databases, not replicas.