Updated on 2023-03-17 GMT+08:00

Overview

This document describes how to use GaussDB(DWS) tools, including client tools, as shown in Table 1, and server tools, as shown in Table 2.

The client tools can be obtained by referring to Downloading Client Tools.

The server tools are stored in the $GPHOME/script and $GAUSSHOME/bin paths on the database server.

Table 1 Client Tools

Tool

Description

gsql

A command-line interface (CLI) SQL client tool running on the Linux OS. It is used to connect to the database in a GaussDB(DWS) cluster and perform operation and maintenance on the database.

Data Studio

A client tool used to connect to a database. It provides a GUI for managing databases and objects, editing, executing, and debugging SQL scripts, and viewing execution plans. Data Studio can run on a 32-bit or 64-bit Windows OS. You can use it after decompression without installation.

GDS

A CLI tool running on the Linux OS. It works with foreign tables to quickly import and export data. The GDS tool package needs to be installed on the server where the data source file is located. This server is called the data server or the GDS server.

DSC

A CLI tool used for migrating SQL scripts from Teradata or Oracle to GaussDB(DWS) to rebuild a database on GaussDB(DWS). DSC runs on the Linux OS. You can use it after decompression without installation.

Table 2 Server Tools

Tool

Description

gs_dump

gs_dump exports database information, such as the complete and consistent data of database objects (including databases, schemas, tables, and views), without affecting the normal access of users to the database.

gs_dumpall

gs_dumpall exports database information, such as the complete and consistent data of database objects, without affecting the normal access of users to the database.

gs_restore

gs_restore is a tool provided by GaussDB(DWS) to import data that is exported using gs_dump. It can also be used to import files that were exported using gs_dump.

gds_check

gds_check is used to check the GDS deployment environment, including the OS parameters, network environment, and disk usage. It also supports the correction of system parameters. This helps detect potential problems during GDS deployment and running, improving the execution success rate.

gds_install

gds_install is a script tool used to install GDS in batches, improving GDS deployment efficiency.

gds_uninstall

gds_uninstall is a script tool used to uninstall GDS in batches.

gds_ctl

gds_ctl is a script tool used for starting or stopping GDS service processes in batches. You can start or stop GDS service processes, which use the same port, on multiple nodes at a time, and set a daemon for each GDS process during the startup.

gs_sshexkey

During cluster installation, you need to execute commands and transfer files among hosts in the cluster. gs_sshexkey is used to help users establish mutual trust.