Forum OpenACS Q&A: Recommended upgrade path to OpenACS 3.2.5

I have a system running OpenACS 3.2.2 that is very customized and a OpenACS 3.2.4 that is almost new. I am interested in upgrade strategies to OpenACS 3.2.5

  • Did the postgres data model change? If so, do I convert my old data (pg_dump) to the new?

  • Did the code in /parameters and /tcl change? If so, can I just copy over with the new files?

  • The code in /www did change in many places. Can I just pick and choose directories to update? I know I will have some file by file updates to do especially on customized pages.

  • There are compelling reasons to upgrade to PostGresql 7.1 ! Will OpenACS 3.2.2 run unchanged once I get over the pgdump / restore hurdle? I read on another thread that 7.1 RC2 is broken with regard to restore.... I'm looking forward to a easy conversion / upgrade. The gzipped datafile is over 20 MB in size!

  • Does PG 7.1 run lztext without modifications?


Posted by Ben Adida on
Changes in the 3.2.x branches:

- yes, the data model changed. However, the upgrade scripts for
3.2.2 to 3.2.4 and 3.2.4 to 3.2.5 are provided. As long as you
didn't change the data model in a way that would conflict with our
new field names and PL/SQL procs, you should be fine (95%
chance that you're fine, but try it out on a sample snapshot of
your DB first).

- yes, /tcl has some changes. If you've made no changes, you
can copy over the new files and you shoud be fine. With /
parameters, you will want to merge your parameter names with
the new file. We've only *added* parameters, so you can do a diff
between the two vanilla parameter files and add the missing
sections to your version of your parameter file.

- you can pick and choose changes in /www if you'd like, but if
you use a section of /www, the corresponding /tcl procs should
correspond by version. It might be worthwhile starting with a
vanilla 3.2.5 (when it comes out soon!) and reapplying your
changes. In many cases, you may be able to simply apply the
diffs from 3.2.4 to 3.2.5.

- to the best of my knowledge, you can run OpenACS 3.2.x on PG
7.1. I will let someone else address the restore problem. And
yes, I believe lztext still works, although it's now the same as text.