Got it

How to connect the GaussDB Service (CLI)

Latest reply: Jun 23, 2020 23:14:41 3047 4 4 0 0

Hi all,


As per the FusionInsight document, GaussDB is the backend database for the FusionInsight manager and Hive. I want to connect GaussDB databases and see the tables and scheme structures.


I need to know how to connect the GaussDB CLI prompt.


Which user needs be used to connect the CLI? Do we need to get a Kerberos ticket for DB user?


I don't see any relevant document for GaussDB.   


Thanks,

Ramu A

Hello!

The client tools for connecting to the database include GSQL, Data Studio, application interfaces (such as ODBC and JDBC), and Psql.

1. GSQL is a client tool provided by the product. Use GSQL to connect to the database. You can enter, edit, and execute SQL statements in a interactive mode.

2. Data Studio is a GUI tool that connects to the database using Data Studio and can debug and execute SQL statements and stored procedures.

3. Users can use standard database application interfaces (such as ODBC and JDBC) to develop applications based on LibrA.

4. Psql is an open-source client tool. Psql is used to connect to the database. You can enter, edit, and execute SQL statements in a interactive mode.

The link to the Gaussdb documents is as follows: https://support.huawei.com/carri ... 31665/PBI1-21407429.
View more
  • x
  • convention:

4. Psql is an open-source client tool. Psql is used to connect to the database. You can enter, edit, and execute SQL statements in a interactive mode.

How can do that. I have GaussDB and need connect to database but I get error:
Server closed the coonection unexpectedly. This probably means the serve terminated aboonmally before or while processing the request.
View more
  • x
  • convention:

Experienced
View more
  • x
  • convention:

Great
View more
  • x
  • convention:

Comment

You need to log in to comment to the post Login | Register
Comment

Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:
  • Politically sensitive content
  • Content concerning pornography, gambling, and drug abuse
  • Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy
Do not share your account and password with others. All operations performed using your account will be regarded as your own actions and all consequences arising therefrom will be borne by you. For details, see " User Agreement."

My Followers

Login and enjoy all the member benefits

Login

Block
Are you sure to block this user?
Users on your blacklist cannot comment on your post,cannot mention you, cannot send you private messages.
Reminder
Please bind your phone number to obtain invitation bonus.