On Tue, 2008-11-11 at 08:09 -0500, Geoffrey wrote: > I'm looking for suggestions as to the best way to verify that my single > slave is in sync with my master. We've had a couple of situations (self > induced) where we've created problems for slony and therefore would like > to provide a warm and fuzzy feeling that slony is current. > > I've considered simply doing a couple of 'select count(*)' against > various tables and comparing the results between the master and slave, > but this seems to be a bit of a hatchet job. > > I seem to recall there are is some statistical data in a slony table, > but I can't for the life of me locate that discussion.
Look at the sl_status view on the provider. It's in the Slony created schema. -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp. _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
