eApps now offers PostgreSQL version 8.0.3. This is a major upgrade to the application. PostgreSQL 7.3.4 will continue to be supported. Customers should upgrade to this version at their own discretion.
LIST OF CHANGES: PostgreSQL 8.0.3 has significant improvements in transaction recovery, file system performance, processing performance, and includes new features. For a list of changes, go to the following link:
http://www.postgresql.org/docs/8.0/static/release-8-0-3.html
UPGRADING: The upgrade of PostgreSQL requires that you export and then import your database. To be safe, make a backup of your databases before upgrading to ensure that your data is secure in the event of a mishap in the upgrade process. Please follow the Upgrade Procedures at http://support.eapps.com/hsp/upgrades. To upgrade to PostgreSQL 8.0.3 from an older version you will need to perform the following steps. Please note that you should always refer to the authoritative documentation on the http://www.postgresql.org web site for complete and up to date information on how to install and use the PostgreSQL software. The following steps are a guideline.
pg_dumpall > outputfile
If you need to preserve OIDs (such as when using them as foreign keys), then use the -o option when running pg_dumpall. pg_dumpall does not save large objects. Check http://www.postgresql.org/docs/8.0/static/backup.html#BACKUP-DUMP-CAVEATS if you need to do this.
2. un-install your current version of PostgreSQL from the System tab, All Applications area of your Control Panel.
/usr/bin/psql -d template1 -f outputfile