# Replicate MySQL data to your Data Warehouse via CDC or incrementally

> Replicate PostgreSQL tables to your data warehouse via CDC (WAL) or incrementally with Erathos. Schema detection and full observability. Start free.

Source: https://www.erathos.com/en/connectors/postgresql
Em português: https://www.erathos.com/connectors/postgresql

PostgreSQL is an open-source relational database widely used in enterprise applications.

## From PostgreSQL to your Data Warehouse in minutes

### Plug and play connectors

Connect PostgreSQL with over 100 other plug-and-play integrations. Eliminate time-consuming manual pipelines and consolidate all your data into a single analytical environment, ready to deliver actionable insights.

### Greater control over pipelines

Build MySQL data pipelines quickly: select the relevant data, configure schedule, frequency, and update type without writing a single line of code. Choose between incremental sync or CDC via binlog depending on your use case, with total flexibility.

### Edge observability

Monitor your PostgreSQL pipelines with real-time alerts via email, Slack, or Discord. Stop getting caught off guard by synchronization errors and ensure your data is always up to date and reliable.

### Change Data Capture (CDC) via binlog

Capture inserts, updates, and deletes from MySQL directly from the binlog, with no performance impact on the source database. Ideal for teams that need always up-to-date data and a complete history of changes, without relying on traditional incremental polling.

## Replicate MySQL data to your Data Warehouse via CDC or incrementally

Erathos is a complete ELT software that extracts data from MySQL and 100+ other sources through instant integrations. With Change Data Capture (CDC) based on binlog, you capture inserts, updates, and deletes in near real-time, without overloading the source database. With plug & play connectors, you consolidate all your data into a single analytics environment and build a Data Warehouse in minutes.

## PostgreSQL Connector FAQ

### How does PostgreSQL replication work for the Data Warehouse?

Erathos provides incremental or full replication from PostgreSQL to your destination data warehouse, including tables, schemas, and relationships. Synchronization is configurable by frequency and schedule, with no code required.

### Is PostgreSQL data synchronized incrementally?

Yes! PostgreSQL integration via Erathos is incremental by default: only new or changed data is synchronized with each run. This ensures efficient pipelines, lower processing costs, and data that is always up to date in your Data Warehouse.

### Can I test the PostgreSQL integration for free?

Yes! You can try the PostgreSQL integration free for 14 days. Just connect PostgreSQL as a new source, you'll have two weeks to validate whether the connector meets your needs before any charges apply.

### Which data warehouses can I send PostgreSQL data to?

With Erathos, you can move data from PostgreSQL to the market’s leading data warehouses and destinations: BigQuery, Redshift, PostgreSQL, SQL Server, Databricks, and Amazon S3. Just choose the destination and set up the pipeline in minutes, with no code.

### Does Erathos integrate PostgreSQL directly with other systems?

No. Erathos does not provide direct point-to-point integrations between PostgreSQL and other systems. Our focus is to centralize PostgreSQL data in a Data Warehouse, creating a single source of truth so your company can make decisions based on reliable data.

### Does Erathos support Change Data Capture (CDC) for MySQL?

Yes! In addition to traditional incremental sync, Erathos offers binlog-based CDC for MySQL, capturing inserts, updates, and deletes in near real-time, without overloading the source database. It's the recommended option for teams that need always up-to-date data and full change tracking. Binlog configuration on your database (ROW format, FULL image) is detailed in the technical documentation (https://docs.erathos.com/connectors/databases/postgresql#cdc-setup).