Real-time Change Data Capture for Postgres Partitioned Tables

Real-time Change Data Capture (CDC) is becoming increasingly important with the growing adoption of table partitioning in PostgreSQL. PeerDB, a data movement tool for Postgres, has added extensive support for CDC for Partitioned Tables to stream real-time changes from partitioned tables to various targets like Data Warehouses, Queues, or Storage. The tool handles scenarios such as adding new partitions, dropping partitions, and managing schema changes like adding columns. PeerDB supports Postgres versions 12 to 16 and aims to improve the reliability of data movement for partitioned tables.