Applying HOTFIX on a separate Postgres database server

book

Article ID: 208889

calendar_today

Updated On:

Products

CA Application Performance Management (APM / Wily / Introscope)

Issue/Introduction

We are applying hotfix APM10.7.0 HF77 in our APM environment. We have a question about the hotfix. When we applied the hotfix on our separate Postgres database server, it does not seem as though anything was done to that Postgres Server. We ran it from two different paths as we were not sure about the path we should use (/opt/Introscope10.7.0.45 and /opt/Introscope10.7.0.45/install/database-install/linux).

How can we determined the hotfix is applied successfully on a separate Postgres database server?

Environment

Release : 10.7.0

Component : Introscope

Resolution

You can determined the postgres install path or home path with following commands.

ps -ef | grep postgres
example output: 
postgres ..... /opt/PostgreSQL-9.6.2/bin/postgres -D /opt/PostgreSQL-9.6.2/data

su - postgres
env
exit
example output: 
HOME=/opt/PostgreSQL-9.6.2

su postgres
env
exit
example output: 
HOME=/opt/PostgreSQL-9.6.2

This is the install path or home path for postgres in the above example.

/opt/PostgreSQL-9.6.2

So, we need to move the HOTFIX APM10.7.0HF77.jar file at /opt/PostgreSQL-9.6.2, and apply it from there.

Here is a sample output that does indicate that HOTFIX is installed good.

Checking if PostgreSQL has been installed as a standalone component
Searching for PostgreSQL installation at /opt/PostgreSQL-9.6.2
PostgreSQL found - proceeding with patching
-------------------------------------------
creating directory /opt/PostgreSQL-9.6.2/hotfix/10.7.0-HF77/Database
########################################################################
Hotfix 10.7.0-HF77 was applied successfully

It is not always necessary that there are new files gets installed. There may be other adjustments (like permissions on existing files or modification of existing files etc.).