DMS configuration for cdc with PostgreSQL as source

Hi,

My understanding is that only changes can be propagated by DMS. Mostly because it uses the rdbms logs to capture those changes and those logs do not contain full rows but only delta.

Nonetheless, you can achieve what you want by using a sql trigger: https://www.postgresql.org/docs/current/sql-createtrigger.html

The idea is the following; the trigger with fire on any change on the row brought by a DMS change. Then this trigger selects in full (i.e. all columns as neeed) the row as change is applied. This trigger then "pushes" the full row whenever you need: write it in another table, steams it outside of pg, etc.

Hope it helps!

Didier