On Wed, Feb 15, 2017 at 12:14:02AM +0530, Raghu Udiyar wrote: .. > 1. Install bucardo triggers by adding source DB only in a new sync. > Verified that delta table is being filled. > 2. Take snapshot of the source DB, and restore on target DB.
What are you using to "snapshot"? > active | SELECT * FROM bucardo.bucardo_delta_check($1,$2) > active | SELECT * FROM bucardo.bucardo_delta_check($1,$2) > active | SELECT * FROM bucardo.bucardo_delta_check($1,$2) The first step is fixing these. It looks like you have multiple Bucardo processes running, each of which is still trying to run bucardo_delta_check(). Kill all your Bucardo proceses, make sure nothing is still running by checking pg_stat_activity, then add this to your ~/.bucardorc file: quick_delta_check=0 Then restart Bucardo and see what happens. -- Greg Sabino Mullane [email protected] End Point Corporation PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
Description: PGP signature
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
