0

We have a requirement where we want to sync changes occurring in specific tables of 2 separate systems. For one of the system we are looking to use Debezium PostgreSQL source. We wanted to check for a way to stop a cyclic loop like below as the changes from CDC are synched.

SysA external change -> Debezium CDC -> SystemB notified -> CDC -> SysA (notified again) -> CDC -> SysB (notified again)....cycle

We were thinking to do the updates from the CDC in the DB using a specific DB user so that the Debezium source connector can ignore the changes done by a specific user, something like below.

SysA external change -> SystemB notified (DB updated using specif DB user DB1) -> CDC (ignore changes by DB user DB1)

Is this possible. Any other way we can achive the same? Note: Only one of the CDC will use Debezium the other DB is different so would use a different connector.

Improve this question
Related questions
2642
How to show tables in PostgreSQL?
2255
PostgreSQL "DESCRIBE TABLE"
1993
How can I change a PostgreSQL user password?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.