<div style="font-family: arial; font-size: 14px;">Hi Roland,</div><div style="font-family: arial; font-size: 14px;"><br></div><div style="font-family: arial; font-size: 14px;">Please check the following links (and/or the bucardo man page):</div><div class="protonmail_signature_block" style="font-family: arial; font-size: 14px;">
</div>
<div style="font-family: arial; font-size: 14px;"><span><a target="_blank" rel="noreferrer nofollow noopener" href="https://bucardo.org/Bucardo/operations/onetimecopy">https://bucardo.org/Bucardo/operations/onetimecopy</a></span><br></div><div style="font-family: arial; font-size: 14px;"><span><a target="_blank" rel="noreferrer nofollow noopener" href="https://bucardo.org/Bucardo/object_types/fullcopy">https://bucardo.org/Bucardo/object_types/fullcopy</a></span><br></div><div style="font-family: arial; font-size: 14px;"><span><a target="_blank" rel="noreferrer nofollow noopener" href="https://bucardo.org/Bucardo/object_types/pushdelta">https://bucardo.org/Bucardo/object_types/pushdelta</a></span><br></div><div style="font-family: arial; font-size: 14px;"><br></div><div style="font-family: arial; font-size: 14px;">If you just add a "standard" sync and do nothing else, the tables will be copied over based on triggers. That's why existing values will not be copied.</div><div style="font-family: arial; font-size: 14px;"><br></div><div style="font-family: arial; font-size: 14px;">BR!</div><div class="protonmail_quote">
------- Original Message -------<br>
On Friday, April 29th, 2022 at 3:17 PM, Roland Che via Bucardo-general <bucardo-general@bucardo.org> wrote:<br><br>
<blockquote class="protonmail_quote" type="cite">
<div class="WordSection1">
<p class="MsoNormal">We want to use Bucardo as an upgrade solution so how will I go about promoting the standby</p>
<p class="MsoNormal">To become a standalone so applications can then connect to the newer version?</p>
<p class="MsoNormal"> </p>
<div>
<div style="mso-line-height-rule:exactly;-webkit-text-size-adjust:100%;direction:ltr;" dir="ltr"><table style="width:100%;" border="0" cellspacing="0" cellpadding="0"><tbody><tr style="font-size:0;"><td style="vertical-align:top;" align="left"><table style="font-size:0;" border="0" cellspacing="0" cellpadding="0"><tbody><tr style="font-size:0;"><td style="padding:20px 0 10px;vertical-align:top;" align="left"><table style="font-size:0;line-height:normal;" border="0" cellspacing="0" cellpadding="0"><tbody><tr style="font-size:0;"><td style="padding:0 10px 0 0;border-top:none;border-right:solid 3px #FFF5D7;border-bottom:none;border-left:none;vertical-align:top;" align="left"><img style="height:70px;min-height:70px;max-height:70px;font-size:0;" alt="" border="0" height="70" class="proton-embedded" src="cid:image615486.png@91408156.E9F04684"></td><td style="padding:0 0 0 10px;vertical-align:top;" align="left"><table style="width:100%;font-size:0;" border="0" cellspacing="0" cellpadding="0"><tbody><tr style="font-size:0;"><td style="vertical-align:top;" align="left"><table style="font-size:0;color:#1C4799;font-style:normal;font-weight:700;white-space:nowrap;" border="0" cellspacing="0" cellpadding="0"><tbody><tr style="font-size:14.67px;"><td style="padding:0 0 10px;vertical-align:top;font-family:Arial;" align="left">Roland Che<span style="font-family:remialcxesans;font-size:1px;color:#FFFFFF;line-height:1px;"></span></td></tr></tbody></table></td></tr><tr style="font-size:0;"><td style="vertical-align:top;" align="left"><table style="font-size:0;" border="0" cellspacing="0" cellpadding="0"><tbody><tr style="font-size:0;"><td style="vertical-align:top;" align="left"><table style="font-size:0;color:#EA5329;font-style:normal;font-weight:400;white-space:nowrap;" border="0" cellspacing="0" cellpadding="0"><tbody><tr style="font-size:12px;"><td style="padding:0 0 5px;vertical-align:top;font-family:Arial;" align="left">Senior Database Administrator II</td></tr></tbody></table></td></tr><tr style="font-size:0;"><td style="vertical-align:top;" align="left"><table style="font-size:0;" border="0" cellspacing="0" cellpadding="0"><tbody><tr style="font-size:0;"><td style="vertical-align:top;" align="left"><table style="font-size:0;color:#EA5329;font-style:normal;font-weight:400;white-space:nowrap;" border="0" cellspacing="0" cellpadding="0"><tbody><tr style="font-size:12px;"><td style="padding:0 5px 0 0;border-top:none;border-right:solid 2px #EA5329;border-bottom:none;border-left:none;vertical-align:top;font-family:Arial;" align="left"><a style="text-decoration:none;color:#EA5329;" id="LPlnk689713" target="_blank" href="mailto:Roland.Che@payroc.com" rel="noreferrer nofollow noopener"><strong style="font-weight:400;">Roland.Che@PAYROC.COM</strong></a></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table></div><div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Roland Che <br>
<b>Sent:</b> Friday, April 29, 2022 7:01 AM<br>
<b>To:</b> bucardo-general@bucardo.org<br>
<b>Subject:</b> ADVICE PLEASE</p>
</div>
</div>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Hello Team,</p>
<p class="MsoNormal">We are having an ubuntu 14.04 server with postgres 9.3 and we have issues upgrading the server so we want to use
</p>
<p class="MsoNormal">Bucardo to do a logical replication from postgres 9.3 to 13. I have done a test with Bucardo and I noticed existing data</p>
<p class="MsoNormal">Was not replicated.</p>
<p class="MsoNormal">My question is must I do an initial load like manually dump the existing data from the primary and restore on the standby node?</p>
<p class="MsoNormal">And another concern is while copying the existing data and application is still connected , what happened to the new inserts coming in from application when
</p>
<p class="MsoNormal">The replication has not started ? </p>
<p class="MsoNormal">Please advice on the process.</p>
<p class="MsoNormal"><img alt="Text
Description automatically generated" id="Picture_x0020_2" style="width:6.05in;height:3.55in" height="341" width="581" class="proton-embedded" src="cid:image001.png@01D85BA9.FCC0BD00"></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Regards</p>
<p class="MsoNormal">Roland Che.</p>
</div>
</blockquote><br>
</div>