Logical Replication from Postgres to Iceberg
a year ago
- #Data Replication
- #PostgreSQL
- #Iceberg
- Crunchy Data Warehouse integrates PostgreSQL with Iceberg for analytics.
- Logical replication from PostgreSQL to Iceberg is now available.
- Supports insert, update, delete, and truncate operations with low lag (<60 seconds).
- Automatic table creation, data copy, and compaction are included.
- Advanced features like row filters and failover slots are supported.
- Setup requires just two commands for quick deployment.
- Efficient merge-on-read method reduces computational costs.
- Replication maintains transaction boundaries and foreign key constraints.
- Available on Crunchy Bridge and soon for self-managed Kubernetes users.
- Aims to enhance PostgreSQL features for high-performance analytics with Iceberg.