Changes between Version 2 and Version 3 of drmsSubscribe


Ignore:
Timestamp:
06/27/14 09:43:49 (10 years ago)
Author:
niles
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • drmsSubscribe

    v2 v3  
    5353 
    5454And then after a longer period of time - two weeks? - these archives of slony log files are deleted. It is **critical** that the slony logs are applied at remote sites before they deleted at JSOC. 
     55 
     56=== Slony and the DRMS database === 
     57 
     58The small table _jsoc.sl_archive_tracking contains information about the most recent slony log ingested : 
     59 
     60{{{ 
     61prompt> psql nso_drms 
     62 
     63nso_drms=# select * from _jsoc.sl_archive_tracking; 
     64 at_counter |         at_created         |        at_applied 
     65------------+----------------------------+--------------------------- 
     66     886400 | 2014-06-27 09:36:17.452634 | 2014-06-27 16:37:03.71184 
     67 
     68}}} 
     69