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?

                      • 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
                      • Daylight Saving Time(DST) not being updated in the OpManager

                        Issue: Daylight Saving Time(DST) difference is not reflected in OpManager. The Time that is being shown in "About" tab in OpManager UI will have 1 hour time difference with respect to the actual time. Reason: Daylight Saving Time(DST) changes that ...