[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