

Change Data Capture (CDC) / Logical Replication / WAL Replication Your database user should now be ready for use with Airbyte. To create a dedicated database user, run the following commands against your database: Alternatively, you can use Airbyte with an existing user in your database. This step is optional but highly recommended for better permission control and auditing. Create a dedicated read-only user with access to the relevant tables (Recommended but optional) The easiest way to verify if Airbyte is able to connect to your Postgres instance is via the check connection tool in the UI. This is dependent on your networking setup.

Make sure your database is accessible from the machine running Airbyte Create a dedicated read-only Airbyte user with access to all tables needed for replicationġ.Allow connections from Airbyte to your Postgres database (if they exist in separate VPCs).Getting Started (Airbyte Open-Source) Requirements Other than that, you can proceed with the open-source instructions below. On Airbyte Cloud, only TLS connections to your Postgres instance are supported. See the destination's documentation for more details. Depending on the destination connected to this source, however, the schema may be altered. The Postgres source does not alter the schema present in your database. No schemas set explicitly - will sync all of existing. Multiple schemas may be used at one time.
