Reindex & Vacuum OpManager Database
Reindex & Vacuum OpManager Database
Stop OpManager service
Make sure there is no running postgres process running in the Task Manger
Open a command prompt as an administrator and go to /OpManager/bin directory
Execute startPgsql.bat to start PGSQL
Open a new command prompt as an administrator and go to /OpManager/pgsql/bin directory
Connect the database using the below command
psql -U postgres -p13306 -h127.0.0.1 OpManagerDB (Essential edition)
psql -U postgres -p13308 -h127.0.0.1 ProbeDB (Enterprise edition -- Probe)
psql -U postgres -p13307 -h127.0.0.1 CentralDB (Enterprise edition -- Central)
Execute the below commands one by one
reindex database "OpManagerDB";
vacuum full verbose;
It takes some time to complete the process. Once it is completed
Exit the database console using \q
From the first command window, execute stopPgsql.bat file.
Start OpManager Service.
New to ADSelfService Plus?
Related Articles
Database information in OpManager
Question: Where can I find my OpManager database information? Solution: OpManager database information is stored in the file "database_params.conf" under OpManager/conf folder. The database server name/IP , database name, database type and user ...REMOVING UNSOLICITED TRAPS FROM OPMANAGER DATABASE
Connect to OpManager database and execute the below query : Refer the link below to connect to OpManager database : https://support.zoho.com/portal/manageengine/helpcenter/articles/connecting-to-the-opmanager-database 1. Run this command from the ...Where can I find my OpManager database information?
Question: Where can I find my OpManager database information? Solution: OpManager database information is stored in the file "database_params.conf" under OpManager/conf folder. The database server name/IP , database name, database type and user ...How to delete the SMS Queue from OpManager database?
Connect to OpManager database and run the below database query : delete from sms_out; Refer the link below to connect to OpManaqger database : https://support.zoho.com/portal/manageengine/helpcenter/articles/connecting-to-the-opmanager-databaseConnecting to the OpManager Database (Applicable for versions 12.4 and below)
Question: How to connect to OpManager Database? Solution: We can connect to the database from OpManager Web client itself ( Update Queries have to be executed by connecting to the database directly) (Click on Support ícon on top right corner >DB ...