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

Greg Sabino Mullane greg at endpoint.com
Thu Jan 26 19:19:38 UTC 2017


There should be triggers or rules that move data from the parrent table to 
the child tables. Unless the app itself does so. Can you show the output 
of this on the master db:

\d+ public.all_search_events

> bucardo_delta AFTER INSERT OR DELETE OR UPDATE ON search_events_y2015_m11 FOR EACH ROW EXECUTE PROCEDURE delta_public_search_events_y2015_m11()
> bucardo_kick_the_sync AFTER INSERT OR DELETE OR UPDATE OR TRUNCATE ON search_events_y2015_m11 FOR EACH STATEMENT EXECUTE PROCEDURE bucardo_kick_the_sync()
> bucardo_note_trunc_the_sync AFTER TRUNCATE ON search_events_y2015_m11 FOR EACH STATEMENT EXECUTE PROCEDURE bucardo_note_truncation('the_sync')

Was this the master or the replica? Maybe you can send me the output of:

bucardo show all

(sending private is fine if you don't want to send to the list)

-- 
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/20170126/c2de731b/attachment.sig>


More information about the Bucardo-general mailing list