could you explain more detail on how did you set a new table to collect table
update times



Cédric Villemain wrote:
> 
> Darcy Buskermolen a écrit :
>> On Friday 07 December 2007 06:52:05 Glyn Astill wrote:
>>   
>>> Hi All,
>>>
>>> Is there a way we can monitor Slony to ensure it is in sync and that
>>> it is still working?
>>>
>>> Also is there any way to validate our data?
>>>
>>> Reporting tools or shell script ideas would be ace
>>>     
>>
>> on the origin server:
>>
>> select * from _CLUSTERNAME.sl_status;
>>
>>
>>
>>   
> I used to add a table 'last_update_X' to setX, updated every second, and 
> then check the result accross the cluster and graph the diff
>>> Glyn Astill
>>>
>>>
>>>
>>>       __________________________________________________________
>>> Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com
>>>
>>>
>>> _______________________________________________
>>> Slony1-general mailing list
>>> Slony1-general at lists.slony.info
>>> http://lists.slony.info/mailman/listinfo/slony1-general
>>>     
>>
>>
>>
>>   
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
> 
> 

-- 
View this message in context: http://www.nabble.com/Slony-replication-monitoring-tp14213956p25290598.html
Sent from the Slony-I -- General mailing list archive at Nabble.com.