I am using Postgresql 14 and it is set up for logical replication. Trying to stream changes with debezium version 1.8. Actually, everything seems OK. Every insert, update, delete is streamed except the updates that update a value with the same. According to this great answer, this kind of update creates a WAL record but is it actually tried to replicate over publication?
Also need to mention that I asked the same question in debezium chat but they asked me back these two questions :
- The change is propagated to the replication slot
- The change is propagated into publication
I would be happy if you can provide ways to validate those two.