Question

Postgres connector not support capture the data that is just "write" to this db, except for the replicated data. so that If there are two bidirectional copies of DB, Debezium will capture a lot of useless data.

Solution

1. In 'Logical Replication Message Formats', pgoutput plugin support 'Origin' type to record the data origin name. So, If we come across this field and find that the source is something we want to avoid copying, we can skip it until we hit 'Commit'.
2. Another approach is to put the Origin name field in the message body and let the user decide whether the messages are processed or not.