Changes between Version 5 and Version 6 of drmsSubscribe

Timestamp:

02/18/15 08:32:55 (9 years ago)

Author:

niles

Comment:

--

drmsSubscribe

@@ -92 +92 @@
 }}}
 
+=== Manual cleanup before subscription ===
 
+Sometimes it becomes necessary to manually clean out after a failed attempt at subscription, since if tables are partially built it can block subsequent
+subscription attempts. To do this for the hmi.v_720s series, the following
+needs to be done in the database :
 
+{{{
+DROP TABLE hmi.v_720s;
+DROP SEQUENCE hmi.v_720s_seq;
+DELETE FROM hmi.drms_series where seriesname = 'hmi.v_720s';
+DELETE FROM hmi.drms_segment where seriesname = 'hmi.v_720s';
+DELETE FROM hmi.drms_keyword where seriesname = 'hmi.v_720s';
+}}}
+
+NOTE that you MUST then subscribe. Otherwise your slony updates may pertain to this table, which could cause slony updates to fail.