Darcy Buskermolen wrote: > On Wednesday 18 January 2006 05:00, Aaron Randall wrote: > >>Hi Everyone :) >> >>I have a question similar to one that was raised a little while ago titled >>- "How do I know when a subscriber has caught up?". >> >>Is there a flag somewhere that confirms that the master and slave are >>connected (regardless of whether they are currently transmitting data) to >>show that Slony is running successfully on both. At the moment, the only >>was I can check is by tailing the Slony logs, but ideally I would like to >>use some kind of database field that could confirm/deny the master and >>slave(s) are connected successfully. > > > The _custername.sl_status view can be used for this purpose.
pgAdmin displays this too in the node statistics. Regards, Andreas _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
