Release Notes - PostgreSQL
- 30/08/2010 8:08 PM
This document will provide PostgreSQL release notes for all operating systems offered by eApps. Please see the section specific to the operating system of your subscription. To get the operating system of your subscription take the steps below.
Log into your Control Panel > click My Account tab > Subscriptions > click the Name of the subscription (with type Virtuozzo Container)> the operating system is listed on the Server section of the page.
CentOS 5
The latest version available on CentOS 5 plans is 8.4.4
Changes in 8.4.4
eApps Release Notes
- None
Official Release Notes
How to upgrade
A dump is required if you wish to migrate data from 8.4.x. If you are upgrading from 8.4.x follow the instructions on step 2.
1. Create a dump of you existing date with the command below.
pg_dumpall > backup.sql
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. See http://www.postgresql.org/docs/8.4/static/backup-dump.html for details.
2. Log into your control panel and uninstall PostgreSQL.
3. From the command line move the old PostgreSQL data directory
cd /var/lib
mv pgsql pgsql.old
4. Install PostgreSQL from your control panel.
5. Import your databases back into the new version.
/user/bin/psql -d template1 backup.sq
A dump is required if you wish to migrate data from 8.4.x. If you are upgrading from 8.4.x follow the instructions on step 2.
1. Create a dump of you existing date with the command below.
pg_dumpall > backup.sql
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. See http://www.postgresql.org/docs/8.4/static/backup-dump.html for details.
2. Log into your control panel and uninstall PostgreSQL.
3. From the command line move the old PostgreSQL data directory
cd /var/lib
mv pgsql pgsql.old
4. Install PostgreSQL from your control panel.
5. Import your databases back into the new version.
/user/bin/psql -d template1 backup.sq