Note: This web site is only kept up to date for OSG Software 1.2 (VDT 2.0.0). If you are looking for information for the most recent release, the RPM-based OSG Software 3.0, please see the OSG documentation web site

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