Thanks to everyone for their replies. Where can I get "test_slony_state.pl" from?
Thanks Aaron Randall VisionOSS Ltd. Providing excellence in OSS architecture and solutions consultancy Email: [EMAIL PROTECTED] Mobile: +44 (0)7742 432165 Christopher Browne wrote: > Aaron Randall <[EMAIL PROTECTED]> writes: > >> 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. >> > > Well, you can get some implicit "all is running well" if you run > select * from _cluster.sl_status; > > If it shows all the nodes you expect, and shows that they are only an > event or two behind, then replication should be functioning well. > > That's about the best metric I can think of without looking at the > logs. > > You could also run the script test_slony_state.pl (or the DBI > version); that checks a number of things about how things are running. > _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
