[OPEN-ILS-DEV] Upgrade RC2 to RC3

[Dan Scott]

On Thu, Jan 27, 2011 at 12:24:47PM -0500, Jason Stephenson wrote:
> Grant, et al.

<snip>

> When you install from SVN, the config.upgrade_log table gets an
> entry with a numeric string value of the database version, "0478"
> for instance. When you update your SVN working copy to update your
> installation, there will be a group of SQL files in the
> Open-ILS/src/sql/Pg/upgrade directory whose names are prefixed with
> version strings. After or before installing the new code, you simply
> need to run each of these scripts on your database one at a time, in
> order, beginning with the first one numbered after your current
> database version.

<snip>

Great description! And to potentially make your life easier, there's a
script that is supposed to automate this for you in
build/tools/update_db.sh 

> When you install Evergreen from a tarball (a .tar.gz file), the
> config.upgrade_log is not currently set with the latest database
> version number in the same way that it is set from a SVN checkout.
> This means that there is no easy way to upgrade your database
> without running eg_db_config.pl and recreating the schemas thereby
> losing all of your data.

Mmm, that's not true, actually. 002.schema.config.sql contains 
INSERT INTO config.upgrade_log (version) VALUES ('0478'); 

So in theory you should be able to use update_db.sh to jump from
the config.upgrade_log entry you got in 2.0RC2 ('0474') to 2.0RC3
(or 2.0.0 final, now that that has been released in the last 24 hours).