The last event originating on node 1 was 73226. The last event originating on node 1 that was received by node 2 was 73226. Describe the view sl_status, and you'll see the way the lagtime is calculated.

Geoffrey wrote:
Can someone tell me what is meant by the following data from sl_status?

st_origin | st_received | st_last_event | st_last_event_ts | st_last_received | st_last_received_ts | st_last_received_event_ts | st_lag_num_events | st_lag_time -----------+-------------+---------------+----------------------------+------------------+---------------------------+----------------------------+-------------------+------------- 1 | 2 | 73226 | 11/18/2008 09:52:03.588658 | 73226 | 11/18/2008 09:54:45.17624 | 11/18/2008 09:52:03.588658 | 0 | @ 2.25 secs
(1 row)

That is, 'st_origin' == 1. Does 1 indicate a particular status? Same for 'st_received', what does the value 2 tell me?

Is 2.25 secs st_lag_time good?

Thanks for any info.



--
JP Fletcher
Database Administrator
Afilias Canada
voice: 416.646.3304 ext. 4123
fax: 416.646.3305
mobile: 416.561.4763
[EMAIL PROTECTED]


_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general

Reply via email to