[转帖]Kingbase重新数据初始化，设置大小写

kingbase,重新,数据,初始化,设置,大小写 · 浏览次数 : 0

小编点评

KingbaseV8数据库安装完成后，删除/opt/Kingbase/ES/V8/data下所有内容，重新在其他目录初始化数据库，设置为忽略大小写[kingbase@dbserver bin]$ 1. **清理数据目录** `./initdb -E UTF-8 -U SYSTEM -W kingbase2021 --case-insensitive -D /opt/Kingbase/ES/V8/data` 2. **初始化数据库** `initdb: unable to for local language environment \"zh_CN.UTF-8\" find suitable text search configuration default text search configuration will be set to \"SIMPLE\" disabled for data page generation and checksum calculation. The comparision of strings is case-insensitive. ` 3. **创建子目录和配置** `mkdir -p /opt/Kingbase/ES/V8/data/local/zh_CN.UTF-8` `nano /opt/Kingbase/ES/V8/data/local/zh_CN.UTF-8/kingbase.conf` 4. **设置数据库参数** `set max_connections=100 set shared_buffers=128MB set enable_shared_buffers=true` 5. **运行自举脚本** `./sys_ctl -D /opt/Kingbase/ES/V8/data -l logfile start` 6. **启动数据库进程** `./sys_ctl -D /opt/Kingbase/ES/V8/data -l logfile start` 7. **查看数据库状态** `ps -ef |grep kingbaseroot 3032 2978 0 14:59 pts/0 00:00:00 su - kingbasekingbase 3033 3032 0 14:59 pts/0 00:00:00 -bashroot 3278 3212 0 15:04 pts/1 00:00:00 su - kingbasekingbase 3279 3278 0 15:04 pts/1 00:00:00 -bashkingbase 3401 1 1 15:06 pts/1 00:00:00 /opt/Kingbase/ES/V8/Server/bin/kingbase -D /opt/Kingbase/ES/V8/datakingbase 3402 3401 0 15:06 ? 00:00:00 kingbase: logger processkingbase 3404 3401 0 15:06 ? 00:00:00 kingbase: checkpointer processkingbase 3405 3401 0 15:06 ? 00:00:00 kingbase: writer processkingbase 3406 3401 0 15:06 ? 00:00:00 kingbase: wal writer processkingbase 3407 3401 0 15:06 ? 00:00:00 kingbase: autovacuum launcher processkingbase 3408 3401 0 15:06 ? 00:00:00 kingbase: stats collector processkingbase 3409 3401 0 15:06 ? 00:00:00 kingbase: bgworker: syslogical supervisorkingbase 3415 3279 0 15:06 pts/1 00:00:00 ps -efkingbase 3416 3279 0 15:06 pts/1 00:00:00 grep --color=auto kingbase[kingbase@dbserver bin]$` 8. **启动数据库服务**

正文

KingbaseV8数据库安装完成后，删除/opt/Kingbase/ES/V8/data下所有内容，重新在其他目录初始化数据库，设置为忽略大小写

[kingbase@dbserver bin]$ ./initdb -E UTF-8 -U SYSTEM -W kingbase2021 --case-insensitive -D /opt/Kingbase/ES/V8/data
属于此数据库系统的文件宿主为用户 "kingbase".
此用户也必须为服务器进程的宿主.
数据库簇将使用本地化语言 "zh_CN.UTF-8"进行初始化.
initdb: 无法为本地化语言环境"zh_CN.UTF-8"找到合适的文本搜索配置
缺省的文本搜索配置将会被设置到"SIMPLE"

禁止为数据页生成校验和.

The comparision of strings is case-insensitive.
修复已存在目录 /opt/Kingbase/ES/V8/data 的权限 ... 成功
正在创建子目录 ... 成功
选择默认最大联接数 (max_connections) ... 100
选择默认共享缓冲区大小 (shared_buffers) ... 128MB
选择动态共享内存实现 ......posix
创建配置文件 ... 成功
正在运行自举脚本 ...成功
正在执行自举后初始化 ...成功
create samples database ... 成功
loading samples database ... 成功
loading template2 database ... 成功
create security database ... 成功
load security database ... 成功
同步数据到磁盘...成功

成功。您现在可以用下面的命令开启数据库服务器：

./sys_ctl -D /opt/Kingbase/ES/V8/data -l logfile start

启动数据库
[kingbase@dbserver bin]$ ./sys_ctl -D /opt/Kingbase/ES/V8/data -l logfile start
正在启动服务器进程
[kingbase@dbserver bin]$ ps -ef |grep kingbase
root 3032 2978 0 14:59 pts/0 00:00:00 su - kingbase
kingbase 3033 3032 0 14:59 pts/0 00:00:00 -bash
root 3278 3212 0 15:04 pts/1 00:00:00 su - kingbase
kingbase 3279 3278 0 15:04 pts/1 00:00:00 -bash
kingbase 3401 1 1 15:06 pts/1 00:00:00 /opt/Kingbase/ES/V8/Server/bin/kingbase -D /opt/Kingbase/ES/V8/data
kingbase 3402 3401 0 15:06 ? 00:00:00 kingbase: logger process
kingbase 3404 3401 0 15:06 ? 00:00:00 kingbase: checkpointer process
kingbase 3405 3401 0 15:06 ? 00:00:00 kingbase: writer process
kingbase 3406 3401 0 15:06 ? 00:00:00 kingbase: wal writer process
kingbase 3407 3401 0 15:06 ? 00:00:00 kingbase: autovacuum launcher process
kingbase 3408 3401 0 15:06 ? 00:00:00 kingbase: stats collector process
kingbase 3409 3401 0 15:06 ? 00:00:00 kingbase: bgworker: syslogical supervisor
kingbase 3415 3279 0 15:06 pts/1 00:00:00 ps -ef
kingbase 3416 3279 0 15:06 pts/1 00:00:00 grep --color=auto kingbase
[kingbase@dbserver bin]$

查询数据库设置
[kingbase@dbserver data]$ ksql -Usystem -Wkingbase2021 TEST
ksql (V008R003C002B0340)
Type "help" for help.

TEST=#
TEST=# show case_sensitive;
case_sensitive
----------------
off
(1 row)

TEST=#

本文来自博客园，作者：花之旭，转载请注明原文链接：https://www.cnblogs.com/huazhixu/p/15604909.html