[Bucardo-general] Confused about multi-master configuration

Greg Sabino Mullane greg at endpoint.com
Mon May 28 20:27:52 UTC 2012

On Sat, May 12, 2012 at 03:58:09PM +0400, Andrey Solovjov wrote:
> I am trying to investigate this and enabled debug log on postgres
> I see that bucardo is connected to remote DB but pgsql doesn't send
> NOTIFY events (seems that bucardo doesn't start LISTENing ?)
> It does some stuff on the remote db when starts but it there is no
> LISTEN statement which I can see in the log files on the local
> server.
> Should bucardo LISTEN for notifies on a remote db?

Yes, as long as ping is enabled.

> >I try to UPDATE table sipregs on ast1 and this update is not
> >replicated to master (there is also nothing in logs).
> >I see Bucardo has successfully added all triggers for tables
> >sipregs on ast1 and if I kick sipregs_repl sync manually the
> >update is replicated.
> >I am confused maybe bucardo should be installed on second server?
> >Or what else should I pay attention to?

Check if the tables have a "triggerkick" trigger on them. If they do, 
they should be issuing a NOTIFY whenever they are changed. If I get 
some time, I'll dig deeper into your configuration.

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/20120528/47bfaef5/attachment.sig>

More information about the Bucardo-general mailing list