# PostgreSQL + Amazon S3

> Store data as Parquet in S3 and Iceberg with Erathos. Sync PostgreSQL data with Erathos — an incremental, no-code pipeline with observability.

Source: https://www.erathos.com/en/pipelines/postgresql-amazon-s3
Em português: https://www.erathos.com/pipelines/postgresql-amazon-s3

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

With Erathos, you can integrate PostgreSQL data with Amazon S3 in just a few minutes. Our platform handles the entire data movement process to your data lake and enables that data to be joined with other sources. That way, your time is spent on what truly creates value — extracting insights and making data-driven decisions.

### Which PostgreSQL data does Erathos sync to Amazon S3?

The integration automatically syncs the main PostgreSQL objects:

- **Tables and collections** — structure, records, and metadata
- **Records and documents** — raw data with creation and update timestamps
- **Indexes** — configuration and performance metrics
- **Schemas** — type definitions and relationships
- **Audit logs** — write, update, and delete operations
- **Connections** — user and session metadata

### Why sync PostgreSQL with Amazon S3?

In Amazon S3 with Iceberg, your data is stored as Parquet files with support for time travel and schema evolution — ready to be queried with Athena, Spark, Trino, or any query engine in your stack. Ideal for low-cost archival and ML feature stores.

### How it works

Erathos connects to PostgreSQL via the official API and syncs your data incrementally — only new or updated records are processed in each run. You choose the sync frequency (from every 5 minutes to daily), the objects to sync, and the destination in Amazon S3. The sync uses automatic partitioning and Parquet file optimization. You choose the sync frequency, the objects to sync, and the destination bucket. Each run is logged with full observability: execution time, processed rows, context-rich errors, and alerts via Slack or email.

## PostgreSQL data in Amazon S3 in minutes

### Ready-to-use PostgreSQL connector

Connect PostgreSQL to Amazon S3 and automatically export data. Centralize database information for analysis — without spreadsheets or scripts.

### Full control over your PostgreSQL pipelines

Configure the schedule, frequency, and sync type at the table level. Configure partitioning, file format, and write frequency at the table level. The Iceberg format ensures ACID compliance and schema evolution — without full bucket rewrites.

### End-to-end observability

Stop finding out about PostgreSQL failures when the business team starts complaining. Every run is logged with runtime, rows processed, and error context. Get automatic alerts via Slack, Discord, or email as soon as anything goes off track — so your data stays fresh for analysis.

## Centralizing PostgreSQL data in Amazon S3 has never been easier

Erathos is a data ingestion platform built for data and engineering teams. With the PostgreSQL connector, you can automatically centralize PostgreSQL tables and database objects in Amazon S3 — always up-to-date data, full observability into every run, and zero maintenance.

## FAQ

### What is Erathos, and how can it help my business?

Erathos is a data ingestion platform built for reliability, transparency, and control. We help data teams connect tools like PostgreSQL to their data warehouse—with full observability into every run, zero maintenance, and none of the black-box behavior of traditional market tools.

### What PostgreSQL data does Erathos sync to Amazon S3?

Erathos performs 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.

### How often does Erathos sync data from PostgreSQL to Amazon S3?

You can configure sync frequency anywhere from every 5 minutes to once a day, at the table level. Erathos uses incremental sync — only new or updated records are processed on each run, keeping the PostgreSQL pipeline efficient and Amazon S3 costs predictable.

### What happens if a PostgreSQL sync fails?

Erathos automatically detects failures and sends alerts to your email, Slack, or Discord with full context — not just “job failed.” Smart retries handle transient errors, and every run is logged with runtime, rows processed, and error context so your team can debug in minutes, not hours.

### Is there a free trial period for the PostgreSQL connector?

Yes. Every Erathos connector includes a 14-day free trial. Connect PostgreSQL to Amazon S3 and start syncing right away — no credit card required.