Hello Mattia, True... saw your email where you mention that. I'm building a local cluster to test that solution, so I might ask you questions in the next few days.
Thanks again for replying! Lucas On Thu, 27 May 2021 at 20:30, IT Technical Analyst FOD < [email protected]> wrote: > Hi Lucas, > > if you read one of my previous emails I explained how you can do that. > > > > I recall down here part of what I wrote, see specifically point 5b: > > > > […] > > 3. Add your source db to bucardo (bucardo add db A, with tables etc) > bucardo add db db_A dbhost=myhost dbport=5432 dbname=mydbname > dbuser=mydbuser dbpass=mydbpassword > > 4. Add your target db to bucardo (bucardo add db B, with tables etc) > bucardo add db db_B dbhost=myhost_B dbport=5432 dbname=mydbname > dbuser=mydbuser dbpass=mydbpassword > > 5. Create a sync that has: > > a. database A as source, database B as target if you want a master > to slave replication > bucardo add dbgroup grp_m2s_mydbname db_A:source db_B:target > bucardo add sync sync_mydbname_m2s dbs=grp_m2s_mydbname [‘tables=’] > > b. both databases as source if you want a master to master > replication (you should choose a conflit resolution strategy, I use “ > *bucardo_latest*”) > bucardo add dbgroup grp_m2m_mydbname db_A:source db_B:source > bucardo add sync sync_mydbname_m2m dbs=grp_m2m_mydbname > conflict_strategy=bucardo_latest [‘tables=’] > > More precisely I created a dbgroup with both databases, and then I add > that dbgroup to the sync. > The “tables” parameter is optional, to specify a subset of tables to be > replicated (comma separated). > > 6. Start bucardo > > […] > > > > > > Hope it can help, > > regards. > > > > Mattia > > > > *From:* Bucardo-general <[email protected]> *On Behalf > Of *Lucas Possamai > *Sent:* giovedì 27 maggio 2021 01:15 > *To:* [email protected] > *Subject:* [Bucardo-general] Bucardo with two way replication > > > > 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 >
_______________________________________________ Bucardo-general mailing list [email protected] https://bucardo.org/mailman/listinfo/bucardo-general
