Configuring Azure PostgreSQL database as Applications Manager's backend

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

Prerequisites:

1. A compatible PostgreSQL database should be accessible from Applications Manager installation. To know the supported versions and database user permissions, click here.
2. A PostgreSQL User with privileges to login, create database, and has full control over the tables in that database.

Steps:

1. Install Applications Manager with bundled PostgreSQL backend. It is recommended that you do not launch the application during the installation setup after choosing bundled Postgres as the backend. This avoids creating APM-related tables in the bundled PostgreSQL database.
2. Create an Azure PostgreSQL database in the Azure portal.

   Note: Make sure that the DB port 5432 is open to ensure that proper connection to the database can be made from Applications Manager server.

3. Get the following information from the database to connect to it:
   • Azure PostgreSQL Database Server name [Hostname]
   • Database port number
   • Database admin username
   • Database password
4. Connect to the server in which Applications Manager is installed and modify the below files to change the database configuration settings from bundled PostgreSQL to Azure PostgreSQL database.
   
   
   • Edit AppManager\conf\AMServer.properties file using a text editor (like wordpad or vi or sublime) and make the following changes:
     • Replace am.dbport.check=true with am.dbport.check=false
     • Replace am.db.port=15432 with am.db.port=<PostgreSQL port> (Example: am.db.port=5432)
   • Modify AppManager/working/conf/database_params.conf file:
     • Change the host and port details:

       Replace localhost:5432 with AzurePGSQLServer:<port number>

       From this:
       url jdbc:postgresql://localhost:5432/amdb?dontTrackOpenResources=true&useUnicode=true&characterEncoding=UTF-8
       
       It should now look like this:
       url jdbc:postgresql://AzurePgSQLServer:Port/amdb?dontTrackOpenResources=true&useUnicode=true&characterEncoding=UTF-8

        

     • Change the database username:

       Replace the default username <username> with <username@host>, where username and host is the username and hostname of the Azure PostgreSQL server respectively.

       From this:
       username postgres AppModules
       
       It should now look like this:
       username azurepgsqlUserName@AzurePgSQLServerName AppModules

        

     • Change the database password:

       Replace the keyword encryptedpassword with password <Azure PostgreSQL Password>

       From this:
       encryptedpassword appmanager
       
       It should now look like this:
       password azurepgsqlPassword

        

     • Once you implement the above changes, save the file. Then, copy and replace the file in the following directory: AppManager/working/conf/database_params.conf
5. Delete files under <Applications Manager 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.