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.