[Bucardo-general] trigger on slave table for Burcardo
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
> > 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
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Bucardo-general