Hi all,
I have a customer who wants to upgrade an old 9.0.0.0 APM database to the latest release 10.1.0.15.
Unfortunately he is having many issues there, because during the upgrade of EM and postgres (8.3.12 to 9.2.9), plenty of errors showed up in the em.log and other logs.
1. Create backup (logged in as DB superuser wily):
~> pg_dump -h $DBHOST -p $DBPORT apmdb > apmdb.sql
3. Rename the superuser 'postgres' to 'wily'
4. Drop DB apmdb
postgres=# DROP DATABASE apmdb;
5. Create and empty DB apmdb with owner apmdbadm.
postgres=# CREATE DATABASE apmdb OWNER apmdbadm;
6.
7. Restore database
~> psql -h $DBPHOST -p $DBPORT apmdb < apmdb.sql
8. upgrade EM
We are considering to discard the old database and start with a new one from scratch, because they are not using CEM.
But my only question is, can the Team Center draw any data from a historical APM database at all?
Does customer benefit from restoring an older DB assuming they are not using CEM?
Thanks and regards,
Mikel.