How to use my own PostgreSQL instead of the PostgreSQL bundled with Applications Manager ?

How to use my own PostgreSQL instead of the PostgreSQL bundled with Applications Manager ?

Applications Manager comes bundled with PostgreSQL 9.2.4. If you want to use your own PostgreSQL instead, follow the steps mentioned below :

Prerequisites:
  1. A compatible PostgreSQL database (version 9.2.4 or 9.2.x) should be accessible from Applications Manager installation.
  2. A PostgreSQL User with privileges to Login, Create Database, full control over tables in that database.
  3. Backup Applications Manager's backend database (AMDB) and restore it to the new PostgreSQL database if migration is required.
Steps:
  1. Shut down Applications Manager.
  2. Edit AppManager\conf\AMServer.properties file using a text editor (like wordpad or vi or sublime) and make the following changes :
    • Change line 
      am.dbport.check=true

      to 
      am.dbport.check=false

    • Change 
      am.db.port=15432
      to 
      am.db.port=<port of your PostgreSQL>      (ex:  am.db.port=5432)

  3. Edit AppManager\working\conf\database_params.conf file using a text editor and make the following changes :
    • Specify the host and port of your own PostgreSQL. Change line 
      url jdbc:postgresql://localhost:15432/amdb?dontTrackOpenResources=true&useUnicode=true&characterEncoding=UTF-8 AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB
      to
      url jdbc:postgresql://<PostgreSQL Host>:<PostgreSQL Port>/amdb?dontTrackOpenResources=true&useUnicode=true&characterEncoding=UTF-8 AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB
      (ex: jdbc:postgresql://192.168.233.171:5432/amdb?dontTrackOpenResources=true&useUnicode=true&characterEncoding=UTF-8)

    • Specify the username of your own PostgreSQL. Change line 
      username postgres AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB
      to 
      username <PostgreSQL Hostname/Ip> AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB
      (ex: username apm AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB)

    • Specify the password of your own PostgreSQL. Change line 
      encryptedpassword eK6q1CJ9697s7O AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB
      to
      password <PostgreSQL password> AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB
      (ex: password appmanager AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB)

  4. Take a backup of AppManager\working\bin\startPGSQL.bat/.sh file and AppManager\working\bin\stopPGSQL.bat/.sh file and then extract patch from following link : https://uploads.zohocorp.com/Internal_Useruploads/dnd/Applications_Manager/o_1ai05if74q41rbv1scq1virggs1/patch.zip under <AppManager_Home> directory.
  5. Delete files under AppManager\logs directory.
  6. Start Applications Manager.
          • Related Articles

          • Steps to configure Azure PostgreSQL Database as Applications Manager's back-end

            Applications Manager comes bundled with PostgreSQL. If you want to use your own PostgreSQL instead, follow the steps mentioned below: Prerequisites: A compatible PostgreSQL database should be accessible from Applications Manager installation. To know ...
          • Migrating the JRE bundled in Applications Manager

            JRE Upgrade Document for Applications Manager This document helps the end-user in upgrading to the latest version of Java used in Applications Manager. The steps for Java upgrade in both Windows (Service and Non-Service mode) and Linux installations ...
          • Connecting to Applications Manager's bundled database

            How can I connect to Applications Manager's back-end database? Note: Take a backup of the AppManager directory before modifying anything in the database. Check am.dbserver.type value in <Applications Manager Home>\conf\AMServer.properties file to ...
          • Maintenance of Applications Manager

            Applications Manager with MySQL database Open services.msc, stop “ManageEngine Applications Manager” service or via command prompt with administrator permission. If using command prompt, navigate to <Applications Manager Home> directory and execute ...
          • Installing Applications Manager in AWS

            Applications manager can be installed in EC2 instances in both Windows and Linux platforms. Applications Manager comes with bundled PostgreSQL. Installing in EC2 - Windows Go to EC2 console and launch an "Windows" instance with "Atleast 16GB" memory. ...