[Bucardo-general] Bucardo with two way replication

Lucas Possamai drum.lucas at gmail.com
Wed May 26 23:14:57 UTC 2021


Hello all,

As you may have seen from my previous emails, I'm working on a migration
from EC2 Instance PostgreSQL 9.2 to RDS PostgreSQL 12, and since I cannot
have any downtime, I'm using Bucardo for that.

Previously, we were going to set up Bucardo, perform tests and we would
move all customers at once to RDS. Now, the business decided that is risky
and we wanna migrate a few customers over at a time. However, whatever
these customers do in RDS, the data must be replicated back to the master
9.2.

Example:

source db (PG 9.2) --> Bucardo --> target db (PG 12)
target db (PG 12) --> Bucardo --> source db (PG 9.2)


So, it means that I'll need a two way replication set up.

I couldn't find anything online about this process. Does anybody have any
suggestions or steps to follow, please?

Regards,
Lucas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20210527/d9f21c71/attachment.htm>


More information about the Bucardo-general mailing list