01 Mar 2006

H-Sphere versions: All

We recommend upgrading PostgreSQL server to 7.4.16 and fix Security hole.

System Requirements:

- H-Sphere 2.4.1 Patch 2 and higher. If you are running an earlier version of H-Sphere, this patch will break your installation.
- If your Postgres is older than v.7.3 or system DB encoding is other than UTF-8, manual update is highly recommended.

Update procedure:

• for HS 2.4.3 +
• for HS 2.5 +
• for HS 3.0 +

Procedure:

1. Log into your control panel server as root:
   
   su -
2. Download the PostgreSQL 7.4.16 upgrade script from the psoft site:
   For Linux:
   wget http://www.psoft.net/shiv/HS/u-pgsql-7.4.16.tar.gz
   For FreeBSD:
   fetch http://www.psoft.net/shiv/HS/u-pgsql-7.4.16.tar.gz
3. Unpack the archive:
   
   tar xfz u-pgsql-7.4.16.tar.gz
4. Enter the unpacked directory:
   
   cd u-pgsql-7.4.16
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.

Procedure:

1. Run HS updater for H-Sphere 2.5
   sh U25.0P9
2. Execute updater command:
   
   hspackages postgres

Procedure:

1. Run HS updater for the latest version of H-Sphere 3.0.0 from the directory the updater is located.
   sh U30.0RC4
   or
   sh U30.0P2SSE
2. To update the packages to the latest version, execute:
   hspackages postgres