Cédric Villemain cedric.villemain at dalibo.com
Mon Dec 10 03:07:28 PST 2007
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
>>     
>
>
>
>   



More information about the Slony1-general mailing list