Accessing OpManager PGSQL Database

Accessing OpManager PGSQL Database

Accessing the Database          

·       Although uncommon, accessing the OpManager database may be required to pull specific data, apply changes, or to troubleshoot an issue as directed by Manage Engine.

 ·       To access the Central database, navigate to the following folder:

·       /opt/ManageEngine/OpManagerCentral/pgsql/bin/

·       Enter the following command:

·       ./psql -U dbuser -p13307 -h127.0.0.1 CentralDB

·       Enter the password (must be obtained from Manage Engine).

·       Example:

A white background with black text AI-generated content may be incorrect.

 

·       To quit the database session, enter command ‘\q’:

 

·       To access the Probe database, navigate to the following folder:

·       /opt/ManageEngine/OpManagerProbe/pgsql/bin/

·       Enter the following command:

·       ./psql -U dbuser -p13308 -h127.0.0.1 ProbeDB

·       Enter the password (must be obtained from Manage Engine).



    • Related Articles

    • Re-Index OpManager Postgres Database

      Query to check table size Reach out to Manage Engine prior to proceeding with any changes to the database. All queries must be run as the 'admin' user. Log into the server GUI and go to the database lookup page "Support>DB Query". Execute the ...

    • SQL Database query for OpManager

      SQL Database query for OpManager Database queries can be run from the web UI to pull various information from the database. In addition, Manage Engine may provide queries and request the output when troubleshooting an issue. To run a query, click the ...

    • Opmanager is attempting to contact Zoho Networks and SMTP

      Introduction A customer noted that the OpManager Probe server was attempting to send data to Manage Engine which was in violation of the Firewall rules that they had on their IP network. Settings that may need to be changed to stop automated data ...

    • OpManager Trap Processor Config

      OpManager Trap Processor Config Trap processor can be edited to display a number of labels and information based on the markup language and variables (VarBinds) https://pitstop.manageengine.com/portal/kb/articles/how-to-configure-trap-message Changes ...

    • Configuring configlets in OpManager NCM

      Manage Engine has written instruction on using and creating configlets. The link in this KB may be changed if Manage Engine update it, but for now it is a source for other NCM info as well ...