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.