PostgreSQL 7.4.7 Upgrade

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.

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. Unpack the archive:
    tar -zxf u-pgsql-7.4.7.tar.gz
  3. Enter the unpacked directory:
    cd u-pgsql-7.4.7
  4. 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.


Home   Products   Services   News  
© Copyright. . PSOFT. All Rights Reserved. Terms | Site Map