Windows Installations
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')
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.
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
Once you have connected to the database, execute the below queries one by one:
VACUUM FULL ANALYZE VERBOSE;
Now, go to <AppManager_Home>\working\ folder and execute the below command to stop PGSQL database.
.\bin\stopPGSQL.bat
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')
Go to <AppManager_Home> directory rename the logs folder to logs_old, create a new folder and name it as logs.
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.
Use the command prompt to go to <AppManager_Home> directory and execute the below commands:
sh shutdownApplicationsManager.sh
sh shutdownApplicationsManager.sh -force
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.
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
Once you have connected to the database, execute the below queries one by one:
VACUUM FULL ANALYZE VERBOSE;
To Re-index:
Reindex database AMDB;