How to use my own PostgreSQL instead of the PostgreSQL bundled with Applications Manager ?
Applications Manager v17 comes bundled with PostgreSQL 15 and Applications Manager v16 comes bundled with PostgreSQL 11. If you want to use your own PostgreSQL instead, follow the steps mentioned below :
Prerequisites:
- A compatible PostgreSQL database (version 15.x or 11.x based on Applications Manager version) should be accessible from Applications Manager installation.
- A PostgreSQL User with privileges to Login, Create Database, and have full control over tables in that database.
- A Backup Applications Manager's backend database (AMDB) must be restored to the new PostgreSQL database if migration is required.
Steps:
- Shut down Applications Manager.
- 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) - 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 - Take a backup of <AppManager_Home>\working\bin\startPGSQL.bat/.sh file and <AppManager_Home>\working\bin\stopPGSQL.bat/.sh file.
- Delete files under <AppManager_Home>\logs directory.
- Make sure that pg_hba.conf file under data directory of PostgresSQL server has the host of the Applications Manager server listed.
- 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.
- Start Applications Manager.
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 ...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 ...Installing Applications Manager in Cloud (AWS, Azure)
To install Applications Manager in the cloud, we can use any of the below methods: AWS/Azure marketplace Direct installation AWS/Azure marketplace Applications manager is readily available in AWS/Azure marketplace as a pre-installed product. AWS ...