<div dir="ltr">Hello Mattia,<div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div><br></div><div>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.</div><div><br></div><div>Thanks again for replying!<br><br>Lucas</div><div></div></div></div></div></div></div></div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, 27 May 2021 at 20:30, IT Technical Analyst FOD <<a href="mailto:fo.ittechnicalanalyst@emergency.it">fo.ittechnicalanalyst@emergency.it</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="IT">
<div class="gmail-m_-5143380052516365813WordSection1">
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Hi Lucas,<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">if you read one of my previous emails I explained how you can do that.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">I recall down here part of what I wrote, see specifically point 5b:<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">[…]<u></u><u></u></span></p>
<p class="gmail-m_-5143380052516365813MsoListParagraph"><u></u><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><span>3.<span style="font:7pt "Times New Roman"">
</span></span></span><u></u><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Add your source db to bucardo (bucardo add db A, with tables etc)<br>
</span><span lang="EN-US" style="font-size:10pt;font-family:"Courier New"">bucardo add db db_A dbhost=myhost dbport=5432 dbname=mydbname dbuser=mydbuser dbpass=mydbpassword</span><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u><u></u></span></p>
<p class="gmail-m_-5143380052516365813MsoListParagraph"><u></u><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><span>4.<span style="font:7pt "Times New Roman"">
</span></span></span><u></u><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Add your target db to bucardo (bucardo add db B, with tables etc)<br>
</span><span lang="EN-US" style="font-size:10pt;font-family:"Courier New"">bucardo add db db_B dbhost=myhost_B dbport=5432 dbname=mydbname dbuser=mydbuser dbpass=mydbpassword</span><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u><u></u></span></p>
<p class="gmail-m_-5143380052516365813MsoListParagraph"><u></u><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><span>5.<span style="font:7pt "Times New Roman"">
</span></span></span><u></u><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Create a sync that has:<u></u><u></u></span></p>
<p class="gmail-m_-5143380052516365813MsoListParagraph" style="margin-left:72pt">
<u></u><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><span>a.<span style="font:7pt "Times New Roman"">
</span></span></span><u></u><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">database A as source, database B as target if you want a master to slave replication<br>
</span><span lang="EN-US" style="font-size:10pt;font-family:"Courier New"">bucardo add dbgroup grp_m2s_mydbname db_A:source db_B:target<br>
bucardo add sync sync_mydbname_m2s dbs=grp_m2s_mydbname [‘tables=’]</span><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u><u></u></span></p>
<p class="gmail-m_-5143380052516365813MsoListParagraph" style="margin-left:72pt">
<u></u><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><span>b.<span style="font:7pt "Times New Roman"">
</span></span></span><u></u><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">both databases as source if you want a master to master replication (you should choose a conflit resolution
strategy, I use “<i>bucardo_latest</i>”)<br>
</span><span lang="EN-US" style="font-size:10pt;font-family:"Courier New"">bucardo add dbgroup grp_m2m_mydbname db_A:source db_B:source<br>
bucardo add sync sync_mydbname_m2m dbs=grp_m2m_mydbname conflict_strategy=bucardo_latest [‘tables=’]</span><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u><u></u></span></p>
<p class="gmail-m_-5143380052516365813MsoListParagraph"><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">More precisely I created a dbgroup with both databases, and then I add that dbgroup to the sync.<br>
The “tables” parameter is optional, to specify a subset of tables to be replicated (comma separated).<u></u><u></u></span></p>
<p class="gmail-m_-5143380052516365813MsoListParagraph"><u></u><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><span>6.<span style="font:7pt "Times New Roman"">
</span></span></span><u></u><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Start bucardo</span><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">[…]<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Hope it can help,<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">regards.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Mattia<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif">From:</span></b><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif"> Bucardo-general <<a href="mailto:bucardo-general-bounces@bucardo.org" target="_blank">bucardo-general-bounces@bucardo.org</a>>
<b>On Behalf Of </b>Lucas Possamai<br>
<b>Sent:</b> giovedì 27 maggio 2021 01:15<br>
<b>To:</b> <a href="mailto:bucardo-general@bucardo.org" target="_blank">bucardo-general@bucardo.org</a><br>
<b>Subject:</b> [Bucardo-general] Bucardo with two way replication<u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal">Hello all,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">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.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">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.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Example:<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<blockquote style="margin-left:30pt;margin-right:0cm">
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal">source db (PG 9.2) --> Bucardo --> target db (PG 12)<u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal">target db (PG 12) --> Bucardo --> source db (PG 9.2)<u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">So, it means that I'll need a two way replication set up.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">I couldn't find anything online about this process. Does anybody have any suggestions or steps to follow, please?<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Regards,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Lucas<u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote></div>