Verifying the Installation
Use the gs_om tool provided by openGauss to check the database status.
Prerequisites
The openGauss database has been installed.
Procedure
Log in to the server as user omm.
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
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 ((openGauss 1.1.0 build 290d125f) compiled at 2020-05-08 02:59:43 commit 2143 last mr 131 Non-SSL connection (SSL connection is recommended when requiring high-security) Type "help" for help.