Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Bidirectional replication #43

Open
mclei-asw opened this issue Jun 27, 2024 · 0 comments
Open

Bidirectional replication #43

mclei-asw opened this issue Jun 27, 2024 · 0 comments

Comments

@mclei-asw
Copy link

We have a bidirectional logical replication. It means, the master DB replicates/sends some data to slave DB and also slave DB sends another data to master DB (it is not master-master, always the different set of data are send in each direction).

For master->slave I can use the standby_slot_names parameter to block sending logical replication data until the standby streaming replica applies and confirms them.

BUT how can I limit the opposite direction? When the standby streaming replica is off, logical replication master->slave are blocked, but data slave->master are happily applied and confirmed back to slave. So the slave can drop its wals.
When I promote the standby replica now, it will not contain the data from slave.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant