Windows Installations

1. Open services.msc, stop “ManageEngine Applications Manager” service or via command prompt with administrator permission.
   If you are using the command prompt, go to <AppManager_Home> directory and execute the below commands:
   shutdownApplicationsManager.bat
   shutdownApplicationsManager.bat -force
   (execute this until you get a message that says 'All processes have been shutdown')

2. Open command prompt in the administrator mode, go to <AppManager_Home>\working\ folder and execute the below command to start PGSQL database:
   .\bin\startPGSQL.bat
   

Note: Please check if the DB port given in <AppManager_Home>\conf\AMServer.properties file is same as the <AppManager_Home>\working\bin\startPGSQL.bat file.

3. Once the PGSQL database starts, open another command prompt in the administrator mode and connect your AppManager DB using the steps provided in the below link:
   https://pitstop.manageengine.com/portal/en/kb/articles/connecting-to-applications-managers-bundled-database 

4. Once you have connected to the database, execute the below queries one by one:
   VACUUM FULL ANALYZE VERBOSE;
   

5. 
   

6. Now, go to <AppManager_Home>\working\ folder and execute the below command to stop PGSQL database.
   .\bin\stopPGSQL.bat

7. Open command prompt in the administrator mode, go to <AppManager_Home>\ and then execute the below commands:
   shutdownApplicationsManager.bat
   shutdownApplicationsManager.bat -force
   (execute this until you get a message that says 'All processes have been shutdown')

8. Go to <AppManager_Home> directory rename the logs folder to logs_old, create a new folder and name it as logs.
   

9. Open services.msc, start ManageEngine Applications Manager service.
   

LINUX Installations

Note: Please take complete DB backup using the <AppManager Home>/bin/BackupPGSQLDB.sh script without fail before following the below steps.

1. Use the command prompt to go to <AppManager_Home> directory and execute the below commands:
   sh shutdownApplicationsManager.sh
   sh shutdownApplicationsManager.sh -force
   

2. Open command prompt in the administrator mode, go to <AppManager_Home>/working/ folder and execute the below command to start PGSQL database:
   .\bin\startPGSQL.sh

Note: Please check if the DB port given in <AppManager_Home>/conf/AMServer.properties file is same as in <AppManager_Home>/working/bin/startPGSQL.sh file.

3. Once the PGSQL database starts, open another command prompt in the administrator mode and connect your AppManager DB using the steps provided in the below link:
   https://pitstop.manageengine.com/portal/en/kb/articles/connecting-to-applications-managers-bundled-database
   

4. Once you have connected to the database, execute the below queries one by one:
   VACUUM FULL ANALYZE VERBOSE;
   

5. To Re-index:
   Reindex database AMDB;