[Bucardo-general] Bucardo -- small issue with replication

Greg Sabino Mullane greg at endpoint.com
Fri Jun 18 19:31:25 UTC 2010

>               last night , we had an issue with our master database. we
>    had to truncate 2 tables on master. Before the truncate of the master
>    tables , we stopped the bucardo_ctl. Because we want to check data
>    before we proceed.  After that I truncated the slave tables. Started
>    the bucardo_ctl. One of the table which has 67000 rows replicated in no
>    time. The other table which has also 67000, it's taking for ever.
>    Incidentally I didnot turn on the logs for bucardo. made logs only for
>    warning. I did not get any warnings.  Is there any thing different I
>    should have done  to not to run into the issue

First, always enable logging, so you can figure out problems like this. 
The next version will have better logging control (just pushed a bunch 
of related commits today, will post more to the list in a few minutes).

Some questions:

What version of Bucardo and Postgres are you using?

What type of sync is it?

When you say "taking forever", where is it stuck? What processes are 
running on both the master and slave database?

Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20100618/b1b02257/attachment.bin 

More information about the Bucardo-general mailing list