[Bucardo-general] Pushdelta sync with a PG snapshot / restore fails to work bucardo 5.4.1

[Greg Sabino Mullane]

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 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/20170215/7e28a469/attachment.sig>