WAL or Change Data Capture (CDC) Based Replication

Below table shows supported features and features we are working on for WAL or CDC Based replication from Postgres to different targets. āœ… meansupported. šŸ› ļø means Work in Progress and Coming Soon!.

FeatureSnowflakeBigQueryPostgresS3GCSAzure Event Hubs
Initial Snapshot - Parallelizableāœ…āœ…āœ…āœ…āœ…šŸ› ļø
Incremental Sync (CDC)āœ…āœ…āœ…āœ…āœ…āœ…
DML Support - INSERT, UPDATE and DELETEāœ…āœ…āœ…āœ…āœ…āœ…
Schema Changesāœ…āœ…āœ…āœ…āœ…āœ…
Soft Deleteāœ…šŸ› ļøšŸ› ļøšŸ› ļøšŸ› ļøšŸ› ļø
Partitioned Tablesāœ…āœ…āœ…āœ…āœ…āœ…
Pausing Mirrorsāœ…āœ…āœ…āœ…āœ…āœ…
Advanced Types - Arrays, JSONB, HSTORE, Geospatial etc.āœ…āœ…āœ…āœ…āœ…āœ…
Advanced Monitoring - Lag, Throughput, Postgres Wait Events etcāœ…āœ…āœ…āœ…āœ…āœ…
Resync Mirrorsāœ…šŸ› ļøšŸ› ļøšŸ› ļøšŸ› ļøšŸ› ļø
Column ExclusionšŸ› ļøšŸ› ļøšŸ› ļøšŸ› ļøšŸ› ļøšŸ› ļø
PeerDB Watchdog - Alerting based on important metrics such as slot size (lag)šŸ› ļøšŸ› ļøšŸ› ļøšŸ› ļøšŸ› ļøšŸ› ļø
PeerDB AutoAdapt - Based on activity the on source auto adapt load/pressurešŸ› ļøšŸ› ļøšŸ› ļøšŸ› ļøšŸ› ļøšŸ› ļø

Query Based or Watermark Based Replication

Below table shows supported features and features we are working on for Query Based or Watermark Based Replication from Postgres to different targets. āœ… meansupported. šŸ› ļø means Work in Progress and Coming Soon!.

FeatureSnowflakeBigQueryPostgresS3GCS
Initial Snapshotāœ…āœ…āœ…āœ…āœ…
Incremental Sync Based on Watermarkāœ…āœ…āœ…āœ…āœ…
DML Support - INSERT, UPDATE (if updated_at & primary key are present)āœ…āœ…āœ…āœ…āœ…
Schema Changes - ADD COLUMNāœ…šŸ› ļøšŸ› ļøšŸ› ļøšŸ› ļø
Resync Mirrorsāœ…šŸ› ļøšŸ› ļøšŸ› ļøšŸ› ļø
Pausing Mirrorsāœ…āœ…āœ…āœ…āœ…
Partitioned Tablesāœ…āœ…āœ…āœ…āœ…
Advanced Types - Arrays, JSONB, HSTORE, Geospatial etc.āœ…āœ…āœ…āœ…āœ…
Advanced Monitoring - Throughput, Postgres Wait Events etcāœ…āœ…āœ…āœ…āœ…
Column Exclusionāœ…āœ…āœ…āœ…āœ…