Objective   

Prerequisites   

• Administrative privileges: Administrative access to the ADSelfService Plus application server and both current and new PGSQL servers.
• PostgreSQL version: The new PostgreSQL server must be running a compatible version (version 12, 13, 14 or 15). Using a significantly different version might lead to compatibility issues.
• Backup: A complete backup of the ADSelfService Plus installation directory.
• Network connectivity: The new PGSQL server must have the same firewall exceptions as the old server to ensure uninterrupted communication with the ADSelfService Plus server.
• Permissions: Database owner privileges to perform backup and restore operations on both PostgreSQL servers, and administrative privileges to execute commands on the ADSelfService Plus application server.
• Database credentials: The necessary credentials (hostname, port, database name, username, and password) for the new PostgreSQL database.

Steps to follow   

1. On the old PostgreSQL server, create a full backup of the ADSelfService Plus database using backup tools or with the help of your database administrator.

1. On the new server, restore the backup using PostgreSQL restoration tools or with the assistance of your database administrator.

Note: The master key can only be retrieved from the application server by the support team. If you are prompted to provide a master key, please contact support@adselfserviceplus.com for assistance. 

1. If ADSelfService Plus is running as a service, stop it via Services.msc.
2. If ADSelfService Plus is running as an application, exit it from the system tray.

1. Press the Windows key or click the Start button.
2. Type cmd or Command Prompt.
3. Right-click Command Prompt and choose Run as Administrator.
   
4. Navigate to the ADSelfService Plus bin directory. By default, this is located in C:\Program Files\ManageEngine\ADSelfService Plus\bin.
5. Execute the database change script changeDB.bat. This script will launch the Database Configuration Wizard.
6. In the Database Configuration Wizard, select Pgsql Server from the Server Type dropdown (default option).
7. Provide the connection details for your new PostgreSQL server.
   

• Host Name: The hostname or IP address of the new PostgreSQL server.
• Port: The port number used by the new PostgreSQL server (e.g., 5432).
• Database Name: The name of the database that ADSelfService Plus will use on the new server.
• User Name: The username used to connect ADSelfService Plus to the database.
• Password: The password for the specified database user.

6. Click Test to verify the connection with the new server details. If the connection fails, recheck your credentials and network connectivity, then try again.
7. Once the connection test is successful, click Save.

1. Press Win + R to open the Run dialog box.
2. Type services.msc and press Enter.
3. In the Services list, find ManageEngine ADSelfService Plus.
4. Right-click the service and select Start.

Validation and confirmation   

1. Application launch: Ensure the ADSelfService Plus application starts successfully without any database connection errors.
2. Data verification:

• Log in to the ADSelfService Plus portal.
• Verify data consistency by checking reports and the dashboard.

3. Functionality test:

• Perform a few common user self-service operations (e.g., password reset, account unlock).
• Test administrator functionalities (e.g., managing policies).

4. Log files check: Review the ADSelfService Plus server logs located in <ADSelfService Plus_Installation_Dir>\logs for any database connectivity issues or errors related to the migration.

How to reach support