Release Notes - PostgreSQL 8.0.3
- 11/08/2005 4:46 PM
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.
1. Export your data from your existing database using the following command (or use phpPgAdmin)
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.
3. Install the PostgreSQL package from the System tab, All Applications area of your Control Panel.
4. Restore your data into the new PostgreSQL 8.0.3 database using the following command (or use phpPgAdmin)
/usr/bin/psql -d template1 -f outputfile