Tue Nov 18 08:59:29 PST 2008
- Previous message: [Slony1-general] sl_status what does it mean?
- Next message: [Slony1-general] sl_status what does it mean?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 jpfletch at ca.afilias.info
- Previous message: [Slony1-general] sl_status what does it mean?
- Next message: [Slony1-general] sl_status what does it mean?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list