Article ID: 3244, created on Nov 30, 2007, last review on Apr 18, 2012

  • Applies to:
  • H-Sphere


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. More...

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


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:
    For FreeBSD:
  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 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.

f213b9fa8759d57bee5d547445806fe7 6311ae17c1ee52b36e68aaf4ad066387

Email subscription for changes to this article
Save as PDF