Upgrading 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

This update includes the following:

• PostgreSQL Security Release for 7.4.7, http://www.postgresql.org/about/news.281
• 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 (http://www.freebsd.org/ports/portaudit/6b4b0b3f-8127-11d9-a9e7-0001020eed82.html).

Make sure that your system satisfies the following requirements:

• Current PostgreSQL updated to version 7.3.
• hsphere database converted to UNICODE.

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

To upgrade system Postgres:

1. Log into your control panel server as root:

   su -

2. Download the PostgreSQL 7.4.7 upgrade script from the downloads site:

   For Linux:

   wget http://download.hsphere.parallels.com/shiv/HS/u-pgsql-7.4.7.tar.gz

   For FreeBSD:

   fetch http://download.hsphere.parallels.com/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.

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.