DEV Community

leo
leo

Posted on • Updated on

gsql client connects to openGauss

openGauss is a world-leading enterprise-level open source relational database jointly built with partners, providing extreme multi-core performance, full-link business and data security, AI-based tuning and efficient operation and maintenance capabilities. openGauss is comprehensive, friendly and open. It is issued under the Mulan Permissive License v2. It deeply integrates Huawei's years of R&D experience in the database field, and combines the needs of enterprise-level scenarios to continuously build competitive features.

gsql client connection – determine connection information

Client tools connect to the database through the database master node. Therefore, before connecting, you need to obtain the IP address of the server where the database master node is located and the port number of the database master node.

⚫ Step 1: Log in to the master node of the database as the operating system user omm.

⚫ Step 2: Use the "gs_om -t status --detail" command to query the status of each instance of openGauss.

Image description
The IP addresses of the servers where the database master node instance is deployed as above are 192.168.10.11 respectively, and the data path of the database master node is "/srv/BigData/gaussdb/data1/dbnode".

⚫ Step 3: Confirm the port number of the database master node. Check the port number information in the postgresql.conf file under the data path of the database master node found in step 2. An example is as follows:

Image description

Top comments (0)