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 [email protected] End Point Corporation PGP Key: 0x14964AC8
pgp7wDxbC5IdQ.pgp
Description: PGP signature
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
