GBase 8c 学习笔记 005 —— GBase 8c 图形化工具DBeaver

心有阳光 2023-03-25

3001

GBase 8c 学习笔记 005 —— GBase 8c 图形化工具DBeaver

DBeaver概述

数据库管理工具、SQL客户端
- 基于 Java 开发，支持管理兼容 JDBC 的数据库。
- 免费开源，使用非常友好，且遵循ASL 协议。
- 可以运行在Windows、Linux、macOS 等操作系统。
- 支持插件扩展，提供许多数据库管理工具。
特性
- 支持数据库连接和驱动器管理
- 支持SQL语句和脚本的执行
- 支持元数据的浏览和编辑（包括表，列，键，索引）
DBeaver下载及安装
- 官网下载地址：https://dbeaver.io/download/
- 选择并下载相应的安装包。
  - 不同操作系统都提供了安装包或者解压版。以Windows系统安装包为例。
- 双击程序包执行安装。
- 勾选DBeaver和Include Java。
  - 一路根据提示选择“中文(简体)”“下一步”“我接受”选项

连接和使用

GBase 8c 配置

设置 GBase 8c 集群参数，才能被远程连接。
对于 GBase 8c 分布式集群，需在读写 CN 上以 gbase 用户执行如下命令：

gs_guc reload -Z coordinator -N all -I all -h "host all all 0.0.0.0/0 sha256" 
gs_guc reload -Z coordinator -N all -I all -c "password_encryption_type=1" 
gs_guc reload -Z coordinator -N all -I all -c "listen_addresses = '*'"

参数说明

在 pg_hba.conf 文件中添加新的客户端认证方式的规则。
password_encryption_type 参数用于配置采用的加密算法。默认为 1。
listen_addresses 参数用于配置监听IP。

[gbase@gbase8c_5_152 ~]$ gs_guc reload -Z coordinator -N all -I all -h "host all all 0.0.0.0/0 sha256"
The gs_guc run with the following arguments: [gs_guc -Z coordinator -N all -I all -h host all all 0.0.0.0/0 sha256 reload ].
Begin to perform the total nodes: 3.
Popen count is 2, Popen success count is 2, Popen failure count is 0.
Begin to perform gs_guc for coordinators.
Command count is 2, Command success count is 2, Command failure count is 0.

Total instances: 2.
ALL: Success to perform gs_guc!


[gbase@gbase8c_5_152 ~]$ gs_guc reload -Z coordinator -N all -I all -c "password_encryption_type=1"
The gs_guc run with the following arguments: [gs_guc -Z coordinator -N all -I all -c password_encryption_type=1 reload ].
Begin to perform the total nodes: 3.
Popen count is 2, Popen success count is 2, Popen failure count is 0.
Begin to perform gs_guc for coordinators.
Command count is 2, Command success count is 2, Command failure count is 0.

Total instances: 2.
ALL: Success to perform gs_guc!


[gbase@gbase8c_5_152 ~]$ gs_guc reload -Z coordinator -N all -I all -c "listen_addresses = '*'"
The gs_guc run with the following arguments: [gs_guc -Z coordinator -N all -I all -c listen_addresses = '*' reload ].
Begin to perform the total nodes: 3.
Popen count is 2, Popen success count is 2, Popen failure count is 0.
Begin to perform gs_guc for coordinators.
Command count is 2, Command success count is 2, Command failure count is 0.

Total instances: 2.
ALL: Success to perform gs_guc!

重启数据库

gha_ctl stop all -l dcslist

gha_ctl start all -l dcslist

# 格式：http://dcsip:port
# 例如 http://172.16.5.124:2379

[gbase@gbase8c_5_152 ~]$ gha_ctl stop all -l http://192.168.254.152:2379
{
    "ret":0,
    "msg":"Success"
}
[gbase@gbase8c_5_152 ~]$ gha_ctl start all -l http://192.168.254.152:2379
{
    "ret":0,
    "msg":"Success"
}
[gbase@gbase8c_5_152 ~]$

登录数据库，创建系统管理员(sysadmin)用户

gsql -d dbname -p port -h host_ip
create user name sysadmin password '**';

# 密码格式：必须包含英文、数字、特殊符号，8字符及以上；
# 单引号、双引号都可；

[root@gbase8c_5_151 ~]# su gbase
[gbase@gbase8c_5_151 root]$ gsql -d postgres -p 5432
gsql ((multiple_nodes GBase8cV5 3.0.0B76 build 47948f99) compiled at 2023-02-27 16:04:20 commit 0 last mr 1232 )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.

postgres=# create user testuser sysadmin password 'Gbase,12';
CREATE ROLE
postgres=#