Patches & Updates PostgreSQL 7.3.4 Upgrade



26 Nov 2003

We recommend upgrading your PostgreSQL user database servers to version 7.3.4 for better performance.

Prior to the upgrade, you should upgrade OpenSSL on your servers to the latest version if you haven't done that before.
OpenSSL 0.9.7c upgrade instructions

NOTE:
The upgrade is made only for PostgreSQL user database servers! It WILL NOT upgrade the system PostgreSQL on the Control Panel server!
  1. Log into your control panel server as root:
    su -
  2. Download the PostgreSQL 7.3 upgrade script from the psoft site:
    RedHat:
    wget http://www.psoft.net/shiv/u-pgsql.tgz
    FreeBSD:
    fetch http://www.psoft.net/shiv/u-pgsql.tgz
    Note: The script upgrades only PostgreSQL 7.1!
  3. Unpack the archive:
    tar -zxf u-pgsql.tgz
  4. Enter the unpacked directory:
    cd u-pgsql
  5. To upgrade all PostgreSQL user database servers, run the update.sh script:
    sh update.sh
    and you're done.
    Alternatively, to upgrade PostgreSQL only on a particular box, copy the pgupdt.tgz archive from the u-pgsql to that server, untar that archive, and run sh pgupdate.sh in the untarred pgupdate directory.


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