There was a problem loading the comments.

Release Notes - PostgreSQL 8.2.3 and 8.3.0

Support Portal  »  Knowledgebase  »  Viewing Article

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
PostgreSQL 8.2.3 and 8.3.0 have significant performance improvements, transaction optimizations, and new requested features. For a list of changes, go to the following link:

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 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 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 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

Share via
Did you find this article useful?  

Related Articles

On-Premise Help Desk Software by SupportPal


© Cloudscale365