[OpManager] Accessing the PGSQL Database

[OpManager] Accessing the 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).