Forum OpenACS Q&A: Re: Error running OpenACS 4.6.3 upgrade queries

Collapse
Posted by Richard Hamilton on
OK, I see now that there are actually three scripts that I need to apply - 4.6 to 4.6.1, 4.6.1 to 4.6.2 and 4.6.2 to 4.6.3.

The package manager installer only offers me a single row for acs-kernel with is ACS Kernel 4.6.3, which I now take to mean just the third upgrade script.

Can I just apply these upgrade scripts by hand from the command line like this:

psql -f ./packages/acs-kernel/sql/postgresql/upgrade-4.6-4.6.1 > upgrade-to-4.6.1.log 2>&1
psql -f ./packages/acs-kernel/sql/postgresql/upgrade-4.6.1-4.6.2 > upgrade-to-4.6.2.log 2>&1

and then use package manager for the third one?

Followed by the same process for all installed packages.

Or is there a better way?