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

akp geek akpgeek at gmail.com
Mon Jun 21 20:43:06 UTC 2010


As I have mentioned in my post, I did not turn on the logs. I should have
done it. The version is bucardo_ctl version 4.4.0 , and db
version  PostgreSQL 8.4.1

the sync is the to pushdelta.

that's all I have, now it is running quietly

Regards


On Fri, Jun 18, 2010 at 3:31 PM, Greg Sabino Mullane <greg at endpoint.com>wrote:

> >               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 --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20100621/ed64462a/attachment.html 


More information about the Bucardo-general mailing list