Does GaussDB(DWS) Support Third-Party Clients and JDBC and ODBC Drivers?

Yes, but GaussDB(DWS) clients and drivers are recommended. Unlike open-source PostgreSQL clients and drivers, GaussDB(DWS) clients and drivers have two key advantages:

• Security hardening: PostgreSQL drivers only support MD5 authentication, but GaussDB(DWS) drivers support SHA256 and MD5.
• Data type enhancement: GaussDB(DWS) drivers support new data types smalldatetime and tinyint.

GaussDB(DWS) supports open-source PostgreSQL clients and JDBC and ODBC drivers.

The compatible client and driver versions are:

• PostgreSQL psql 9.2.4 or later
• PostgreSQL JDBC Driver 9.3-1103 or later
• PSQL ODBC 09.01.0200 or later

For how to use JDBC/ODBC to connect to GaussDB(DWS), see Guide: JDBC- or ODBC-Based Development.

• You are advised to use the officially recommended method for connecting to the database. For details, see Methods of Connecting to a Cluster.
• 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. Download and decompress the gsql client package, obtain the libpg.so file in the gsql directory, and replace the libpg.so file in the specified directory on the client. For details, see Downloading Related Tools.