环境:
OS:Centos 7
1.获取安装介质
获取地址:
https://www.kingbase.com.cn/tyxsjk/index.htm
KingbaseES_V008R006C006B0013_Lin64_install.iso ##安装介质
license_18720_0.dat ##授权文件
1.创建用户
useradd -m -U kingbase
passwd kingbase
2.文件目录规划
安装包存放目录:/soft/kingbase
软件目录:/kingbase/app/
数据目录:/kingbase/data/
备份目录:/kingbase/backup/
脚本目录:/kingbase/scripts/
归档目录:/kingbase/archive/
授予权限 chown -R kingbase:kingbase /kingbase
mkdir -p /kingbase/app/
mkdir -p /kingbase/data/
mkdir -p /kingbase/backup/
mkdir -p /kingbase/scripts/
mkdir -p /kingbase/archive/
chown -R kingbase:kingbase /kingbase
chown -R kingbase:kingbase /soft/kingbase
3.修改资源限制(以下操作需要root权限)
vi /etc/security/limits.conf
增加如下内容:
kingbase hard nofile 65536
kingbase soft nofile 65536
kingbase hard nproc 65536
kingbase soft nproc 65536
kingbase soft core unlimited
kingbase hard core unlimited
4.安装java环境
[root@host134 mnt]# java -version
java version "1.8.0_181"
Java(TM) SE Runtime Environment (build 1.8.0_181-b13)
Java HotSpot(TM) 64-Bit Server VM (build 25.181-b13, mixed mode)
5.mount安装介质
[root@localhost soft]# cd /soft/kingbase
[root@host134 kingbase]#mount -o loop KingbaseES_V008R006C006B0013_Lin64_install.iso /mnt
6.命令行模式安装
[root@host134 mnt]# su - kingbase
[kingbase@host134 ~]$ cd /mnt
[kingbase@host134 mnt]$./setup.sh -i console
Please choose the Install Set to be installed by this installer.
->1- Full
2- Client
3- Custom
ENTER THE NUMBER FOR THE INSTALL SET, OR PRESS <ENTER> TO ACCEPT THE DEFAULT
: 1
===============================================================================
Choose License File
-------------------
File Path: /soft/kingbase/license_18720_0.dat
Please choose a destination folder for this installation.
Where would you like to install?
Default Install Folder: /opt/Kingbase/ES/V8
ENTER AN ABSOLUTE PATH, OR PRESS <ENTER> TO ACCEPT THE DEFAULT
: /kingbase/app/
===============================================================================
Choose a Folder for data directory
----------------------------------
Please choose a folder. The folder must be empty.
Data folder (Default: /kingbase/app/data): /kingbase/data/
===============================================================================
Port
----
Please enter database service listened port, default 54321.
Port (Default: 54321):
===============================================================================
User
----
Please enter database administrator user name.
User: (Default: system):
Please Enter the Password: Please Enter the Password:*********
===============================================================================
Enter Password again
--------------------
Please Enter the Password Again: Please Enter the Password Again:*********
这里密码我们设置为:kingbase
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
ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT: 2
Please enter the case sensitivity.
->1- YES
2- NO
ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT: 1
Please enter block size used in storing data.
->1- 8k
2- 16k
3- 32k
ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT: 1
===============================================================================
Installation Complete
---------------------
Congratulations. KingbaseES V8 has been successfully installed to:
/kingbase/app
If you want to register KingbaseES V8 as OS service, please run
/kingbase/app/install/script/root.sh
PRESS <ENTER> TO EXIT THE INSTALLER
执行脚本(root用户下执行)
[root@host134 app]# /kingbase/app/install/script/root.sh
Starting KingbaseES V8:
waiting for server to start.... done
server started
KingbaseES V8 started successfully
[root@host134 app]#
查看服务
systemctl status kingbase8d
好像该服务不管用,数据库是启动了,通过该命令查看服务异常,可以不理会该命令。
7.设置环境变量
su - kingbase
cd ~
vi .bash_profile
export KINGBASE_HOME=/kingbase/app
export KINGBASE_DATA=/kingbase/data
export PATH=$KINGBASE_HOME/Server/bin:$PATH
export LD_LIBRARY_PATH=$PATH:$KINGBASE_HOME/Server/lib
8.登陆
[kingbase@host134 ~]$ ksql -p 54321 -U system -d test -W
这里要求输入密码,这里的密码是安装时设置kingbase
ksql (V8.0)
Type "help" for help.
test=# \dt
Did not find any relations.
test=# \du
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------------------+-----------
sao | No inheritance | {}
sso | No inheritance | {}
system | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
test=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+--------+----------+-------------+-------------+-------------------
security | system | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 |
template0 | system | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/system +
| | | | | system=CTc/system
template1 | system | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/system +
| | | | | system=CTc/system
test | system | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 |
(4 rows)
test=# create database db_test;
CREATE DATABASE
test=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+--------+----------+-------------+-------------+-------------------
db_test | system | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 |
security | system | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 |
template0 | system | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/system +
| | | | | system=CTc/system
template1 | system | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/system +
| | | | | system=CTc/system
test | system | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 |
(5 rows)
9.日常维护
a.重启动
[root@host134 om]# su - kingbase
Last login: Mon Jul 25 09:48:35 CST 2022 on pts/1
[kingbase@host134 ~]$ sys_ctl restart