[Bucardo-general] trigger on slave table for Burcardo

akp geek akpgeek at gmail.com
Wed Feb 23 11:20:34 UTC 2011

thanks for providing me some direction. I will custom code per our


On Wed, Feb 23, 2011 at 1:15 AM, Rosser Schwarz <rosser.schwarz at gmail.com>wrote:

> On Tue, Feb 22, 2011 at 2:45 PM, akp geek <akpgeek at gmail.com> wrote:
> > Is it possible to have a trigger on the
> > slave at all? or if it is possible is there any special instructions to
> be
> > followed?
> Bucardo disables triggers and rules on tables during replication.
> This is usually the Right Thing for a number of reasons, but leave it
> to the internets to find someone with a use-case where it's not
> quite...
> Is Bucardo the only thing writing to the table on which you've put the
> trigger?  If so, you might be able to get the desired result by
> writing a customcode that performs the modifications on the new table.
>  There's some documentation on the wiki you can look at, though it's
> pretty sparse.  The gist of it is that you can define a Perl sub
> that's executed at some (specified) point in the context of a
> replication event. Being a custom Perl sub, you can do pretty much
> whatever you want in it, including modify or perform additional
> operations with the row(s) being replicated.
> I haven't personally used customcodes but they've been used quite
> successfully in environments I've worked in, so I think that's
> probably your first bet. Unfortunately, I can't speak any more
> specifically than that.
> Can someone with more direct experience or knowledge chime in and
> elaborate?
> Thanks.
> rls
> --
> :wq
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20110223/12b3f3e8/attachment.html 

More information about the Bucardo-general mailing list