Parallels H-Sphere Documentation System Administrator Guide


Upgrading System Postgres


Related Docs:   Backing Up H-Sphere CP Acceleration

Last modified: 27 Dec 2007


WARNING: This documentation covers Parallels H-Sphere versions up to 3.1. For the latest up-to-date Parallels H-Sphere documentation, please proceed to the official Parallels site.

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.

Related Docs:   Backing Up H-Sphere CP Acceleration

© Copyright 2018. Parallels Holdings. All rights reserved.