Re: Rod Taylor

> >At the VERY LEAST, you'd best get off 7.2.1 to something later (i.e.
> >the last 7.2 release). ISTR some nasty bug or other in 7.2.1.
>
> I heard for Andrew Sullivan that you managed to hack Slony-I to work
> for postgre 7.2.
> Can you tell me how you did as it would me helpful to me

I no longer have the code, but (from memory) this is approximately what
you need to do:

* Take the 7.3 templates and copy them to 7.2 -- or otherwise
hardcode the version your using to pick up the 7.3 templates
* Remove all traces of schemas from the code and sql templates. I
basically changed the "." to an "_".
* Bunch of work related to the XID datatype and functions. For
example, Slony creates CASTs for the xid to xxid and back -- but
7.2 cannot create new casts that way so you need to edit system
tables by hand. I recall creating an Operator Class and editing
several functions as well.
* sl_log_1 will have severe performance problems with any kind of
data volume. This required a number of index and query changes
to optimize for 7.2. 7.3 and above are quite a bit smarter in
terms of optimizations they can apply.
* Don't bother trying to make sequences work. Do them by hand
after the upgrade using pg_dump and grep.

Of course, now that you have done all of the above, it's not compatible
with standard Slony now. So you either need to implement 7.2 in a less
hackish way, or you can also hack up slony to work without schemas on
newer versions of PostgreSQL so they can talk to each other.

Almost immediately after getting the DB upgraded from 7.2 to 7.4, we
deinstalled the hacked up Slony (by hand for the most part), and started
a migration from 7.4 to 7.4 on a different machine using the regular
Slony. This was primarily to ensure we didn't keep our system catalogues
which had been manually fiddled with.

All that said, we upgraded a few hundred GB from 7.2 to 7.4 with about
30 minutes actual downtime (versus 48 hours for a dump / restore cycle)
and no data loss.
--