[Bucardo-general] onetimecopy=1 (fullcopy) replica not the same number records all tables

Greg Sabino Mullane greg at endpoint.com
Mon Jan 23 16:31:41 UTC 2017


On Wed, Jan 18, 2017 at 04:40:59PM -0800, Don St. Denis wrote:
> When I set onetimecopy=1 I get the majority of the database system copied
> but there are discrepancies on a few of the 277 tables and 100 sequences in
> the herd. The one time copy takes about 4 hours. I performed this 2x and see
> the same exact discrepancies both times.

That's a lot of variables to work through. Could you create a new sync 
with just a single table and see if you can duplicate the problem? 
Showing the log.bucardo output for that sync run would help a lot.
Perhaps this small table?:

>    < Number of records in public.search_monthly_amounts_y2006_m04: 0
>    ---
>    > Number of records in public.search_monthly_amounts_y2006_m04: 6988


-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944  45B4 BC9B 9067 1496 4AC8

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20170123/29025247/attachment.sig>


More information about the Bucardo-general mailing list