MogDB
Ecological Tools
Doc Menu

Verifying the Installation

Use the gs_om tool provided by MogDB to check the database status.

Prerequisites

The MogDB database has been installed.

Procedure

  1. Log in to the server as user omm.
  2. Run the following command to check whether the database is normal. If the value of cluster_state is Normal, the database is running properly.

    gs_om -t status
  3. After the database is installed, a database named postgres is generated by default. When connecting to a database for the first time, you can connect to this database.

    In the following command, postgres indicates the name of the database to be connected, and 26000 indicates the port number of the primary database node, that is, the value of dataPortBase in the XML configuration file. Replace the values as required.

    gsql -d postgres -p 26000

    If information similar to the following is displayed, the database is successfully connected:

    gsql ((MogDB 2.0.0 build 5be05d82) compiled at 2021-05-28 02:59:43 commit 2143 last mr 131
    Non-SSL connection (SSL connection is recommended when requiring high-security)
    Type "help" for help.