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. > > Regards, > > Aaron > > _______________________________________________ > Slony1-general mailing list > [email protected] > http://gborg.postgresql.org/mailman/listinfo/slony1-general -- Darcy Buskermolen Wavefire Technologies Corp. http://www.wavefire.com ph: 250.717.0200 fx: 250.763.1759 _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
