Upgrading APM from 10.52 to 10.7

Products

• CA Application Performance Management Agent (APM / Wily / Introscope)
• CA Application Performance Management (APM / Wily / Introscope)
• INTROSCOPE
• DX Application Performance Management

Issue/Introduction

We are in the process of upgrading from APM 10.5 to 10.7.

During the process it indicates that our PostgreSQL version is required to be upgraded from 9.2 to 9.6.2. However, in APM database step when selecting option “2- Upgrade database scheme or create a new database schema” and providing the currently existing Postgres installation folder, we are presented with an error. See below:

  2- Upgrade database schema or create new database schema

===============================================================================
Enter upgraded PostgreSQL Install Directory
-------------------------------------------

Enter the folder to install PostgreSQL-9.6.2. The data directory will be 
created within this folder.

Enter PostgreSQL9.6.2 directory (Default: /opt/PostgreSQL-9.6.2): /disk/apps/postgres

===============================================================================
Check PostgresSQL Install Directory
-----------------------------------

The directory /disk/apps/postgres already exists.

PRESS <ENTER> TO ACCEPT THE FOLLOWING (OK): 

===============================================================================
Enter upgraded PostgreSQL Install Directory
-------------------------------------------

Enter the folder to install PostgreSQL-9.6.2. The data directory will be 
created within this folder.

Enter PostgreSQL9.6.2 directory (Default: /opt/PostgreSQL-9.6.2): /disk/apps/postgres
===============================================================================

The question is whether it is possible to upgrade the existing installation of PostgreSQL without losing existing data, and if the installer would preserve the data if we were to specify a new folder?

Would a manual upgrade of PostgreSQL therefore be the only option?

When selecting option 3, it gives a warning that there is an incorrect PostgreSQL version, but allows completing the install stating that we may modify the settings post-install. Is this also an option if we wanted to upgrade PostgreSQL after the install?

Cause

Customer installed 10.5 and then moved the database directory to another location and placed a symbolic link pointing to it.  This confused the upgrade and the upgrade of the DB failed.

Environment

Release : 10.7.0

Component : APM Agents

Resolution

New installer fix to follow the symbolic link.  

Additional Information

Upgrading a PostgreSQL Cluster - Postgres

 

Upgrade the PostgreSQL Database - APM