> On Mar 5, 2020, at 10:27 AM, Troy Denton <[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? > > 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.
Were there any more details in the log.bucardo file or the postgresql logs? -- David Christensen Senior Software and Database Engineer End Point Corporation [email protected] 785-727-1171
signature.asc
Description: Message signed with OpenPGP
_______________________________________________ Bucardo-general mailing list [email protected] https://bucardo.org/mailman/listinfo/bucardo-general
