Upgrading HSphere System Postgres

This document expalins how to update your system and user PostgreSQL from version 7.3.x to version 7.4.7 which is faster, uses server memory more effectively, and includes security fixes.

Important:
If your PosgtreSQL version is lower than 7.3, please upgrade it to v. 7.3 first.

 
To check your PostgreSQL version:
  1. Log into your control panel server as root:
    su -
  2. Execute:
    psql --version

 

Update Features

  • PostgreSQL Security Release for 7.4.7
  • Postgres server and client software updates, 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. (included on the 4th of March, 2005)

Requirements

  • H-Sphere 2.4.1 Patch 2 and higher.
  • Current PostgreSQL updated to version 7.3.
  • hsphere database converted to UNICODE.

Update Process

    The update:
  1. stops the Control Panel
  2. updates Postgres server
  3. restarts Control Panel with the new Postgres version.
    Note: If the script runs into an error on a user database server, you are notified of it, the script skips the box and turns to the next one. When you are through with the update, see recover-howto-eng.txt file to lean how to recover the box that hasn't got updated. When you fix the error, you'll need to update this box manually.

Update Procedure:

IMPORTANT: You are highly recommended to backup your databases into a directory other than Postgres home directory so you don't lose data if anything goes wrong.

  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.

 

Cartika Information

Customer Resources