[Bucardo-general] onetimecopy in bucardo 5

[David Christensen]

> On Mar 5, 2020, at 10:27 AM, Troy Denton <tdenton at 24-7intouch.com> wrote:
> 
> > On Mar 5, 2020, at 10:13 AM, Troy Denton <tdenton at 24-7intouch.com> 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
david at endpoint.com
785-727-1171



-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: Message signed with OpenPGP
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20200306/37568b77/attachment.sig>