search cancel

How to change the APM Postgres database connection settings after an install


Article ID: 19728


Updated On:


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


Change APM postgres database connection settings post install


Release: APM 10.x



This document covers the steps to configure the APM database connection after a successful installation.

  1. Solution:

    To configure the connection to an APM Postgres database after installation:

    1. Open the tess-db-cfg.xml file for editing. The file is located in the following directory, depending on your operating system:

      • Windows: <EM_home>\config\

      • UNIX: <EM_home>/rootFiles/config/

    2. For the hibernate.connection.url property, replace the current settings with the database hostname (or IP address), port, and database name.

      • For example: <property name="hibernate.connection.url">jdbc:postgresql://</property>

    3. For the hibernate.connection.username property, specify the database user name.
      This is not the PostgreSQL administrator user name.

    4. For the hibernate.connection.password property, specify the database user password in plain text.

    5. For the plainTextPasswords property, change the setting to true. This allows you to enter the password in plain text. Note that when the Enterprise Manager starts, Introscope sets the plainTextPasswords property back to false and encrypts the password.