Change default Postgres Database Password

To change the default Postgres password in ServiceDesk Plus,

  1. Shut down ManageEngine ServiceDesk Plus. Open the command prompt with admin privileges and execute the command shutdown.bat. Alternatively, you can stop the application by navigating to services.msc.

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

  3. Execute the steps given below:

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

For Windows:

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

stopDB.bat 

  1. Then execute the command

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

  1. The following message is displayed:

  1. Finally, execute the following command to start the application services:

startDB.bat 

For Linux:

  1. Go to [SDP-Home]/bin and execute the command

sh stopDB.sh 

  1. Then execute the following command

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

  1. 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.