Standalone DB Connector in OpManager (PgSQL)

Standalone DB Connector in OpManager (PgSQL)

The below KB is applicable for all editions & from version 12.6.262 and above.  Please follow this on Support team request. 

Question: How to connect to OpManager PgSQL Database via command prompt?

Solution:

Please follow the below steps to connect the standalone DB executor in OpManager. 

1. Stop the ManageEngine OpManager service. 

2. Open an admin command prompt and navigate to OpManager<HOME>\bin directory.

3. Execute StandaloneDBQueryExecutor.bat (.sh file for Linux)

4. This will prompt for Super Admin credential. Provide the OpManager UI login default user "admin" credential.

5. Select Option 2 to execute "Select" query.
     Note: Kindly do not execute any other queries like "insert, update, delete" without Support team assistance or confirmation as this may lead to data loss.

6. Execute the Select query and save the output to a text file. 

7. Finally, enter the option 3 to exit the DB connection. 


8. Close the command prompt and start the ManageEngine OpManager service for continuous monitoring. 

Kindly contact us at opmanager-support@manageengine.com for further queries or issues. 

                  New to ADSelfService Plus?

                    • Related Articles

                    • OpManager DB migration from PGSQL to MSSQL in Version 125230

                      For OpManager version 125230: PGSQL to MSSQL Migration Steps : In the PGSQL setup, go to OpManager home → bin, start Command Prompt with administrator privilege from this path and run DBConfiguration.bat. In the popup shown, please chose MSSQL, check ...
                    • OpManager DB migration from PGSQL to MSSQL on the same server in Version 12.3

                      Please follow the below mentioned steps to migrate DB from PGSQL to MSSQL on the same server. These steps are applicable only on builds 12.3.045 and above. If you are in older versions below 12.3.045, please upgrade to 12.3.045 and follow these ...
                    • Database Migration - MySQL to PgSQL

                      The DB migration from MySQL to PgSQL involves taking a PgSQL compatible backup, re-installing the product with PgSQL database and restoring the backup. The procedure for the above is a little tedious and time consuming in version 9 & 10. So, please ...
                    • 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 ...
                    • Steps for setting up a password for PgSQL DB

                      The steps are verified and tested until 12.4.072.  We request you to take a VM snapshot or a folder backup of the OpManager server itself (stop the OpManager service) as a first measure. Below mentioned steps are applicable for Postgres version till ...