GBase8c 远程客户端安装

一、 完成远程连接配置

远程连接 GBase 8c 数据库，需要提前在服务端进行配置，再通过客户端远程连接GBase 8c 数据库。 切换gbase用户执行以下语句

[gbase@node1 ~]$ gs_guc reload -N all -I all -Z coordinator -h "host all all 0.0.0.0/0 md5"

[gbase@node1 ~]$ gs_guc reload -N all -I all -Z coordinator -c "listen_addresses='*'"

[gbase@node1 ~]$ gs_guc reload -N all -I all -Z datanode -h "host all all 0.0.0.0/0 md5"

[gbase@node1 ~]$ gs_guc reload -N all -I all -Z datanode -c "listen_addresses='*'"

[gbase@node1 ~]$ gs_guc reload -N all -I all -Z coordinator -c "password_encryption_type=1"

[gbase@node1 ~]$ gs_guc reload -N all -I all -Z datanode -c "password_encryption_type=1"

[gbase@node1 ~]$ gs_guc reload -N all -I all -Z gtm -c "listen_addresses='*'"

[gbase@node1 ~]$ gs_guc reload -N all -I all -Z gtm -c "password_encryption_type=1"

[gbase@node1 ~]$ gs_guc reload -N all -I all -Z gtm -h "host all all 0.0.0.0/0 md5"

上述语句执行完毕后，重启数据库

[gbase@node1 ~]$ gha_ctl start all -l http://192.168.122.55:2379

二、 配置安装客户端

在客户端机器上，上传安装包并配置 gsql 的执行环境变量。以客户端IP为192.168.122.79为例。

1、解压安装包

[gbase@keep-gbase8c-tools ~]$ cd /data/gsql/
[gbase@keep-gbase8c-tools gsql]$ ls
GBase8cV5_S3.0.0B110_centos7.8_x86_64.tar.gz
[gbase@keep-gbase8c-tools gsql]$ tar -zxvf GBase8cV5_S3.0.0B110_centos7.8_x86_64.tar.gz
GBase8cV5_S3.0.0B110_CentOS_x86_64_om.sha256
GBase8cV5_S3.0.0B110_CentOS_x86_64_om.tar.gz
GBase8cV5_S3.0.0B110_CentOS_x86_64_pgpool.tar.gz
GBase8cV5_S3.0.0B110_CentOS_x86_64.sha256
GBase8cV5_S3.0.0B110_CentOS_x86_64.tar.bz2
upgrade_sql.sha256
upgrade_sql.tar.gz
[gbase@keep-gbase8c-tools gsql]$ tar -zxvf GBase8cV5_S3.0.0B110_CentOS_x86_64_om.tar.gz

2、登录数据库主节点所在的服务器，并拷贝数据库运行目录下的bin 目录到客户端主机的安装路径下。

[gbase@node1 ~]$ scp -r  /data/gbase/gbase_db/app/ gbase@192.168.122.79:/data/gsql/

3、配置客户端环境变量

[gbase@keep-gbase8c-tools ~]$ cat ~/.bashrc
# .bashrc

# Source global definitions
if [ -f /etc/bashrc ]; then
        . /etc/bashrc
fi

# Uncomment the following line if you don't like systemctl's auto-paging feature:
# export SYSTEMD_PAGER=

# User specific aliases and functions

# 添加以下环境变量
export PATH=/data/gsql/app/bin:$PATH
export LD_LIBRARY_PATH=/data/gsql/app/lib:$LD_LIBRARY_PATH

[gbase@keep-gbase8c-tools ~]$ source ~/.bashrc

4、 连接数据库

[gbase@gbase8c_tool gsql]$ gsql -r -d postgres -p 15400 -h 192.168.123.111 -U gbase8c -W Database@123
gsql ((single_node GBase8cV5 S5.0.0B17 build 32f8156d) compiled at 2023-12-05 19:52:51 commit 0 last mr 408 )
SSL connection (cipher: ECDHE-RSA-AES128-GCM-SHA256, bits: 128)
Type "help" for help.

postgres=> \q