Cluster-Processing.md

@@ -217,6 +217,48 @@ For the Fusion Quicklooks we similarly have
 select find_contexts_arguments || 'version=>"''1.0dev4''"' from forward_streams where name = 'FusionMatlabDailyQL';
 update forward_streams set find_contexts_arguments = find_contexts_arguments || 'version=>"''1.0dev4''"' where name = 'FusionMatlabDailyQL';
 ```
+## Deleting a Forward Stream Instance
+
+We can examine the forward stream instances by running
+
+```
+psql $flo_user -c "select name,find_contexts_arguments,workflow_head from forward_streams;" | grep Fusion
+```
+resulting in
+```
+FusionMatlab                         | "version"=>"'1.0dev10'", "satellite"=>"'snpp'"        | flo.sw.fusion_matlab:FUSION_MATLAB
+FusionMatlabDailyQL                  | "version"=>"'1.0dev7'", "satellite"=>"'snpp'"         | flo.sw.fusion_matlab:FUSION_MATLAB_QL
+FusionMatlab_jpss1                   | "version"=>"'1.0dev10'", "satellite"=>"'noaa20'"      | flo.sw.fusion_matlab:FUSION_MATLAB
+FusionMatlabDailyQL_jpss1            | "version"=>"'1.0dev7'", "satellite"=>"'noaa20'"       | flo.sw.fusion_matlab:FUSION_MATLAB_QL
+```
+To delete each of these, we enter the `psql` shell and execute a series of `begin-delete-commit` transactions...
+```sql
+flo3=> begin;
+BEGIN
+flo3=> delete from forward_streams where name = 'FusionMatlabDailyQL';                                                                                                                                                                                                                                                                                                                                                                                                                         
+DELETE 1
+flo3=> commit;
+COMMIT
+flo3=> begin;
+BEGIN
+flo3=> delete from forward_streams where name = 'FusionMatlabDailyQL_jpss1';                                                                                                                                                                                                                                                                                                                                                                                                                   
+DELETE 1
+flo3=> commit;
+COMMIT
+flo3=> begin;
+BEGIN
+flo3=> delete from forward_streams where name = 'FusionMatlab_jpss1';                                                                                                                                                                                                                                                                                                                                                                                                                          
+DELETE 1
+flo3=> commit;
+COMMIT
+flo3=> begin;
+BEGIN
+flo3=> delete from forward_streams where name = 'FusionMatlab';                                                                                                                                                                                                                                                                                                                                                                                                                                
+DELETE 1
+flo3=> commit;
+COMMIT
+flo3=>
+```
 
 ## Examining log files of failed jobs