eApps now offers PostgreSQL version 8.2.3 on Centos 4 plans and 8.3.0 on CentOS 5 plans. This is a major upgrade to the application. Earlier versions of PostgreSQL will continue to be supported. Customers should upgrade to this version at their own discretion.
List of Changes
http://www.postgresql.org/docs/8.3/static/release-8-3-1.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.2.3 or 8.3.0 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. As user "postgres", 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.2/interactive/install-upgrading.html 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. Rename /var/lib/pgsql/data as /var/lib/pgsql/data-old (or similar). Remember to delete this directory later after you are sure that your postgresql update has been successful.
4. Install the PostgreSQL package from the System tab, All Applications area of your Control Panel.
5. As user "postgres" restore your data into the new PostgreSQL 8.2.3 or 8.3.0 database using the following command (or use phpPgAdmin)
/usr/bin/psql -d template1 -f outputfile
