Updated on 2024-10-21 GMT+08:00
Overview
If you have created a GaussDB(DWS) cluster, you can use the SQL client tool or a third-party driver such as JDBC or ODBC to connect to the cluster and access the database in the cluster.
The procedure for connecting to a cluster is as follows:
- Obtaining the Connection Address of a GaussDB(DWS) Cluster
- If SSL encryption is used, perform the operations in Establishing Secure TCP/IP Connections in SSL Mode.
- Connect to the cluster and access the database in the cluster. You can choose any of the following methods to connect to a cluster:
- You are advised to use the officially recommended method for connecting to the database.
- Compatibility with other clients cannot be guaranteed, so it may be necessary to verify it.
- If an error occurs due to incompatibility with another client and the client cannot be replaced, try replacing the libpq driver on the client. To replace the libpg.so file on the client, download and extract the gsql client package by referring to Downloading the Client, locate the gsql directory, and obtain the file. Then, replace the existing libpg.so file in the designated directory on the client.
- Using the SQL Editor to Connect to a Cluster
- Use the SQL client tool to connect to the cluster.
- Use a JDBC, psycopg2, or PyGreSQL driver to connect to the cluster.
Parent topic: Connecting to a GaussDB(DWS) Cluster
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot