Вход на сайт

Просмотр новости

Найдите то, что Вас интересует

PostgreSQL CDC, Evolved: Read-Only Mode, IAM Auth & Partition Support Now in Estuary

Дата публикации: 03-04-2026 00:00:00


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
PostgreSQL Destination Connector Documentation
Get started free | Contact the team


Основное содержимое страницы с новостью.

Posted on 2026-04-03 by Estuary

Related Proprietary

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:

Схожие новости

#Наименование новостиТональностьИнформативностьДата публикации
1DBConvert Streams 2.0 released with PostgreSQL CDC and cross-database querying 010.9410-04-2026
2PostgreSQL 19 Beta 3 is now available in Amazon RDS Database Preview Environment09.6418-08-2026
3PGX announces support for EOL versions of PostgreSQL 011.225-06-2026
4Meet the New dotConnect for PostgreSQL Release 07.8816-01-2026
5dotConnect for PostgreSQL 9.1: New Release 010.7210-04-2026
6PostgreSQL 19 Beta 2 Released! 5716-07-2026
7SQL Management Studio for PostgreSQL 2.0 Is Here — Faster, Safer, and More Efficient 08.0123-04-2026
8powa-archivist 5.2.0 is out! 0512-07-2026
9Barman 3.19.0 and 3.19.1 Released 2608-07-2026
10СУБД PostgreSQL обновилась до версии 1801006-10-2025

Классификация: . Схожих патентов: 0. Схожих новостей: 10. Тональность: 0. Информативность: 11.17. Источник: www.postgresql.org.