How to update ADManager Plus' built-in PostgreSQL database
Prerequisite:
- Before updating your PostgreSQL database, update your ADManager Plus instance to the latest build by following the service pack installation steps. The service pack's version must be same as that of the new build that you will be installing on your server.
Steps to update your ADManager Plus instance's PostgreSQL database
- Stop ADManager Plus by navigating to Start > All Programs > 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.
- 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), which 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.
- Make a copy of the following folders and files:
- Archive, ES, and esdata folders from the installation folder of your existing ADManager Plus instance (<Installation Directory>\ADManager Plus).
- Customer-config.xml file of your existing ADManager Plus instance from the <Installation Directory>\ADManager Plus\conf folder.
- 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.
- Now, download and install the latest build of ADManager Plus from here. 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.

- Paste the copied Archive, ES, and esdata folders in the installation folder of your new ADManager Plus instance (<Installation Directory>\ADManager Plus).
- Locate and replace the new customer-config.xml file with the copied customer-config.xml file from step 3.
- Obtain the backup file of your old instance and paste it in the bin folder (<Installation Directory>\ADManager Plus\bin) of your new ADManager Plus instance.
- 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)
- 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.

- Now start the product.
Steps to check your PostgreSQL database's version
- If you are running ADManager Plus build 7150 and above:
- Log in to ADManager Plus and navigate to Support.
- Under Upload Logs, click More.
- Under Product Information, find the Database type.
- If you're running other ADManager Plus build versions:
- Navigate to <Installation Directory>\ADManager Plus\pgsql\bin.
- Execute the following command:
psql.exe -V
New to ADSelfService Plus?
Resources
Related Articles
ADManager Plus Best Practices
Best practices, 1.Please make sure that scheduled reports are configured in a proper time interval of atleast 5 minutes between each schedule. 2.Please check the list of scheduled reports and remove the unnecessary scheduled reports.(Login as the ...
How to schedule custom reports in ADManager Plus
ADManager Plus' built-in reports library includes over 200 reports that allow you to fetch crucial information about Active Directory, Microsoft 365, Exchange Server, Google Workspace, and more. It also offers a custom report builder,allowing you to ...
How to migrate ADManager Plus from 32-bit to 64-bit in the same server
To migrate ADManager Plus from the 32-bit version to the 64-bit version, you need to take a backup of the product, install the 64-bit version of ADManager Plus, and then restore the backup to this new instance. Note: Upgrade the current instance ...
How to delegate roles to groups in ADManager Plus
Steps to add roles to groups in ADManager Plus: Login to ADManager Plus. Go to the Delegation tab. In the left pane, choose Help Desk Technicians under Help Desk Delegation. Choose your domain from the Select Domain drop-down. Click on the + option ...
How to disable the "Logon on to" option in ADManager Plus's login Page
This KB will explain how you can disable ADManager Plus's "Logon on to" option in the product's login page so that the technicians can login with domain/sAMAccoutnName or UPN. Navigate to Admin tab > General Settings > Server Settings > Logon ...