Change default Postgres Database Password

To change the default Postgres password in ServiceDesk Plus MSP,

Shut down ManageEngine ServiceDesk Plus MSP.

Take a backup of the application [OR] snapshot of the server.

Execute the steps given below:

Please note the following characters are not allowed in the database password: & ) !

For Windows:

Open command prompt with admin privileges. Go to [Product-Home]\bin directory and execute the command

stopDB.bat

Then execute the command

changeDBPassword.bat -p <old password> -P <new password>

The following message is displayed:

Finally, execute the following command to start the application services

startDB.bat

Go to [Product-Home]/bin and execute the command

sh stopDB.sh

Then execute the following command

sh changeDBPassword.sh -p <old password> -P <new password>

Finally, execute the following command to start the application services

sh startDB.sh

You have now successfully changed the default Postgres password. Start the application to access the helpdesk.