Streaming Data into Postgres with Estuary

From: Estuary Flow via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org>
Subject: Streaming Data into Postgres with Estuary
Date: 2025-04-29 06:01:37
Message-ID: 174590649719.671.15681491565241312845@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce

Estuary now provides native support for **real-time data streaming into PostgreSQL** via its PostgreSQL materialization connector. With this, users can configure Flow collections to automatically write into PostgreSQL tables — in seconds, at scale, and with exactly-once semantics.

Whether you’re using a self-hosted Postgres instance or a managed database like **Amazon RDS**, **Google Cloud SQL**, or **Azure Database for PostgreSQL**, Estuary ensures secure and reliable connectivity — including support for **SSL** and **SSH tunneling**.

### Key Features:
- Automatically creates target tables for each collection
- Supports **standard and delta updates**
- Handles schema evolution and reserved Postgres keywords
- Preserves column capitalization and converts data types (e.g., `ipv4`, `macaddr`, `duration`)
- Open-source compatible with Docker image:
`ghcr.io/estuary/materialize-postgres:dev`

This connector is part of Estuary Flow — a real-time data platform that bridges Postgres with upstream systems like Kafka, MongoDB, APIs, and more.

📘 [Documentation: Streaming into PostgreSQL with Estuary](https://docs.estuary.dev/reference/Connectors/materialization-connectors/PostgreSQL/)
🚀 [Get started with Estuary Flow](https://dashboard.estuary.dev)
🔧 [Contact the team](https://estuary.dev/contact-us/)

Browse pgsql-announce by date

  From Date Subject
Next Message vitabaks via PostgreSQL Announce 2025-04-29 13:37:23 pg_auto_reindexer v1.4 released
Previous Message Dalibo via PostgreSQL Announce 2025-04-24 10:04:22 PostgreSQL Anonymizer 2.1: Blurring Images