可能用到的Linux命令
通用机装卸启停
专用机装卸启停
- 数据库的启停与状态查看
  - ps -ef | grep -i kingbase
  - systemctl status kingbase8d.service
初始化实例
常见问题

可能用到的Linux命令

useradd&passwd

创建用户及密码 (安装数据库时，必须使用非root用户安装)
useradd -m -U kingbase
输入密码
passwd kingbase

mkdir&chown

（1）数据库安装包及 license 文件存放存放目录：
mkdir /home/kingbase/install chown -R kingbase.kingbase /home/kingbase/install
（2）数据库软件目录：
mkdir -p /opt/Kingbase/ES/V8 chown -R kingbase.kingbase /opt/Kingbase/ES/V8
（3）数据库数据目录（选择存储空间大的做数据目录）：
mkdir -p /dbdata/data chown -R kingbase.kingbase /dbdata/data
（4）数据库备份目录（选择存储空间大的做备份目录，最好不与数据目录在同一盘下）：
A：物理备份路径
mkdir /dbbackup/kbbr_repo chown -R kingbase.kingbase /dbbackup/kbbr_repo
B:逻辑备份路径
mkdir /dbbackup/logical chown -R kingbase.kingbase /dbbackup/logical

systemclt （防火墙管理）

开启防火墙服务
systemctl start firewalld.service
防火墙状态查看
systemctl status firewalld.service
关闭防火墙
systemctl stop firewalld.service
systemctl disable firewalld.service

mount （挂载设配）

挂载命令
mount [-t 文件系统] [-o 特殊选项] 设备文件名挂载点
mount -o -loop .../*.iso /media/

用来把一个文件当成硬盘分区挂接上系统

ln （创建软链接）

ln -s /data/kingbase/data /opt/Kingbase/ES/V8/data

data → /data/kingbase/data

scp （不同服务器之间的文件传输）

从远程复制文件到本地目录：
scp **root@192.168.10.10:/opt/soft/rhel-server-7.3-x86_64.tar.gz** /opt/soft/
上传本地文件到远程机器指定目录：
scp /opt/soft/rhel-server-7.3-x86_64.tar.gz **root@192.168.10.10:/opt/soft/scptest**

vi .bash_profile （配置环境变量）

**export PATH=$PATH:/opt/Kingbase/ES/V8/Server/bin**
**export KINGBASE_DATA=/opt/Kingbase/ES/V8/data**
export LD_LIBRARY_PATH=$PATH:/opt/Kingbase/ES/V8/Server/lib

echo

[kingbase@localhost Scripts]$ echo $KINGBASE_DATA
/opt/Kingbase/ES/V8/data
[kingbase@localhost Scripts]$

sudo

Linux sudo命令以系统管理员的身份执行指令，也就是说，经由sudo所执行的指令就好像是root亲自执行。

通用机装卸启停

https://blog.csdn.net/weixin_43742891/article/details/122035426?spm=1001.2014.3001.5502

数据库状态查询

ps -ef | grep -i kingbase

启动数据库

root@UOS:~# ps -ef | grep -i kingbase
kingbase   1435      1  0 09:35 ?        00:00:00 /lib/systemd/systemd --user
kingbase   1444   1435  0 09:35 ?        00:00:00 (sd-pam)
kingbase   1586      1  0 09:35 ?        00:00:00 /opt/Kingbase/ES/V8/Server/bin/kingbase -D /opt/Kingbase/ES/V8/data
kingbase   1888   1586  0 09:35 ?        00:00:00 kingbase: logger   
kingbase   1902   1586  0 09:35 ?        00:00:00 kingbase: checkpointer   
kingbase   1904   1586  0 09:35 ?        00:00:00 kingbase: background writer   
kingbase   1905   1586  0 09:35 ?        00:00:00 kingbase: walwriter   
kingbase   1906   1586  0 09:35 ?        00:00:00 kingbase: autovacuum launcher   
kingbase   1907   1586  0 09:35 ?        00:00:00 kingbase: stats collector   
kingbase   1908   1586  0 09:35 ?        00:00:00 kingbase: ksh writer   
kingbase   1909   1586  0 09:35 ?        00:00:00 kingbase: ksh collector   
kingbase   1910   1586  0 09:35 ?        00:00:00 kingbase: kwr collector   
kingbase   1911   1586  0 09:35 ?        00:00:00 kingbase: logical replication launcher   
root       5222   5209  0 09:40 pts/0    00:00:00 grep -i kingbase
root@UOS:~# 
kingbase@UOS:/opt/Kingbase/ES/V8/Scripts$ ps -ef | grep -i kingbase
root       5323   5209  0 09:41 pts/0    00:00:00 su - kingbase
kingbase   5324   5323  0 09:41 pts/0    00:00:00 -bash
kingbase   5894      1  0 09:44 ?        00:00:00 /opt/Kingbase/ES/V8/Server/bin/kingbase -D /opt/Kingbase/ES/V8/data
kingbase   5895   5894  0 09:44 ?        00:00:00 kingbase: logger   
kingbase   5897   5894  0 09:44 ?        00:00:00 kingbase: checkpointer   
kingbase   5898   5894  0 09:44 ?        00:00:00 kingbase: background writer   
kingbase   5899   5894  0 09:44 ?        00:00:00 kingbase: walwriter   
kingbase   5900   5894  0 09:44 ?        00:00:00 kingbase: autovacuum launcher   
kingbase   5901   5894  0 09:44 ?        00:00:00 kingbase: stats collector   
kingbase   5902   5894  0 09:44 ?        00:00:00 kingbase: ksh writer   
kingbase   5903   5894  0 09:44 ?        00:00:00 kingbase: ksh collector   
kingbase   5904   5894  0 09:44 ?        00:00:00 kingbase: kwr collector   
kingbase   5905   5894  0 09:44 ?        00:00:00 kingbase: logical replication launcher   
kingbase   5918   5324  0 09:44 pts/0    00:00:00 ps -ef
kingbase   5919   5324  0 09:44 pts/0    00:00:00 grep -i kingbase

停止数据库

专用机装卸启停

数据库的启停与状态查看

ps -ef | grep -i kingbase

kingbase@UOS:~$ 
kingbase@UOS:~$ ps -ef | grep -i kingbase
kingbase   1450      1  0 16:34 ?        00:00:00 /lib/systemd/systemd --user
kingbase   1458   1450  0 16:34 ?        00:00:00 (sd-pam)
kingbase   1553      1  0 16:34 ?        00:00:00 /opt/Kingbase/ES/V8/Server/bin/kingbase -D /opt/Kingbase/ES/V8/data
kingbase   1665   1553  0 16:34 ?        00:00:00 kingbase: logger   
kingbase   1674   1553  0 16:34 ?        00:00:00 kingbase: checkpointer   
kingbase   1675   1553  0 16:34 ?        00:00:00 kingbase: background writer   
kingbase   1676   1553  0 16:34 ?        00:00:00 kingbase: walwriter   
kingbase   1677   1553  0 16:34 ?        00:00:00 kingbase: autovacuum launcher   
kingbase   1678   1553  0 16:34 ?        00:00:00 kingbase: stats collector   
kingbase   1679   1553  0 16:34 ?        00:00:00 kingbase: ksh writer   
kingbase   1680   1553  0 16:34 ?        00:00:00 kingbase: ksh collector   
kingbase   1681   1553  0 16:34 ?        00:00:00 kingbase: kwr collector   
kingbase   1683   1553  0 16:34 ?        00:00:00 kingbase: logical replication launcher   
kingbase   3859      1  0 16:36 ?        00:00:00 /usr/bin/gnome-keyring-daemon --daemonize --login
kingbase   3862   2008  0 16:36 ?        00:00:00 /usr/bin/startdde
kingbase   3876   1450  0 16:36 ?        00:00:00 /usr/bin/dbus-daemon --session --address=systemd: --nofork --nopidfile --systemd-activation --syslog-only

systemctl status kingbase8d.service

kingbase@UOS:~$ service kingbase status 
● kingbase8d.service - LSB: Start and stop the kingbase server
   Loaded: loaded (/etc/init.d/kingbase8d; generated)
   Active: active (exited) since Wed 2022-02-09 16:34:53 CST; 2min 33s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 1381 ExecStart=/etc/init.d/kingbase8d start (code=exited, status=0/SUCCESS)
Warning: Journal has been rotated since unit was started. Log output is incomplete or unavailable.
kingbase@UOS:~$ 
=======================================================
kingbase@UOS:~$ service kingbase8d status
● kingbase8d.service - LSB: Start and stop the kingbase server
   Loaded: loaded (/etc/init.d/kingbase8d; generated)
   Active: active (exited) since Wed 2022-02-09 16:34:53 CST; 2min 44s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 1381 ExecStart=/etc/init.d/kingbase8d start (code=exited, status=0/SUCCESS)
Warning: Journal has been rotated since unit was started. Log output is incomplete or unavailable.
kingbase@UOS:~$ 
=======================================================
kingbase@UOS:~$ sys_ctl -D /opt/Kingbase/ES/V8/data status
sys_ctl: server is running (PID: 1553)
/opt/Kingbase/ES/V8/Server/bin/kingbase "-D" "/opt/Kingbase/ES/V8/data"
kingbase@UOS:~$ 
kingbase@UOS:~$

初始化实例

为了引导数据库系统，一个刚刚被初始化好的系统总是包含一个预定义角色。这个角色总是一个”superuser”，并且默认情况下（除非在运行initdb时修改）它的名字和初始化数据库集簇的操作系统用户相同。习惯上，这个角色将被命名为kingbase。为了创建更多角色，你首先必须以初始角色的身份连接。

初始化前：大小敏不敏感？区分大小写？大小写参数

initdb --dbmode=pg -D /home/kingbase/data

ksql -Ukingbase test

每一个到数据库服务器的连接都是使用某个特定角色名建立的，并且这个角色决定发起连接的命令的初始访问权限。要使用一个特定数据库连接的角色
名由客户端指示，该客户端以一种应用相关的风格发起连接请求。例如，ksql程序使用-U命令行选项来指定要以哪个角色连接。很多应用假定该名字默
认是当前操作系统用户（包括createuser和ksql）。因此在角色和操作系统用户之间维护一个名字对应关系通常是很方便的。

KCA-KCP

KCA：装卸启停