from OpenACS. Since the version I'm currently running is from
October of last year, I figured that the easiest thing to do would
probably be to start from scratch: There are no upgrade scripts.
But moving data from one installation to another is no easy feat.
With all this object crud, there are tons of rows in tons of tables
to move. And if I want people's bookmarks to keep working, I'll have
to preserve the object_id of all the public objects! This isn't
going ot be easy!
Anyway, the problem I'm run into just now is that when I do a clean
install of OACS 4 from CVS on PG 7.2, and I install the packages
that I need to stuff data into, it's already taken up a lot of
object_id numbers that I need for objects from my old server.
What's puzzling me is that there are large gaps in the object_id
sequence. There's a jump from object_id 1437 to object_id 2033, for
instance, almost 600 numbers, but there are plenty more gaps like
Any idea why this is? Is this a PG feature? Or something that we do
Btw, if someone have any clever ideas for how I can do this awful
migration job smarter, please do chip in :)