Lynn_Williams

CA Tuesday Tips: APM 9.6 - APM Database upgrade

Discussion created by Lynn_Williams Employee on Aug 7, 2014
Latest reply on Aug 11, 2014 by MaryGreening

Key points for the upgrade of an existing PostgreSQL or Oracle APM Database in APM 9.6


PostgreSQL

  • APM 9.6 installs a new version of PostgreSQL (9.2) so an upgrade in-place of the database is not possible.
  • The current database first needs to be backed up with the existing PostgreSQL software.
  • After PostgreSQL 9.2 is installed the database can be restored to the new version (the restore process automatically runs the schema upgrade step)


Oracle

  • An APM Oracle database can be upgraded in-place.


For further details please see the "Upgrade APM -> How to Upgrade the APM Database" section of the APM 9.6 Installation and Upgrade Guide:

https://support.ca.com/cadocs/0/CA%20Application%20Performance%20Management%209%206-ENU/Bookshelf_Files/HTML/APM--Installation%20and%20Upgrade%20Guide/2233401.html

Outcomes