<div dir="ltr">Hi, <div>I am using Bucardo to migrate a db that is several terabytes. I did some initial tests and it was going to take about a week. I am a little worried about setting session_replication_role to 'replica' for that long and was hoping to speed up the process by using pg_dump/pg_restore and then finish up with bucardo to get the final few rows. </div><div><br></div><div>I'm having some trouble figuring out the exact sequence of commands to get this working. My guess is something like:</div><div><br></div><div>1) pg_dump source_db</div><div>2) Add dbs and tables to bucardo</div><div>3) Add the sync --</div><div>





<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Monaco"><font color="#000000" style="background-color:rgb(255,255,255)"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures"><br></span></font></p><p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal"><font color="#000000" style="background-color:rgb(255,255,255)" face="arial, sans-serif"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures">./bucardo add </span><span class="gmail-s2" style="font-variant-ligatures:no-common-ligatures">sync</span><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures"> the_</span><span class="gmail-s2" style="font-variant-ligatures:no-common-ligatures">sync</span><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures"> status=inactive onetimecopy=0 relgroup=copying_herd dbs=source_db:source,dest_db:target herd dbs=source_db:source,dest_db:target</span></font></p><p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Monaco"><font color="#000000" style="background-color:rgb(255,255,255)"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures"><br></span></font></p><p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal"><font color="#000000" style="background-color:rgb(255,255,255)" face="arial, sans-serif"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures">4) pg_restore dest_db</span></font></p><p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal"><font color="#000000" style="background-color:rgb(255,255,255)" face="arial, sans-serif"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures">5) ./bucardo activate the_sync</span></font></p><p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal"><font color="#000000" style="background-color:rgb(255,255,255)" face="arial, sans-serif"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures"><br></span></font></p><p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal"><font color="#000000" style="background-color:rgb(255,255,255)" face="arial, sans-serif"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures">Is this the right way? One thing I am confused about is what the 'autokick' option does and if it is needed here.</span></font></p><p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal"><font color="#000000" style="background-color:rgb(255,255,255)" face="arial, sans-serif"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures"><br></span></font></p><p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal"><font color="#000000" style="background-color:rgb(255,255,255)" face="arial, sans-serif"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures">Thanks,</span></font></p><p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal"><font color="#000000" style="" face="arial, sans-serif"><span style="font-variant-ligatures:no-common-ligatures">David</span></font></p></div></div>