PostgreSQL 7.4.7 → 8.2.1 Upgrade Notes

Dumping the RT Database

1. Change to a disk volume with adequate free space (~25 MB as of 2007-03-16)
2. Dump the RT database (pg_dump docs)

   /s/postgresql-7.4.7/bin/pg_dump -v -h dumbo.cs.wisc.edu -p 49173 -Fc vdt_tickets > DUMP-FILE-NAME

3. Read the stderr carefully for warnings and errors

Restoring the RT Database into the Test Database Instance

1. Change to the directory containing the RT database dump
2. If needed, create the vdt_rt user (createuser docs)

   /s/postgresql-7.4.7/bin/createuser -h localhost -U root -DA vdt_rt

3. If needed, create the new database (createdb docs)

   /s/postgresql-7.4.7/bin/createdb -h localhost -U nmueller vdt_tickets

4. Restore the RT database (pg_restore docs)

   /s/postgresql-7.4.7/bin/pg_restore -h localhost -U nmueller -d vdt_tickets -O -x DUMP-FILE-NAME

5. Read the stderr carefully for warnings and errors