How to update ADManager Plus' built-in PostgreSQL database

Steps to update your ADManager Plus instance's PostgreSQL database

1. Stop ADManager Plus by navigating to Start > ADManager Plus > Stop ADManager Plus.
   Note: If you have installed ADManager Plus as a Microsoft Windows service, stop the service by navigating to Start > Run > services.msc > ManageEngine ADManager Plus > Stop.
2. Navigate to <Installation Directory>\ADManager Plus\bin and execute the backupDB.bat file to back up the database of your current installation. This will create a folder called Backup inside ADManager Plus' installation folder (<Installation Directory>\ADManager Plus\Backup). The Backup folder will contain your database backup file (e.g., OfflineBackup_20161129235853.ezip).
   Note:

   • You can also do this by running Command Prompt as an administrator, navigating to <Installation Directory>\ADManager Plus\bin, and executing the backupDB.bat file.
   • ADManager Plus uses a CryptTag value as its default database backup file password for enhanced protection, and this can be found in the customer-config.xml file.
3. Make a copy of the following folders and files:
   • The Archive, ES, and esdata folders from the installation folder of your existing ADManager Plus instance (<Installation Directory>\ADManager Plus)
   • The customer-config.xml file of your existing ADManager Plus instance from the <Installation Directory>\ADManager Plus\conf folder
4. If you are going to install your new ADManager Plus instance on the same server,
   • Navigate to the InstallShield Installation Information folder (C:\Program Files (x86)\InstallShield Installation Information) and rename the CC00BC3F-40AE-49A7-BA63-FE2F93D20585 folder to CC00BC3F-40AE-49A7-BA63-FE2F93D20585_bak.
     Note: The InstallShield Installation Information folder is a hidden folder and can be viewed by clicking the View tab in File Explorer and checking Hidden items.
   • Locate and rename the existing installation folder.
     e.g., If you've installed ADManager Plus in the default location, navigate to (C:\Program Files\ManageEngine) and rename the ADManager Plus folder to ADManager Plus_old.
5. Now, download and install the same build of your ADManager Plus from here.
    
   • Steps to download the build
   • Enter your current build number, click Download, and follow the provided steps.
   •  
   • Please contact our support team or fill this form for our support team's assistance in upgrading to the latest build number 7184
   Do not start the product after installation. This can be done by unchecking the Start ADManager Plus in console mode option in the setup window.

   

6. Paste the copied Archive, ES, and esdata folders in the installation folder of your new ADManager Plus instance (<Installation Directory>\ADManager Plus).
7. Locate and replace the new customer-config.xml file with the copied customer-config.xml file from step 3.
8. Obtain the database backup file of your old instance and paste it in the bin folder (<Installation Directory>\ADManager Plus\bin) of your new ADManager Plus instance.
9. Restore the database backup by running Command Prompt as an administrator, navigating to <Installation Directory>\ADManager Plus\bin and executing the batch file, restoreDB.bat, in the following format:

   restoreDB.bat backupFileName -p
   (e.g., restoreDB.bat OfflineBackup_20230215191814.ezip -p)

   Note:

   • When you are prompted for a password, copy and paste the CryptTag value from the customer-config.xml file of your old instance. The CryptTag value is the default database password and is used only when a password is not specified in the Security and Privacy settings of ADManager Plus.

   

10. Now start the product.
11. Apply the original license file sent to your email from licensing@manageengine.com. You can also obtain the license file, AdventNetLicense.xml from the License folder present in <Installation Directory>\ADManager Plus\lib of your old instance.

Steps to check your PostgreSQL database's version

• For ADManager Plus build 7150 and above:
  1. Log in to ADManager Plus and navigate to Support.
  2. Under Upload Logs, click More.
  3. Under Product Information, find the Database type.
• For ADManager Plus builds below 7150:
  1. Navigate to <Installation Directory>\ADManager Plus\pgsql\bin.
  2. Execute the following command:
     psql.exe -V