Patches & Updates PostgreSQL 7.4.12 Upgrade

05 May 2006

H-Sphere versions: All

We recommend upgrading your PostgreSQL user database servers and the system PostgreSQL to eliminate vulnerabilities reported in PostgreSQL.

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:


To update Postgres to 7.4.12

  1. Log into your control panel server as root:
    su -
  2. Download the PostgreSQL 7.4.12 upgrade script from the psoft site:
    For Linux:
    For FreeBSD:
  3. Unpack the archive:
    tar xfz u-pgsql-7.4.12.tar.gz
  4. Enter the unpacked directory:
    cd u-pgsql-7.4.12
  5. To upgrade all PostgreSQL servers, run the script:

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

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


To update Postgres to 7.4.12:

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

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