Tue Apr 8 19:23:17 PDT 2008
- Previous message: [Slony1-general] Postgresql upgrades and Slony
- Next message: [Slony1-general] Postgresql upgrades and Slony
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Jeff Frost <jeff at frostconsultingllc.com> writes: > On Tue, 8 Apr 2008, Christopher Browne wrote: > >> salman <salmanb at quietcaresystems.com> writes: >>> Ugh. So any existing scripts and/or cron jobs would have to be >>> modified and tested, again, to make sure they work. I was hoping such >>> a base feature would be in there and I just missed it while going >>> through the docs page, but I guess not. >> >> It was not made clear that renumbering nodes is not practical; I have >> patched the docs to indicate this... >> >> http://lists.slony.info/pipermail/slony1-commit/2008-April/002226.html > > Christopher, > > Any chance of changing the slonik functions to have a default EVENT > NODE of <ORIGIN NODE> instead of 1? I think this plus the ability to > DEFINE aliases would take care of all these issues. Perhaps we should > make the DEFINE more prominent in the docs. I suppose also making > EVENT NODE required instead of optional could help with that as well. <ORIGIN NODE> has two demerits: a) If there is more than one origin node, then it may be ambiguous (if the command also specifies a set that it operates on, then that ambiguity would go away). b) Calculating the origin node may require an extra DB query, which isn't particularly prohibitive from a performance standpoint, but it definitely would add to the complexity of the Slonik commands, which is somewhat of a pain :-( I think I'd rather go with making EVENT NODE a mandatory parameter. Actually, this is a *very* good time to debate this, as v2.0 would be a reasonable place for such changes to take place. It would not be overly intrusive, right now, to change EVENT NODE to be mandatory. After v2.0 gets released, such changes become rather more painful to make. Jan, what do you think of making EVENT NODE mandatory, and eliminating the "default of 1"? I kind of like that... -- (reverse (concatenate 'string "ofni.secnanifxunil" "@" "enworbbc")) http://www3.sympatico.ca/cbbrowne/advocacy.html Rules of the Evil Overlord #187. "I will not hold lavish banquets in the middle of a famine. The good PR among the guests doesn't make up for the bad PR among the masses." <http://www.eviloverlord.com/>
- Previous message: [Slony1-general] Postgresql upgrades and Slony
- Next message: [Slony1-general] Postgresql upgrades and Slony
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list