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. 

      New to ADSelfService Plus?

        Resources

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