Methods of Connecting to a Cluster¶
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:
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:
Important
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, locate the gsql directory, and obtain the file. Then, replace the existing libpg.so file in the designated directory on the client.
Use the SQL client tool to connect to the cluster.
Use a JDBC, psycopg2, or PyGreSQL driver to connect to the cluster.