Do this if your reporting database is running on a separate port

It is assumed that your reporting database runs on port 5632 and the same port number is used in commands hereinafter in this topic. You can substitute the right port number if you have your reporting database running on a different port.

1. Upgrade your PostgreSQL reports data directory to PostgreSQL 9.3.
   • cd /opt/collabnet/pgturant/bin/
   • ./pgturant -s /var/lib/pgsql/9.2/reports -d /var/lib/pgsql/9.3 -u 9.3 -m
2. Open the analyze_new_cluster.sh file.
   • vim /var/lib/pgsql/9.3/analyze_new_cluster.sh
3. Find and replace all.
   • Find all occurrences of this: /usr/pgsql-9.3/bin/vacuumdb" --all --analyze-only
   • Replace with: /usr/pgsql-9.3/bin/vacuumdb" -p 5632 --all --analyze-only
4. Create a new postgresql-9.3_reports file.
   • cp /etc/init.d/postgresql-9.3 /etc/init.d/postgresql-9.3_reports
5. Open the newly created postgresql-9.3_reports file.
   • vim /etc/init.d/postgresql-9.3_reports
6. Modify the PGPORT, PGDATA and PGLOG values in the postgresql-9.3_reports file as follows.
   • PGPORT=5632
   • PGDATA=/var/lib/pgsql/${PGMAJORVERSION}/reports
   • PGLOG=/var/lib/pgsql/${PGMAJORVERSION}/pgstartup_reports.log
7. Start postgresql-9.3_reports.
   • /etc/init.d/postgresql-9.3_reports start
8. Run the ananlyze_new_cluster.sh script.
   • su - postgres -c "/var/lib/pgsql/9.3/analyze_new_cluster.sh"
9. Stop postgresql-9.3_reports.
   • /etc/init.d/postgresql-9.3_reports stop
10. Go back and continue with the other upgrade steps.