public inbox for [email protected]
help / color / mirror / Atom feedFrom: Estuary via PostgreSQL Announce <[email protected]>
To: PostgreSQL Announce <[email protected]>
Subject: PostgreSQL CDC, Evolved: Read-Only Mode, IAM Auth & Partition Support Now in Estuary
Date: Fri, 03 Apr 2026 09:01:14 +0000
Message-ID: <177520687482.3221092.17630158063825856170@wrigleys.postgresql.org> (raw)
Estuary has released significant updates to its PostgreSQL connectors, expanding support for production-grade change data capture (CDC) use cases.
## What's New
### Read-Only Capture
Estuary now supports CDC in read-only mode without needing to write to a watermarks table. Read-only captures should include a table with frequent updates or a "heartbeat" table to ensure WAL retention doesn't grow continuously.
Read-only mode also allows capturing from a PostgreSQL standby replica, letting teams offload replication impact from the primary database entirely. Capturing from read-only standbys requires:
- PostgreSQL 16 or later
- Logical decoding enabled
- `hot_standby_feedback = on` to retain catalog metadata
### IAM Authentication
Both PostgreSQL source and destination connectors now support IAM authentication, enabling role-based access for teams running PostgreSQL on AWS, GCP, or Azure. This removes the need to manage static database credentials in pipeline configurations.
### Partitioned Table Support
A new advanced setting called **"Capture Partitioned Tables as Partitions"** allows each partition of a partitioned PostgreSQL table to be captured as an individual stream, giving teams fine-grained control over how partitioned data flows through their pipelines.
## Documentation & Resources
For full setup instructions including WAL configuration, replication slot management, and platform-specific guides for Amazon RDS, Aurora, Google Cloud SQL, and Azure Database for PostgreSQL:
- [PostgreSQL Source Connector Documentation](https://docs.estuary.dev/reference/Connectors/capture-connectors/PostgreSQL/)
- [PostgreSQL Destination Connector Documentation](https://docs.estuary.dev/reference/Connectors/materialization-connectors/PostgreSQL/)
- [Get started free](https://dashboard.estuary.dev/register) | [Contact the team](https://estuary.dev/contact-us/)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: PostgreSQL CDC, Evolved: Read-Only Mode, IAM Auth & Partition Support Now in Estuary
In-Reply-To: <177520687482.3221092.17630158063825856170@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox