Patches & Updates PostgreSQL 7.4.7 Upgrade



28 Feb 2005

H-Sphere versions: 2.4.1 Patch 2 and higher

We recommend upgrading your PostgreSQL user database servers and the system PostgreSQL to version 7.4.7 for better performance on the Control Panel server.

This script includes PostgreSQL Security Release for 7.4.7 and updates Postgres server and client software, including:
- perl client library on all boxes (install if missing)
- server software with data conversion to the current version format
- FreeBSD eliminated PL/PgSQL parser vulnerability to buffer overflows. This update for FreeBSD included on the 4th of March, 2005.
 Note: If you have updated Postgres to 7.4.7 before March 4, you can update Postgres for FreeBSD.

System Requirements:

- H-Sphere 2.4.1 Patch 2 and higher. With H-Sphere older than 2.4.1 Patch 2, Postgres update can stop H-Sphere work.
- If your Postgres is older than v.7.2, manual update is highly recommended
- Before upgrading Postgres, make sure your hsphere database is converted to UNICODE.

Update Process Description:

First, the update stops the Control Panel and updates Postgres server.
Next, it restarts Control Panel with the new Postgres version.
Note: If the script runs into an error on a user database server, it returns a respective message, skips the box and turns to the next box. It's described in details in the recover-howto-eng.txt file

Update Procedure:

  1. Log into your control panel server as root:
    su -
  2. Download the PostgreSQL 7.4.7 upgrade script from the psoft site:
    For Linux:
    wget http://www.psoft.net/shiv/HS/u-pgsql-7.4.7.tar.gz
    For FreeBSD:
    fetch http://www.psoft.net/shiv/HS/u-pgsql-7.4.7.tar.gz
  3. Unpack the archive:
    tar -zxf u-pgsql-7.4.7.tar.gz
  4. Enter the unpacked directory:
    cd u-pgsql-7.4.7
  5. To upgrade all PostgreSQL servers, run the update.sh script:
    sh update.sh

    To run the script and view the messages that appeared during installation, run the following command:

    sh update.sh | tee update.log
    It will copy the messages to the log file.



Copyright 1998-2008. Positive Software Corporation.
All rights reserved.