Upgrading PostgreSQL

Note: Although ListManager may use PostgreSQL, Lyris does not support the PostgreSQL database itself. These instructions are provided for the convenience of those using ListManager with PostgreSQL. For complete PostgreSQL documentation, go to http://www.postgres.org.

Upgrading from a Previous Version

The internal data storage format changes with new releases of PostgreSQL. Therefore, if you are upgrading an existing installation that does not have the currently supported version of PostgreSQL you must back up and restore your data.

Instructions on how to upgrade PostgreSQL are available on the Postgres site:

http://www.postgresql.org/docs/8.0/static/install-upgrading.html

Our tests showed upgrading directly from Postgres 7.1 to 8.0.1 caused problems. By upgrading first to 7.3 and then to 8.0, these problems were resolved.