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

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.