Reindex & Vacuum OpManager Database

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. 

          • 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-database
          • Connecting 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 ...