On Mon, Jan 04, 2010 at 03:34:55PM -0500, Vick Khera wrote: > > My question is can I implement it as a single slonik script with 100 > EXECUTE SCRIPT commands and some "wait" between, or do I need to > implement 100 slonik scripts and execute them within a shell script > loop and appropriate wait in between.
Since it's one transaction, you'll be blocked the whole time. > Perhaps my best strategy will be to run this script on my replica node > only, swap master, then run it on the old origin using EXECUTE ONLY ON > parameter. That sounds like a more promising avenue to me, yes. A -- Andrew Sullivan [email protected] _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
