'CDC PostgreSQL with Debezium while ignoring columns

I have a postgreSQL table with 10 columns, we need to enable CDC on this table to capture changes only in ONE of the columns ignoring the other nine. Our debezium has the following configurations:

{
    "connector.class": "io.debezium.connector.postgresql.PostgresConnector",
    "database.history.file.filename": "/data/postgresql-d-connection-teste3-history.dat",
    "database.user": "postgres",
    "transforms.Reroute.type": "io.debezium.transforms.ByLogicalTableRouter",
    "database.dbname": "postgres",
    "max.queue.size": "81290",
    "tasks.max": "1",
    "transforms": "Reroute",
    "database.server.name": "xxxx",
    "offset.flush.timeout.ms": "60000",
    "transforms.Reroute.topic.regex": "(.*)",
    "buffer.memory": "2048",
    "database.port": "5432",
    "plugin.name": "wal2json",
    "offset.flush.interval.ms": "10000",
    "tombstones.on.delete": "false",
    "transforms.Reroute.topic.replacement": "teste3",
    "decimal.handling.mode": "string",
    "database.hostname": "xxxx",
    "database.password": "xxxx",
    "name": "postgresql-d-connection-teste3",
    "table.include.list": "public.test",
    "max.batch.size": "20480",
    "database.history": "io.debezium.relational.history.FileDatabaseHistory"
}

We also already tried to set these parameters in the JSON, without success:

"column.include.list": "public.test.{id|name}"
"column.exclude.list": "public.test.{id|name}"

I have the same scenario working fine with MS SQL Server, where I only had to execute these query:

EXEC sys.sp_cdc_enable_table
@source_schema = N'xxxx', 
@source_name   = N'xxxx',
@captured_column_list = N'col1, col2, col3
@supports_net_changes = 0

Is it possible to achieve the same goal with postgreSQL?

Thanks in advance



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source