人大金仓数据库Kingbase安装

1. 准备

1）下载安装包/许可

 官网下载的安装包为iso镜像

选择开发许可 

2）添加Linux用户，赋权，创建目录

# 添加用户
useradd kingbase
# 设置密码
echo '11111111' | passwd --stdin kingbase
# 切换用户
su - kingbase
# 创建镜像挂载目录
mkdir ~/install
# 创建许可目录
mkdir ~/license
# 创建安装目录
mkdir ~/install-dest

上传镜像文档文件至 /home/kingbase（注：不要上传到install下，此目录用于后续挂载镜像），上传许可文件至/home/kingbase/license下

保证镜像 KingbaseES_V009R001C001B0025_Lin64_install.iso 文件权限为 kingbase 用户

由于是root上传，需要执行

sudo chown kingbase:kingbase KingbaseES_V009R001C001B0025_Lin64_install.iso

*注:

如产生如下报错

[kingbase@yangxk-node01 ~]$ sudo chown kingbase:kingbase KingbaseES_V009R001C001B0025_Lin64_install.iso
[sudo] kingbase 的密码：
kingbase 不在 sudoers 文件中。此事将被报告。

切换root用户， 执行 vi  /etc/sudoers, 添加kingbase用户sudo权限

3）挂载镜像

[kingbase@yangxk-node01 ~]$ sudo mount KingbaseES_V009R001C001B0025_Lin64_install.iso ./install
mount: /dev/loop0 is write-protected, mounting read-only
[kingbase@yangxk-node01 ~]$ cd ./install/
[kingbase@yangxk-node01 install]$ ll
total 6
dr-xr-xr-x 2 root root 2048 Oct 30  2023 setup
-r-xr-xr-x 1 root root 3933 Oct 30  2023 setup.sh

2. 安装

1）执行安装, 进入./install目录

[kingbase@yangxk-node01 ~]$ cd ./install 
[kingbase@yangxk-node01 install]$ ./setup.sh 
Now launch installer...
Preparing to install
Extracting the JRE from the installer archive...
Unpacking the JRE...
Extracting the installation resources from the installer archive...
Configuring the installer for this systems environment...
          Verifying JVM........
Launching installer...


Graphical installers are not supported by the VM. The console mode should be used instead...

===============================================================================
KingbaseES V9                                    (created with InstallAnywhere)
-------------------------------------------------------------------------------

Preparing CONSOLE Mode Installation...

2）过程中需要输入许可路径（之前上传的许可）

===============================================================================
Choose License File
-------------------

File Path: /home/kingbase/license/license_39892_0.dat

License序列号 --- 启用 --- D85FB05E-0F68-11EF-97BF-000C29CBE49F
生产日期 --- 启用 --- 2024-05-11
产品名称 --- 启用 --- KingbaseES V8
细分版本模板名 --- 启用 --- SALES-开发版 V9R1
产品版本号 --- 启用 --- V009R001C
浮动基准日期 ------ 启用
有效期间 --- 启用 --- 365
用户名称 --- 启用 --- 官方网站试用授权
项目名称 --- 启用 --- 官方网站试用授权

3）选择安装目录

默认目录为：/opt/Kingbase/ES/V9, 当前指定安装到了 /home/kingbase/install-dest

===============================================================================
Choose Install Folder
---------------------

Please choose a destination folder for this installation.

Where would you like to install?

  Default Install Folder: /opt/Kingbase/ES/V9


ENTER AN ABSOLUTE PATH, OR PRESS <ENTER> TO ACCEPT THE DEFAULT
      : /home/kingbase/install-dest                         

INSTALL FOLDER IS: /home/kingbase/install-dest
   IS THIS CORRECT? (Y/N): Y

4）选择其他参数：数据目录，端口，用户，密码，字符集，模式……

===============================================================================
Choose a Folder for data directory
----------------------------------
Please choose a folder. The folder must be empty.
Data folder (Default: /home/kingbase/install-dest/data): 


===============================================================================
Port
----
Please enter database service listened port， default 54321.
Port (Default: 54321): 


===============================================================================
User
----
Please enter database administrator user name.
User: (Default: system): 


===============================================================================
Enter Password
--------------
Please Enter the Password: Please Enter the Password:*************


===============================================================================
Enter Password again
--------------------
Please Enter the Password Again: Please Enter the Password Again:**********c**


===============================================================================
Server Encoding
---------------
Please enter server character set encoding.
  ->1- UTF8
    2- GBK
    3- GB18030

ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT: 1


===============================================================================
Database Mode
-------------
Please enter database mode.
    1- PG
  ->2- ORACLE
    3- MySQL

ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT:

上述步骤中，注意 database mode选择，影响到SQL兼容性 

5）安装成功，加入到服务

===============================================================================
Installation Complete
---------------------
Congratulations. KingbaseES V9 has been successfully installed to:
/home/kingbase/install-package
If you want to register KingbaseES V8 as OS service, please run
    /home/kingbase/install-dest/install/script/root.sh
PRESS <ENTER> TO EXIT THE INSTALLER: 

6）服务启动

进入 cd /home/kingbase/install-dest/Server/bin 

执行启动指令 ./sys_ctl -D /home/kingbase/install-dest/data start

[kingbase@yangxk-node01 bin]$ ./sys_ctl -D /home/kingbase/install-dest/data start
waiting for server to start....2024-06-06 12:09:50.377 GMT [26052] WARNING:  max_connections should be less than or equal than 10 (restricted by license)
2024-06-06 12:09:50.377 GMT [26052] HINT:  the value of max_connect is set 10
2024-06-06 12:09:50.378 GMT [26052] WARNING:  max_connections should be less than or equal than 10 (restricted by license)
2024-06-06 12:09:50.378 GMT [26052] HINT:  the value of max_connect is set 10
2024-06-06 20:09:50.577 CST [26052] LOG:  sepapower extension initialized
2024-06-06 20:09:50.755 CST [26052] LOG:  starting KingbaseES V009R001C001B0025 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-28), 64-bit
2024-06-06 20:09:50.755 CST [26052] LOG:  listening on IPv4 address "0.0.0.0", port 54321
2024-06-06 20:09:50.755 CST [26052] LOG:  listening on IPv6 address "::", port 54321
2024-06-06 20:09:50.757 CST [26052] LOG:  listening on Unix socket "/tmp/.s.KINGBASE.54321"
2024-06-06 20:09:50.796 CST [26052] LOG:  redirecting log output to logging collector process
2024-06-06 20:09:50.796 CST [26052] HINT:  Future log output will appear in directory "sys_log".

检查启动状态 ./sys_ctl -D /home/kingbase/install-dest/data status

[kingbase@yangxk-node01 bin]$ ./sys_ctl -D /home/kingbase/install-dest/data status
sys_ctl: 正在运行服务器进程(PID: 26052)
/home/kingbase/install-dest/KESRealPro/V009R001C001B0025/Server/bin/kingbase "-D" "/home/kingbase/install-dest/data"

7）环境变量

将 /home/kingbase/install-dest/Server/bin 加入到环境变量中，否则需要制定执行命令路径

vi ~/.bashrc 加入bin目录，如下

保存后执行 source ~/.bashrc 生效

[kingbase@yangxk-node01 ~]$ vi ~/.bashrc
[kingbase@yangxk-node01 ~]$ source ~/.bashrc

3. 初始化

1）登录 ：ksql -Usystem -p54321 kingbase

[kingbase@yangxk-node01 ~]$ ksql -Usystem -p54321 kingbase
用户 system 的口令：
输入 "help" 来获取帮助信息.

 如果没有加入到环境变量，需要输入全路径/home/kingbase/install-dest/Server/bin/ksql

2）检查数据库当前模式 ：show database_mode

3）检查数据库 ： \l（pg指令）

4）创建数据库 ：create database

创建数据库时可以直接指定：字符集，所有者，表空间，模版，当前测试仅指定：所有者、字符集。创建完成使用\l+ testdb 检查详细信息，看到更多默认参数 

kingbase=# CREATE DATABASE testdb WITH OWNER=system ENCODING='UTF8';                                                            
CREATE DATABASE
kingbase=# \l+ testdb

表空间：sys_default ，可以后续修改表空间，可以修改默认表空间

5）切换数据库，导入数据 

kingbase=# \c testdb
You are now connected to database "testdb" as userName "system".
testdb=# \i /home/kingbase/init.sql