Upgrading to PostgreSQL 7.4.x

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 a version number "7.4.x", 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/7.4/static/install-upgrading.html

Alternatively, you may find these instructions helpful. Our tests showed upgrading directly from Postgres 7.1 to 7.4 caused problems. By upgrading first to 7.3 and then to 7.4, these problems were resolved.

1. Download PostgreSQL 7.3.

2. Dump the database from the 71x version of Postgres. Substitute your database name for "DBNAME".

pg_dump DBNAME > lm71x.dmp

3. Shut down Postgres.

4. Move the old Postgres 71x installation to a new directory.

mv pgsql pgsql_71x

4. Install Postgres 7.3 to a different directory.

5. Create a new database in your new Postgres installation:

createdb -Ulmpg DBNAME

6. Load the database dump you created:

psql DBNAME < lm71x.dmp

7. Immediately dump the database. Some changes will have been made and the file size will be larger.

pg_dump DBNAME > lm73x.dmp

8. Download Postgres 7.4.

9. Install Postgres 7.4 to a different directory.

10. Create a new database in your new Postgres installation:

createdb -Ulmpg DBNAME

11. Load the database dump you created:

psql DBNAME < lm71x.dmp

12. Follow the instructions for upgrading ListManager with Postgres 74x.