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 11. If you want to use your own PostgreSQL instead, follow the steps mentioned below :

Prerequisites:
  1. A compatible PostgreSQL database (version 11.x) should be accessible from Applications Manager installation.
  2. A PostgreSQL User with privileges to Login, Create Database, and have full control over tables in that database.
  3. A Backup Applications Manager's backend database (AMDB) must be restored to the new PostgreSQL database if migration is required.
Steps:
  1. Shut down Applications Manager.
  2. Edit <AppManager_Home>\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_Home>\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

      Example:
      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 Username> AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB

      Example:
      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

      Example:
      password appmanager AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB

  4. Take a backup of <AppManager_Home>\working\bin\startPGSQL.bat/.sh file and <AppManager_Home>\working\bin\stopPGSQL.bat/.sh file.
  5. Delete files under <AppManager_Home>\logs directory.
  6. Make sure that pg_hba.conf file under data directory of PostgresSQL server has the host of the Applications Manager server listed.
  7. Check if the IP address of the Applications Manager server is included in "listen_addresses" in postgresql.conf file under data directory of PostgresSQL server.  
  8. Start Applications Manager.

                New to ADManager Plus?

                  New to ADSelfService Plus?

                    • 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 ...
                    • Connecting to Applications Manager's bundled database

                      Before you connect to Applications Manager's back-end database, it is important that you take a backup of the Applications Manager directory so that you don't make any changes/accidentally modify the database. Identify which database Applications ...
                    • 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 ...
                    • Applications Manager default tomcat is down

                      If your Tomcat Monitor is down, it could probably be due to changes in Hostname/IP address of the machine in which Applications Manager is installed. You can verify the same using the steps given below: Navigate to ...
                    • 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 Applications Manager in EC2 for Windows Go to EC2 console and launch an "Windows" instance ...