> > > On Mar 5, 2020, at 10:13 AM, Troy Denton <[email protected]> > wrote: > > > > Is onetimecopy still supported in bucardo 5? I'm adding new tables to > an existing sync and want to copy over those tables. The tables exist on > both machines, with data existing in one of them. I can't seem to make it > work, steps I followed: > > > > bucardo add table <table> relgroup=<relgroup> db=<db> > > bucardo validate sync <the sync that uses this relgroup> > > bucardo update sync <the sync that uses this relgroup> onetimecopy=2 > > bucardo kick <the sync that uses this relgroup> > > > > Never saw the data copy over, or the 'one time copy' in the status go to > false. I tried reloading that sync [i got an error], stopping/starting > bucardo, and then the status said that onetimecopy was false, but my data > had not transferred. > > > > I've just manually transferred the data for now, but would like to know > the correct process moving forward. > > It *should* work, though I’m curious what error the you mentioned was. I > assume the target table was completely empty first if you were trying to > use onetimecopy=2? > > Which Bucardo version? >
Hey David, The target table was completely empty. There are other tables in the same relgroup that would not have been completely empty though - could that be the misunderstanding? The error I am getting is: "Reloading sync tndb_sync...Reload of sync tndb_sync failed; reload response message never received". I just tried it now and got the same result. I am running bucardo 5.5.0 -------------------------------- Troy Denton, P. Eng. Senior Telecom Analyst 24-7 Intouch 204.666.4651 | mobile 24-7intouch.com | [email protected] 240 Kennedy St | Winnipeg, Manitoba, Canada R3C 1T1 Confidentiality Note: This e-mail message and any attachments to it are intended only for the named recipients and may contain legally privileged and/or confidential information. If you are not one of the intended recipients, please do not duplicate or forward this e-mail message and immediately delete it from your computer. On Thu, Mar 5, 2020 at 10:15 AM David Christensen <[email protected]> wrote: > > On Mar 5, 2020, at 10:13 AM, Troy Denton <[email protected]> > wrote: > > > > Is onetimecopy still supported in bucardo 5? I'm adding new tables to > an existing sync and want to copy over those tables. The tables exist on > both machines, with data existing in one of them. I can't seem to make it > work, steps I followed: > > > > bucardo add table <table> relgroup=<relgroup> db=<db> > > bucardo validate sync <the sync that uses this relgroup> > > bucardo update sync <the sync that uses this relgroup> onetimecopy=2 > > bucardo kick <the sync that uses this relgroup> > > > > Never saw the data copy over, or the 'one time copy' in the status go to > false. I tried reloading that sync [i got an error], stopping/starting > bucardo, and then the status said that onetimecopy was false, but my data > had not transferred. > > > > I've just manually transferred the data for now, but would like to know > the correct process moving forward. > > It *should* work, though I’m curious what error the you mentioned was. I > assume the target table was completely empty first if you were trying to > use onetimecopy=2? > > Which Bucardo version? > > Best, > > David >
_______________________________________________ Bucardo-general mailing list [email protected] https://bucardo.org/mailman/listinfo/bucardo-general
