Index: openacs-4/packages/acs-core-docs/www/upgrade-supporting.html =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/upgrade-supporting.html,v diff -u -r1.20.2.3 -r1.20.2.4 --- openacs-4/packages/acs-core-docs/www/upgrade-supporting.html 19 Nov 2016 09:21:55 -0000 1.20.2.3 +++ openacs-4/packages/acs-core-docs/www/upgrade-supporting.html 6 Jan 2017 09:18:42 -0000 1.20.2.4 @@ -40,7 +40,7 @@ function creation and at function calling, so they still match. But if you use a database created in 7.2 in 7.3, the function names in the database remain truncated but the function calls - are not, and so they don't match. Also some functions use + are not, and so they don't match. Also some functions use casting commands that no longer work in 7.3 and these functions must be recreated.

To upgrade an OpenACS site from PostGreSQL 7.2 to 7.3, first upgrade the kernel to 4.6.3. Then, dump the database, run the upgrade script /var/lib/aolserver/$OPENACS_SERVICE_NAME/bin/pg_7.2to7.3_upgrade_helper.pl on the dump file, and reply the dump. See Forum OpenACS Q&A: PG 7.2->7.3 upgrade gotcha?. Example:

  1. Back up the database as per PostgreSQL.

  2. Run the upgrade script on the backup file.

    [root root]# su - $OPENACS_SERVICE_NAME
    @@ -62,18 +62,18 @@
               installation location is different, and your startup script
               (/etc/init.d/postgres73 should be named differently. You
               might even need to edit that file to make the paths
    -          correct). You'll also need to add export
    +          correct). You'll also need to add export
               PGPORT=5434 to the .bashrc and/or
               .bash_profile for the postgres73 user.
               

  3. Install PostgreSQL 7.3.x. Note that you PostgreSQL must listen on a different port in order to work - correctly, so you'll need to edit the configuration file + correctly, so you'll need to edit the configuration file (/usr/local/pgsql73/data/postgresql.conf) and change the port (to 5433, say). create a second postgres user to differentiate between the two postgres - installs. When you do ./configure, you'll need to include + installs. When you do ./configure, you'll need to include --prefix=$HOME to ensure that it is installed in the - postgres73 user's home directory.

  4. Change the path in + postgres73 user's home directory.

  5. Change the path in $OPENACS_SERVICE_NAME's .bashrc or .bash_profile (or both) files to reflect the new postgres73 user directory. Also add in the PGPORT.

  6. Restore the database from dump as per the recovery instructions.