Limitations

The following features are not supported by the CDC Replication Engine for PostgreSQL.

Partitioned tables

PostgreSQL partitioned tables are not supported. Source tables must be normal tables, not views, materialized views, partition root tables, or foreign tables. Attempts to replicate tables other than normal tables will result in an error.

Journal control field

The &USER journal control field is not supported.

DDL changes

All DDL changes should be planned in advance. Unplanned DDL changes are not supported because the CDC Replication Engine for PostgreSQL does not detect or stop replication on unplanned DDLs. This is a limitation of the PostgreSQL logical replication API, which does not notify of DDL changes. See Preparing for a planned DDL change for more information.

Materialized views

Materialized views are not supported.

Differential refresh

The CDC Replication Engine for PostgreSQL does not support differential refresh.