Just to clarify, your plan would mean that I would be able to: 1) run a script that dumps enough information to re-create the cluster from its current state 2) do the various unsubscribes/uninstalls of slony 1.x bits 3) Install new slony 2.x code 4) run this dumped script (more or less) to bring my cluster back to life
For me the key bit is (1), since my cluster configurations (I have several created over a long period of time) means that my heart sinks at the idea of having to re-create all the clusters from scratch, plus the OMIT COPY bit looks like a huge win. Mark On Fri, 2009-06-12 at 16:42 -0400, Christopher Browne wrote: > Let me note that... > > - The "grovelling around the configuration" approach took a couple of > days work to simply think about what *appeared* to be all of the > complexities, forget about starting to implement them. > > - I started work on OMIT COPY yesterday afternoon, and had something > passing tests this afternoon, and I wasn't working on it full time. > > The difference in complexity between the approaches is pretty > staggering ;-). > > There is a *bit* of complexity in that you need to have slonik scripts > around to re-initialize the cluster. I've got a 3/4-there script in > tools/slonikconfdump.sh; it is missing two things that I'd like to > have before treating this as finalized: > > a) We need something to pull information about triggers out of the > former sl_trigger table, and generate ALTER TABLE statements to apply > to the appropriate nodes. > > b) There needs to be a topological sort of the subscriptions so as to > do them in the correct order. --- Mark Hagger Senior Software Engineer mxData Ltd Incorporating m-spatial Head Office: Alderley House, Alderley Road, Wilmslow, Cheshire, SK9 1AT Technology Centre: St John’s Innovation Centre, Cowley Road, Cambridge, CB4 0WS Marketing & PR: 85 Tottenham Court Road, London, W1T 4TQ [email protected] www.mxdata.co.uk M: +44(0)7814 020931 T: +44 (0)1223 421534 ________________________________________________________________________ This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. The opinions expressed in this e-mail are those of the author and do not necessarily represent the views of m-spatial Ltd, mxData Ltd or any affiliates. No reliance may be placed on this e-mail without the written confirmation from an expressed representative of m-spatial Ltd or mxData Ltd. Any prices or terms expressed within this e-mail are subject to contract. If you are not the intended recipient of this email, please notify the [email protected].
<<attachment: mxdata.jpg>>
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
