Andrew Sullivan <[EMAIL PROTECTED]> writes: > On Sun, Apr 22, 2007 at 08:27:27PM -0700, Andrew Hammond wrote: >> In case there are any people who come upon this thread searching the mailing >> list for related topics, to unhide triggers on your replica, you'd need to >> run the store trigger command via slonik. > > And a _really_ nifty trick is that you can STORE TRIGGER _before the > trigger is installed_. This means if you want to add a trigger to > all nodes, and don't want to take the outage right away (because of a > lock on the table you're adding it to), you could STORE TRIGGER and > then add the relevant trigger to the origin node when you have your > next outage (just don't forget!)
Hey, that's well worth adding to the documentation! (As Chris does C-x C-f ~/Slony/CMD/slony-HEAD/docs/adminguide...) -- select 'cbbrowne' || '@' || 'ca.afilias.info'; <http://dba2.int.libertyrms.com/> Christopher Browne (416) 673-4124 (land) _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
