Hi, thanks all for the replies.

If I can take advantage of your expertise in this field, how would you
handle this scenario?

Each installation is upgraded on it's own without any specific order.
Upgrading all the three plants at once is not an option, so schemas
sometimes will be slightly different.

I'm considering to use a message exchange like this

<table="aaa" op=insert>
<column name=""/>
...

and then process each message in a custom "apply" method custom written for
each slave plant. But I fee a LOT like I'm reinventing the wheel.

I cannot use any complex tool for data migration because there is not, nor
there will be, the expertise for it and 99% of the differences should be
trivial.

For very complex schema changes I think some different strategy coud be
evaluated. In these cases I think a "data-migration only" upgrade could be
considered.



Thanks, bye

Lorenzo
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20100531/77ab5d35/attachment.htm