2022金仓数据库基于Linux系统的数据库软件安装指南

金仓数据库管理系统KingbaseESV8.62022年9月6日目录目录HYPERLINKHYPERLINKHYPERLINKHYPERLINKHYPERLINK....................................................HYPERLINKHYPERLINK....................................................HYPERLINKHYPERLINK.......................................................HYPERLINKHYPERLINK....................................................HYPERLINKHYPERLINKHYPERLINKHYPERLINKHYPERLINK....................................................HYPERLINKHYPERLINK..................................................HYPERLINKHYPERLINKHYPERLINK...................................................HYPERLINKHYPERLINKHYPERLINKHYPERLINKHYPERLINK..................................................HYPERLINKHYPERLINK..................................................HYPERLINKHYPERLINK...................................................HYPERLINKHYPERLINK.................................................HYPERLINKHYPERLINK...........................................HYPERLINKHYPERLINK.......................................HYPERLINKHYPERLINK..............................................HYPERLINKHYPERLINK...................................................12HYPERLINKHYPERLINK..............................................12HYPERLINKHYPERLINK................................................12HYPERLINKHYPERLINK................................................13HYPERLINKHYPERLINK..........................................13HYPERLINKHYPERLINKHYPERLINKHYPERLINKHYPERLINKHYPERLINK...................................................16HYPERLINKHYPERLINK..............................................16HYPERLINKHYPERLINK................................................19HYPERLINKHYPERLINK...............................................20HYPERLINKHYPERLINK...........................................21HYPERLINKHYPERLINK..............................................22I目录HYPERLINKHYPERLINK.............................................23HYPERLINKHYPERLINK...............................................24HYPERLINKHYPERLINK................................................25HYPERLINKHYPERLINK..............................................26HYPERLINKHYPERLINK................................................28HYPERLINKHYPERLINKHYPERLINK...............................................29HYPERLINKHYPERLINK...................................................30HYPERLINKHYPERLINK..............................................30HYPERLINKHYPERLINK...................................................30HYPERLINKHYPERLINK................................................31HYPERLINKHYPERLINK...............................................32HYPERLINKHYPERLINK...........................................33HYPERLINKHYPERLINK..............................................34HYPERLINKHYPERLINK.............................................34HYPERLINKHYPERLINK...............................................35HYPERLINKHYPERLINK................................................36HYPERLINKHYPERLINK................................................36HYPERLINKHYPERLINK..............................................37HYPERLINKHYPERLINK................................................40HYPERLINKHYPERLINKHYPERLINK...............................................41HYPERLINKHYPERLINK....................................................41HYPERLINKHYPERLINK...........................................41HYPERLINKHYPERLINK................................................43HYPERLINKHYPERLINK..............................................43HYPERLINKHYPERLINKHYPERLINKHYPERLINKHYPERLINKHYPERLINKHYPERLINKHYPERLINKHYPERLINK.................................................47HYPERLINKHYPERLINK...................................................47HYPERLINKHYPERLINK................................................47HYPERLINKHYPERLINK................................................49HYPERLINKHYPERLINK................................................49HYPERLINKHYPERLINK................................................50HYPERLINKHYPERLINK...................................................51HYPERLINKHYPERLINK................................................51HYPERLINKHYPERLINK................................................52HYPERLINKHYPERLINK................................................52HYPERLINKHYPERLINK................................................52HYPERLINKHYPERLINK....................................................53HYPERLINKHYPERLINKHYPERLINKHYPERLINKHYPERLINK.................................................55II目录HYPERLINKHYPERLINK................................................55HYPERLINKHYPERLINK...........................................55HYPERLINKHYPERLINK...........................................56HYPERLINKHYPERLINK..............................................57HYPERLINKHYPERLINK.........................................58HYPERLINKHYPERLINK...........................................59HYPERLINKHYPERLINK...........................................59HYPERLINKHYPERLINK................................................59HYPERLINKHYPERLINK...........................................59HYPERLINKHYPERLINK...........................................60HYPERLINKHYPERLINK..............................................61HYPERLINKHYPERLINK.........................................62HYPERLINKHYPERLINK...........................................63HYPERLINKHYPERLINK...........................................64HYPERLINKHYPERLINK.................................................64HYPERLINKHYPERLINK................................................64HYPERLINKHYPERLINK...........................................64HYPERLINKHYPERLINK.........................................66HYPERLINKHYPERLINK...........................................67HYPERLINKHYPERLINK...........................................68HYPERLINKHYPERLINK................................................68HYPERLINKHYPERLINK...........................................68HYPERLINKHYPERLINK.........................................70HYPERLINKHYPERLINK..........................................71HYPERLINKHYPERLINKHYPERLINKHYPERLINKHYPERLINK...............................................72HYPERLINKHYPERLINK...................................................73HYPERLINKHYPERLINK...............................................74HYPERLINKHYPERLINK..................................74HYPERLINKHYPERLINKHYPERLINKHYPERLINK........................................74HYPERLINKHYPERLINK....................................74HYPERLINKHYPERLINK..........................................75HYPERLINKHYPERLINK.............................76HYPERLINKHYPERLINK......................................76HYPERLINKHYPERLINK..................................76HYPERLINKHYPERLINKHYPERLINK.........................76HYPERLINKHYPERLINKHYPERLINKHYPERLINKHYPERLINK..76HYPERLINKHYPERLINK）.45第5章ksql${./ksql-p54321-Usystemtest-p参数指定初始化数据库时设置的端口。-U参数指定初始化数据库时设置的管理员用户，也可以是其他ksqlKingbaseES_ksqlksqlKStudio.5${./kingbaseV;ksqlselectversion();6.soso${安ldd*|grep"notfound"在${,sols${so${,exportLD_LIBRARY_PATH=$LD_LIBRARY_PATH:`pwd`${,soKingbaseESV8.6:46第6章第6章卸载KingbaseES•••HYPERLINK\l"br51"HYPERLINK\l"br55"HYPERLINK\l"br57"6.1删除数据库服务root.shrootuninstall.sh123..root.${}/install/script/rootuninstall.sh。6.2图形化卸载6.2.1启动卸载kingbase${}/UninstallshUninstaller-iswing47第6章图6.2.1:48第6章6.2.2确认卸载图6.2.2:6.2.3正在卸载49第6章图6.2.3:6.2.4完成卸载50第6章图6.2.4:6.3控制台卸载6.3.1启动卸载kingbase${}/UninstallshUninstaller-iconsole51第6章6.3.2准备卸载图6.3.1:输入quit再按退出卸载过程；直接按继续进行下一步。若无特殊说明，以下各步骤皆6.3.3正在卸载图6.3.2:6.3.4完成卸载52第6章图6.3.3:6.4静默卸载kingbase${}/UninstallshUninstaller-isilent-i-i53第7章第7章增删组件KingbaseESV8.6图7.1:••HYPERLINK\l"br59"HYPERLINK\l"br68"54第7章7.1图形化增删组件7.1.1增加组件启动入口以kingbase用户登录系统后，进入安装程序setup.sh所在目录，执行setup.sh。选择“修改存在的实例”并选图7.1.1:55第7章添加功能图7.1.2:56第7章确认图7.1.3:57第7章选择功能组件图7.1.4:58第7章安装进度图7.1.5:此步骤用于显示安装进度。如果选择的组件包含数据库服务器，则后续会继续选择授权文件、初始化数据库步完成安装100%7.1.2删除组件启动入口以kingbasesetup59第7章shsetup.sh-iswing准备卸载图7.1.6:60第7章确认图7.1.7:61第7章选择功能组件图7.1.8:选择需要卸载的功能组件，取消其勾选状态；点击【卸载】按钮，开始删除操作。点击【取消】按钮，取消卸62第7章正在移除图7.1.9:63第7章卸载完成图7.1.10:7.2命令行增删组件7.2.1增加组件启动入口setup.shkingbaseshsetup.sh-iconsole64第7章图7.2.1:2165第7章选择功能组件图7.2.2:按照提示按，显示可以添加的组件列表。输入不需要安装的组件编号，多个编号用逗号隔开。按<:66第7章安装进度图7.2.3:此步骤用于显示安装进度。如果选择的组件包含数据库服务器，则后续会继续选择授权文件、初始化数据库步67第7章完成安装图7.2.4:7.2.2删除组件启动入口以kingbase${}/UninstallshUninstaller-iconsole68第7章图7.2.5:2269第7章选择功能组件图7.2.6:70第7章删除及完成图7.2.7:71第8章第8章附录•••HYPERLINK\l"br76"HYPERLINK\l"br77"HYPERLINK\l"br78"8.1静默安装配置文件#1licensefilepath,forexample/home/kingbase/license_1309_0-sales.datforlinuxorC:\\license_309_0-sales.datforwindowsKB_LICENSE_PATH=installset,optionsareFull,Client,CustomCHOSEN_INSTALL_SET=Fullcomponentlist,optionsareSERVER,KSTUDIO,KDTS,INTERFACE,DEPLOY,KINGBASEHACHOSEN_FEATURE_LIST=SERVER,KSTUDIO,KDTS,INTERFACE,DEPLOY,KINGBASEHAinstalldirpath,forexample/opt/Kingbase/ES/V8forlinuxorC:\\ProgramFiles\\Kingbase\\ES\\###V8forwindowsUSER_INSTALL_DIR=/opt/Kingbase/ES/V8#datadirpath,forexample/opt/Kingbase/ES/V8/dataforlinuxorC:\\ProgramFiles\\Kingbase\\ES\\V8\\dataforwindowsUSER_SELECTED_DATA_FOLDER=##initdbparamsserverport,requied,between1and65535DB_PORT=54321username,required,lengthlessthan63bytesDB_USER=systempassword,requiredDB_PASS=1passwordconfirm,requiredDB_PASS2=1encoding,required,optionsareUTF8,GBK,GB18030ENCODING_PARAM=UTF8####72第8章#compatibilitymode,required,optionsareORACLE,PGDATABASE_MODE_PARAM=ORACLEcasesensitivity,required,optionsareYES,NOCASE_SENSITIVE_PARAM=YESblocksize,required,optionsare8k,16k,32k##BLOCK_SIZE_PARAM=8k8.2目录一览表数据库安装完成后，进入安装目录，使用ll或者ls-l列出数据库安装后生成的目录和文件，下面列出主要文件和目录清单。由于完全安装、客户端安装、定制安装安装的服务不同，对应生成的文件目录也有所不同，请以实际的安装为准。KESRealPro目录下按版本号放置不同版本的程序内容。安装根目录下的其他目录和文件都是软连接，实KESRealPro•–Server/bin：服务器二进制文件，可以在该路径下进行启动服务、连接数据库、物理备份还原、逻辑备份•–guitools/KStudio：开发管理工具，能运行在各种平台的图形工具，用于管理和配置King-baseES数据库服务器，管理各种KingbaseES数据库对象，进行KingbaseES数据库的安全管理，调用SQL––ClientTools/guitools/KDts：数据库迁移工具，可以用于跨平台数据交换和迁移，支持同异构数据源之间ClientTools/