Connect Postgres data with any data source.

Write data from any Airbyte source to Postgres on your schedule.

Load data into Postgres Read the docs

Sources: 590+
Certified support: 3.0.23

Overview

What is the Airbyte Postgres connector?

The Airbyte Postgres connector loads data from 590+ Airbyte sources into Postgres, with full refresh and incremental sync on a schedule you control.

01
Load from any source
Move data into Postgres from 590+ Airbyte sources on a schedule you control.
02
Incremental syncs
Pull only the records that changed since the last run instead of reloading everything.
03
Cloud or self-hosted
Run the Postgres connector on Cloud, OSS, Hybrid.

Setup

Live in three steps

Confirm your Postgres destination credentials and permissions.
Configure the destination in Airbyte with the required connection settings.
Choose a source, map streams, and schedule syncs into Postgres.

Configuration fields

Postgres destination configuration fields
Field	Type	Description
database*	string	Name of the database.
host*	string	Hostname of the database.
port*	integer	Port of the database.
schema*	string	The default schema tables are written. If not specified otherwise, the "public" schema will be used.
username*	string	Username to access the database.
cdc_deletion_mode	string	Whether to execute CDC deletions as hard deletes (i.e. propagate source deletions to the destination), or soft deletes (i.e. leave a tombstone record in the destination). Defaults to hard deletes.
disable_type_dedupe	boolean	Disable Writing Final Tables. WARNING! The data format in _airbyte_data is likely stable but there are no guarantees that other metadata columns will remain the same in future versions
drop_cascade	boolean	Drop tables with CASCADE. WARNING! This will delete all data in all dependent objects (views, etc.). Use with caution. This option is intended for usecases which can easily rebuild the dependent objects.

Hybrid deployment

Sovereign by architecture, not by policy.

The data plane runs in your environment. Records, credentials and keys stay with you; the control plane only receives configuration and job metadata.

Cloud
OSS
Hybrid

Your environment

DataConnectorsCredentialsKeys

↕ metadata only

Airbyte control plane

OrchestrationMonitoringUI

FAQ

Postgres connector questions

What data can I load into Postgres with Airbyte?

Airbyte moves data from any supported source into Postgres on a schedule you control, with full refresh and incremental sync where the destination supports it.

Does the Postgres connector support incremental sync?

Yes. The Postgres destination supports full refresh and incremental sync, so Airbyte can load only the records that changed since the last sync.

Where can I run the Postgres connector?

Run the Postgres connector on Cloud, OSS, Hybrid. Hybrid deployments keep the data plane in your environment while the control plane orchestrates syncs.

Didn't find your answer? Talk to sales